sql server new users: newbie: databases attach as read-only -- sql server new users

Re: newbie: databases attach as read-only

Roger Wolter[MSFT]
6/25/2007 10:18:56 AM

sql server new users: The most likely reason it attached as read-only is that the Windows user
that SQL Express is running as (by default NetworkService) doesn't have
controlling writes on the .mdf and .ldf files and the directory they're in.
While Adam's answer is in fact required, It may not work if without also
changing the Windows permissions.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

Re: newbie: databases attach as read-only

Adam Machanic
6/25/2007 12:40:12 PM

ALTER DATABASE YourDatabase SET READ_WRITE

--

Adam Machanic
SQL Server MVP

Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220

[quoted text, click to view]

newbie: databases attach as read-only

R.A.M.
6/25/2007 6:32:11 PM

Hello,
I would like to ask you such question. I created database but after
reinstalling Windows XP and SQL Server 2005 it attaches as read-only. What
should I do to have full access?
Thanks for help
/RAM/

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.