March 4, 2009 at 5:25 pm
Hi there, on our production sql server 2000 we have problem with both the instances...the services are stopped and when we start the service we get following error from application logs...
The system cannot find the file specified.) reading configuration information from 'D:\SQL Server\MSSQL$SEW\data\master.mdf'.
I have checked that path, we already have master.mdf file over there....I don't know why this happened...Please urgent reply is highly required as this is our production server and it is down now......Please reply asap.....
March 4, 2009 at 5:40 pm
please go to the error log and you will see more information and post the error message here to get more help..
March 4, 2009 at 5:41 pm
Check the file/directory permissions. If the service account SQL Server is starting under doesn't have rights to the directory/file you'll get that message.
A short-term fix might be to change the SQL Server services to run under the LocalSystem "account", but that's not recommended as a permanent solution.
March 4, 2009 at 5:55 pm
Are the master databases for both instances stored on the same drive? When did this problem start? Were any changes made to the accounts under which the server runs?
March 4, 2009 at 6:02 pm
master dbs are on the same drive...
I have also tried using local system account...but same problem
Please let me know asap...thanks all
March 4, 2009 at 6:08 pm
Hi All,
I got the problem..Actually when I went to my computer and rightclick and goto manage and goto disk management...I was only able to see C: and G: the other drives are not there....It is a storage problemmm....I have called our storage guy and he is working on this...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply