Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DaveDelgado
Starting Member
1 Post |
 Posted - 2009-08-18 : 18:18:17
|
| Hi All,I'm using Windows Vista for Business SP1 and SQL Server 2005 SP3. I moved some sample database and log files out of their home folders, uninstalled SQL Server 2005, reinstalled SQL Server 2005, added SP3 and attempted to use CREATE DATABASE ... FOR ATTACH to re-attach the database files. I receive the following error message.Msg 5120, Level 16, State 101, Line 1Unable to open the physical file "C:\SQL\DATA\BigPubs2005.MDF". Operating system error 5: "5(Access is denied.)".Since I didn't use sp_detach_db to detach the tables from SQL Server before the uninstall/reinstall I believe this may be the cause of the error. Any suggestions on how to resolve this problem ?Any help or thoughts would be appreciated.Regards,DD |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-18 : 18:33:24
|
Error 5 is an OS file permission error.Make sure the account for which SQL Server is running with, also have privileges to the directory where the files are stored.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
Error 5 Access Denied (Vista)