RE: sp_attach_db on Vista causes read only problems
- From: petery@xxxxxxxxxxxxxxxxxxxx ("Peter YangMSFT]")
- Date: Tue, 12 Jun 2007 08:35:26 GMT
Hello Tony,
My understanding of the issue is: You attach databases to SQL Express in
Vista, but you cannot run any SP to add login etc because they are "read
only". If it's not correct, please let me know.
Based on my experience, this issue could occur if the SQL Server service
startup account does not have the proper permission on the folder hosting
the MDF/LDF files. You may try to use "local system" account as startup
account to see if the issue persists.
If it helps, you may want to change back to the original account and grant
full control permission to the folder to test. Please see following link
for more related information:
Setting Up Windows Service Accounts
http://msdn2.microsoft.com/en-us/library/ms143504(SQL.90).aspx
Also, please make sure the mdf/ldf files in the folder is not marked as
"read-only".
If you have further questions or any updates, please feel free to let's
know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
.
- Follow-Ups:
- References:
- Prev by Date: sp_attach_db on Vista causes read only problems
- Next by Date: Re: sp_attach_db on Vista causes read only problems
- Previous by thread: sp_attach_db on Vista causes read only problems
- Next by thread: Re: sp_attach_db on Vista causes read only problems
- Index(es):
Relevant Pages
|
