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 |
|
joydeep1985
Starting Member
5 Posts |
 Posted - 2009-08-31 : 09:28:29
|
| i have an administrator account named as Gen_x in windows..and now i have a database files under D:\Databases namely airlines.mdf and airlines_log.ldf ... now when i m trying to attach this file under the sql server 2005 management studio... it gives me peculiar error as : CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'D:\Databases\Airlines.mdf'. (.Net SqlClient Data Provider)(Microsoft SQl Server ,Error :5123)can someone please explain why this happened ???? previously i attached this sucessfully.... but had to copy the database ... so had detached d database once ... and then again copied it ... and after that i m now not able to attach the database again...can someone tell why this error has occured and what is d solution to attach the database again to sql server database management studio |
|
|
dbaadm
Starting Member
10 Posts |
Posted - 2009-08-31 : 09:51:31
|
| Sounds like you've got permission issues on the files.Does the account that runs the SQL instance have permissions on the folder hosting the files? |
 |
|
|
DeepGround
Yak Posting Veteran
73 Posts |
Posted - 2009-08-31 : 11:53:19
|
| I am going to guess you are running Server 2008, if so there is your problem. Administrators do not get access to all drive locations anymore. Simply add the permissions to the folder/file manually. |
|
|
|
joydeep1985
Starting Member
5 Posts |
Posted - 2009-08-31 : 12:08:22
|
| how to add the permissions to the folder/files manually ????? in case of this perticular problem of mine ??????? i mean whc kinda permission i need to add inside the sql server or OS related permission ? can u explain with an example ?????? |
|
|
|
|
|
|
SQL server Management Studio Database Add problem