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.ldf
We 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 currupt
Some of our Domain settings changed recently. But we believe the Server startup is under the correct account.
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 account
As 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?
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.
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 file
Can't Start - could not open file mastlog.ldf
Posted - 01/31/2013 : 17:20:04
