![]() ![]() In the second case, it has nowhere to write the log entries. In the first case, SQL Server won’t even begin the startup routine and hence won’t log anything. Either the defined location for the error log files is not there, or the SQL account does not have permission on it. ![]() The service encountered a login failure (service account password invalid or account locked or disabled).Two cases where there won’t be a relevant error log entry are if: If SQL Server at least started its startup routine before it failed, then it will have logged whatever error it encountered that prevented the service from starting completely. To find the cause of the startup failure, navigate to that folder and, in Notepad, open the latest error log file (called ERRORLOG) and scroll right to the bottom. This is the default location for the error log for the default instance of SQL Server 2008. “ C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\” ![]() The -e parameter is the one we need and, in my case, I can see that my error log should be in the folder: If you’re unsure of its location, check the startup parameters of the SQL Server service in SQL Server Configuration Manager, as shown in Figure 3. The SQL error log is just a text file on disk. The Windows Application Event Log will do as well, but I prefer the SQL error log, as I can see all the messages at once, and not have to click on them one by one. The first place you should start looking for the cause is the SQL Server error log. It just gives the same “Service specific error occurred” message. Oh, and just in case the message in Figure 2 raised your hopes, more help is not available by running NET HELPMSG 3547. Neither of these messages helps identify a cause for the startup failure. The first and most obvious symptom will be that the SQL Server service is not running and an error greets your attempts to restart it.Īlternatively, if you tried to start the service from the command prompt… Common Symptoms and Initial Troubleshooting
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |