February 8, 2008 at 6:03 pm
Hi All,
I've created a database from a backup and it's now read only. The actual file on disk is not read only. I've tried to use Management Studio Express in the Properties/Options dialog to change the database to writeable and get a message that it's unable to open the database file because of an operating system error 4, Access denied. I'm logged onto the OS as an administrator and am connected to the database as sa.
How can I make this database writeable?
Thanks,
Steve
February 18, 2008 at 6:23 am
how did you restore the database? maybe you have used NORECOVERY or STANDBY modifier?
Piotr
...and your only reply is slàinte mhath
February 18, 2008 at 9:35 am
If you stop SQL Server, can you get to the file?
It might be that the Service Account for SQL Server does not have permissions to the file on disk.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply