Last post Apr 23, 2009 11:22 PM by chetan.sarode
Jan 05, 2009 10:13 AM|arkiboys|LINK
I can now add projects, assign users, etc...
I am now investigating the database side of this project. It seems the data is being save in sql server .mdf file
There is now a TimeTracker.mdf in the data folder of sql server but I can NOT create this database in the object explorer using attach database.
When doing this in sql 2005 by right click, new database; this is the error I get:
create database failed. some file names listed could not be created. Check related errors. Can not create file 'c:\program files\...\TimeTracker.mdf' because it already exists. change the filepath or the file name, and retry the operation.
Note that there is a .mdf file in the above path already and I would
like to use that as the database.
So I try to attached this .mdf file, and I get this error when attaching it:
create file encouontered operating system error 32(error not found) while attempting to open the physical file 'c:\program files\TimeTracker.mdf' (Error 5123)
Any suggestions please?
Jan 05, 2009 12:57 PM|Lolli|LINK
You need to attach the database in SQL Server Management Studio and not create it.
Jan 07, 2009 10:25 PM|chetan.sarode|LINK
Time Tracker use the TimeTracker.mdf' under SQL Server Express,
So you have to attach to Sql server Management studio.
Jan 09, 2009 02:53 AM|arkiboys|LINK
The system does not allow me to attached.
Jan 09, 2009 11:27 AM|Lolli|LINK
Is this a local server?
Jan 09, 2009 05:31 PM|arkiboys|LINK
Yes it is.
Jan 10, 2009 07:23 AM|RickNZ|LINK
Check to make sure that the sqlservr.exe user has read and write access to the MDF file. You can see who the user is with Task Manager.
Jan 10, 2009 05:18 PM|arkiboys|LINK
It shows Administrator who is me logged in to the machine.
Jan 12, 2009 10:24 PM|chetan.sarode|LINK
Try to install VS 2005 SP1 and other other related updates
May solve this one
Jan 23, 2009 02:09 AM|kathirvelmm|LINK
EXEC sp_attach_db @dbname = 'PUBS',
@filename1 = '\Program Files\Microsoft SQL Server\MSSQL\Data\PUBS.mdf',
@filename2 = '\Program Files\Microsoft SQL Server\MSSQL\Data\PUBS_LOG.ldf'
sp_detach_db [ @dbname = ] 'dbname'
[ , [ @skipchecks = ] 'skipchecks' ]
Jan 23, 2009 12:50 PM|KentWA|LINK
When you have the web site open in Visual Studio you can use the Database Explorer to examine the database. You should find it on the View menu of VS.
Jan 29, 2009 10:28 PM|chetan.sarode|LINK
What is the status, Please update
Feb 04, 2009 10:25 PM|chetan.sarode|LINK
Have solved your error
Feb 11, 2009 10:01 PM|xzf2001|LINK
if you start the vs,it may be use the database.you should to release it!
Feb 25, 2009 10:22 PM|chetan.sarode|LINK
Any updates on this
Mar 10, 2009 02:21 AM|kathirvelmm|LINK
close your post when resolved that helps fellow users
Mar 10, 2009 03:06 AM|arkiboys|LINK
Mar 10, 2009 11:28 PM|chetan.sarode|LINK
Please mark the replies as answers if they help, Let other users get benefited.
Apr 23, 2009 11:22 PM|chetan.sarode|LINK
Please mark the answer if it solved