Sometimes you will encounter a pre-installed copy of SQL server that does not have an instance name setup, thus it makes it difficult to get the SSLIP to interact with the server.

To rectify this, you will rename the instance to something recognizable, preferably CYRIOUS

To rename the sql instance, do the following:

Do not run this without first verifying that only Control is used by this SQL instance. If there are other programs which utilize databases on the instance you will cause those programs to stop functioning.

Run the query below to get the current instance name:

SELECT @@servername

Run the code below, putting the current server's name in place of “SERVER NAME”, and type in the new name of the sql instance in place of “NEW SERVER NAME”

EXEC master.dbo.sp_dropserver ‘[SERVER NAME]‘
EXEC master.dbo.sp_addserver ‘[NEW SERVER NAME]‘, ‘LOCAL’

After this, you can run the query below to verify the sql instance name has changed.

SELECT @@servername