March 10, 2008 at 6:03 am
hi i am intern working on sql server 2000 on windows server 2000 and was trying to configure log shipping but now i m not able to connect to sql server (local). it is saying that operating system error 5 access denied to c:\program files\.........\data\master.mdf at starting master database and also could not open master.mdf for virtual device number. please help me
thanks in advance
March 10, 2008 at 2:19 pm
Most likely, it is a security issue. Ask your DBA ro check.
It may also be the mess of database configuration. But it is weird.
Here are some links for your future references.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=283827&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2889754&SiteID=1
March 11, 2008 at 8:41 am
This is usually due to the account which is running SQL server. It would appear that your service account does not have access to the local system file. Check the account which is running SQL by going into your services.msc and double click "SQL Server (InstanceName)" and check the logon tab.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply