sqlservr.exe – Error – “Multiple instances of SQL server are installed on this computer. Renter the command, specifying the -s parameter with the name”

Background

Trying to change collation from binary to something easier to work such as case-insensitive.

 

Error Message

Textual

Multiple instances of SQL server are installed on this computer. Renter the command, specifying the -s parameter with the name

 

Remediation

Specification

Specify the Instance Name by utilizing MSSQLSERVER for the default instance; for named instance, please use the named instance name.

 

Code


set "_FLD=E:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn"
set "_APP=sqlservr.exe"
 
set "_COLLATION=Latin1_General_CI_AS"
 
set "_INSTANCE=MSSQLSERVER"
 
"%_FLD%\%_APP%" -s %_INSTANCE% -m -T4022 -q%_COLLATION%

 

Collations

Collation Meaning
Latin1_General_CI_AS Latin Case Insensitive
Latin1_General_BIN2 Binary

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s