How to troubleshoot SQL Server error 17112

Symptoms

When you attempt to start an instance of SQL Server, the instance fails to start with the following message in the Windows Application event log:

Log Name:      Application
Source:        MSSQL$SQL2008
Event ID:      17112
Task Category: Server
Level:         Error
Description: An invalid startup option a was supplied, either from the registry or the command prompt. Correct or remove the option.

In some cases, the instance might start, but when you review the SQL Server Error log, the startup parameters do not look right:

2010-01-11 17:34:43.81 Server      Registry startup parameters:
2010-01-11 17:34:43.81 Server             -d D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-01-11 17:34:43.81 Server             -e D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-01-11 17:34:43.81 Server             -l D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-01-11 17:34:43.81 Server            -T1118 -g512
Notice how both the last two startup parameters are on the same line.

You may also notice in some cases that adding the necessary startup parameters did not have the intended effect on the server behavior.

Cause

You encounter these problems due to the following reasons:
  1. Using startup parameters that are not present in the valid list of startup parameters
  2. Specifying startup parameters without the proper delimiters [;]
  3. Copy and paste the startup parameters from text editors that introduced some invisible special characters [e.g. a space before the -T]
  4. Not using the correct case sensitivity for the startup parameter

Resolution

Use the SQL Server Configuration Manager tool to specify and validate the startup parameters specified for the instance of SQL Server. Ensure each one of the startup parameters are delimited properly and that no special characters are present.

More Information

Refer to the following topics for more information on this topic:
Did you start your SQL Server Engine correctly?
Using the SQL Server Service Startup Options
How to: Configure Server Startup Options (SQL Server Configuration Manager)

For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:

Rule softwareRule titleRule descriptionProduct versions against which the rule is evaluated 
SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA)




Invalid startup parameters specified for SQL Server





The SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) provides a rule to detect situations where the SQL Server instance is configured with invalid or wrong startup parameters. The SQL Server 2008 R2 BPA supports both SQL Server 2008 and SQL Server 2008 R2. 

If you run the BPA tool and encounter an Error with the title of Database Engine - Invalid startup parameters specified for SQL Server, then you need to verify the startup parameters specified for this instance of SQL Server and make necessary corrections.
SQL Server 2008
SQL Server 2008 R2






 
SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA)



Invalid startup parameters specified for SQL Server



The SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) provides a rule to detect situations where the SQL Server instance is configured with invalid or wrong startup parameters.

If you run the BPA tool and encounter an Error with the title of Database Engine - Invalid startup parameters specified for SQL Server, then you need to verify the startup parameters specified for this instance of SQL Server and make necessary corrections.
SQL Server 2012







Proprietà

ID articolo: 2028433 - Ultima revisione: 02 apr 2012 - Revisione: 1

Feedback