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 |
|
azharrahi
Starting Member
44 Posts |
 Posted - 2009-08-18 : 13:02:33
|
| I have attached two databases and both of them are showing Readonly.When I try to change the State in properties from Readonly True to False. It shows an error as follows:Unable to open the physical file "E:\DataBase\Quisa.mdf". Operating system error 5: "5(Access is denied.)".Database 'Quisa' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.why this is happening. What is the problem?Azhar RahiSoftware EngineerExperts Desk Pvt Ltd,Lahore Pakistan |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-18 : 13:35:41
|
| make sure (1) you have permissions on E:\DataBase (2) that the share is not read only and (3) that the SQL Service account has permissions on it. |
 |
|
|
azharrahi
Starting Member
44 Posts |
Posted - 2009-08-18 : 15:23:27
|
| yes I know its permissions problem. But how can I check that SQL Service account has permissions on E:\Database ?Azhar RahiSoftware EngineerExperts Desk Pvt Ltd,Lahore Pakistan |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-18 : 16:19:26
|
| in the services applet, look at the login tab for MSSQLSERVER. Then using windows, navigate to folder, right-click, click permissions.also, your network admin can verify this for u |
|
|
|
azharrahi
Starting Member
44 Posts |
Posted - 2009-08-19 : 13:17:44
|
| Well my problem is solved. Thanks all who gave me clues.What I have done is ... I give rights to the Drive ... I created a new Group with name Everyone and gave them full rights. Well for the people who may have this problem should check the rights on the Drives where the database exist.For this, follow the steps:1. Right click on Drive, then click Properties.2. You will find a security tab, click it. (if you do not find it there, then go to Tools -> Folder Options and click View Tab. Then in the Advance Settings, uncheck the last option which describes: Use Simple File Sharing (Recommended))3.Under Group or user names, there is a group with name Everyone. (And if you find no such group, then click Add button and create a new group with name Everyone.)4. Give Everyone group full rights (or at least Read/Write rights.)5. Then click okThis helped for me.ThanksByeAzhar RahiSoftware EngineerExperts Desk Pvt Ltd,Lahore Pakistan |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-19 : 13:34:43
|
| shouldn't give everyone full control on drive. just sql service account and domain/local admins |
|
|
|
|
|
|
|
|
Database readonly state is not changing