Sql Server Error 17113
Hi all,
This video shows you how to fix sql server service into sql server configuration manager.
In this article, we are covering the common scenarios of SQL Service startup failures and troubleshooting approach to resolve these issues:
1. For standalone instance of SQL, always use SQL Server configuration manager to start the SQL database Engine service. For Clustered instance of SQL, always use Fail over Cluster manager tool to start the SQL Database engine service.
Error while starting SQL service using Configuration manager:
Error While starting service from services.msc:
2. Start SQL Server from the command prompt to rule out issues such as permissions or WMI issues or service account related issues. When you start SQL Server from the command prompt, it starts as an application, not a service, with the credentials of the currently logged-in Windows user.
To start SQL Server from command prompt:
Locate the SQL Database engine service and copy “Path to executable” section.
Open command prompt in run as administrator mode and paste the above path and use -c parameter as mentioned below:
If you are successfully able to start the SQL Service, then it’s an indication that the SQL Service account used to start the SQL Service (permission, password, locked out) need to be reviewed.
If you are not able to start the SQL Service using command prompt as well, review the Error log.
3. Check if an Errorlog entry is getting created when the SQL Service is started:
If it is not generated,
- Check startup parameters & ensure the path and files exists (master.mdf, Error log, mastlog.ldf).
- Check registry for startup parameters.
4. Check the permissions on startup parameters to check if SQL Service account has read permissions on master database files and write permission to create Error log file.
For example, permission error on master database file:
To troubleshoot permission issues, take process monitor while reproducing the issue and review ACCESS DENIED reported by sqlservr.exe
32 bit 64 bit yukseltme. Reviewing the event properties will show the user and the set of permissions needed. Accordingly setup the required permissions.
5. From SQL 2012, Configuration manager has a new tab for Startup parameters. This will assist in scenarios where SQL service startup issues are reported because of parameters not being added correctly (examples include missing semi-colon, white-spaces etc).
6. While reviewing the Error log, check for “Recovery is complete” message like below:
Sql Server 2012 Error 17113
Even though startup parameter values are intact, if model and tempdb database files are not accessible, SQL Service will not start. Similarly, MSDB database files are needed for SQL Agent service startup.
Review the SQL Error log to check if there are any issues in accessing the system database files.
For example, in the below error log, model database is not accessible:
7. If the SQL Service startup fails with the error “logon failure”, review the Windows event viewer system log:
User name and password is incorrect:
User Account is locked out:
Based on the above error, accordingly take an appropriate action to reset the password/unlock the account.
8. SQL Service may not start if the System databases are corrupt.
If the system databases are corrupt, supported options to recover the system databases are either restore the system databases from last known good backup or rebuild the master database.
9. Check if SQL Service startup issue is due to OS 32 error (The process cannot access the file because it is being used by another process.):
For example:
In the above scenario, some other process/application has a lock on master database ldf file and this isn’t allowing SQL to take access, hence the service fails to start. To find out which process it is you can use either process explorer or handle.exe tool. The usual culprits are Anti-Virus or Anti-Malware services.
10. Check if SQL Server is configured for SSL encryption. If there are any SSL certificates loaded in SQL Server and certificate doesn’t meet the requirements of SQL Server, SQL service wont start.
For example:
To check if certificate is loaded in SQL, refer the below registry key:
Check in SQL Configuration manager, if the certificate used is listed in drop down list.
If SSL encryption for SQL Server is not needed, then remove the thumbprint entry from the SQL registry and restart the SQL Service. If SSL encryption to SQL is needed, then SSL certificate used for encryption need to evaluated to check if it meets the pre-requisites.
List Of Sql Server Error Codes
11. You can also use the below parameters as startup parameter to troubleshoot further:
Hope the above steps shared help you troubleshoot SQL service startup issues.
Please share your feedback, questions and/or suggestions.
Thanks,
Don Castelino Premier Field Engineer Microsoft
Sql Server Error 17113
Disclaimer: All posts are provided AS IS with no warranties and confer no rights. Additionally, views expressed here are my own and not those of my employer, Microsoft.