sql_query_to_rename_a_sql_server_instance [Support]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.





===== Explanation =====



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:



==Caution==



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.



==Process==



Run the query below to get the current instance name:



<code sql>
SELECT @@servername
</code>



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"



<code sql>
EXEC master.dbo.sp_dropserver ‘[SERVER NAME]‘
EXEC master.dbo.sp_addserver ‘[NEW SERVER NAME]‘, ‘local’
</code>



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



<code sql>
SELECT @@servername
</code>