Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2013-01-31 : 17:20:04
|
We are not able to start our SQL Server. We needed to do a Server Reboot and have had no luck since. We get this message: could not open file mastlog.ldfWe have tried the following:- verified mastlog.ldf exists- verified permissions on mastlog.ldf- verified start-up parameters- we were able to attach this Master Database on another server under another Database name suggesting it is not curruptSome of our Domain settings changed recently. But we believe the Server startup is under the correct account.Does anyone have any ideas? |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-02-01 : 13:04:12
|
I had a similar problem recently - and it related to the SQL Server Service Account being taken out of the correct Domain Group.In this case we weren't using Local System for start up account , but an AD authenticated accountAs an experiment - could you add the Service account to the Administrator group and check if this works.Are you seeing any messages in the Event Viewer error logs? If so , what are they?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2013-02-01 : 13:31:56
|
Thankyou.This is the message we are finding in the event viewer: FCB::Open failedC:\MSSQL\MSSQL10.GLOBDEV\MSSQL\DATA\mastlog.ldfI am not sure what you mean by the SQL Service account. But the Log on as in the SQL Server configuration Manager is: NT Authority\Network Service. |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-04 : 05:56:12
|
Have you checked whether this ldf file exists under the specified location; copy C:\MSSQL\MSSQL10.GLOBDEV\MSSQL\DATA\ to windows explorer and check whether mastlog.ldf exists or not. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-02-05 : 04:47:09
|
If it does exist , then the error message is probably due to the account the SQL Server service runs under doesn't have sufficient permissions to the folder containing the log files. Check the security on the folder for the account accessing the fileJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2013-02-05 : 10:52:56
|
Thanks. The files do exist (and in the right place). And we set the permissions on the 2 Master Database files to Everyone can read/write.Just making sure I understand. Is the SQL Server Service Account meaning what you put in the Servive is the Log On as? |
|
|
|
|
|