We help IT Professionals succeed at work.

changing the name of the server

jward117
jward117 asked
on
Our server name was changed on the domain after SQL 6.5, the databases, scheduled tasks, etc. were created.  Everything in SQL works fine, except the server name is still shown as the old name within SQL server.  I'm running NT4.0 SP6, SQL Server 6.5 SP5a.  Can I go into the sysservers table within the Master database and change the name in both the srvname & srvnetname fields without adversely effecting the databases, scheduled tasks, etc.?  And if so, is there anything else that I need to do (i.e., change a setting, run a stored procedure, etc.)?  Is there anywhere else that I would also need to make a change to the name - or is it stored only in the sysservers table within the Master database?
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2012
Commented:
From MSDN:

<quote>
How to change to the current server name in the SQL Server 6.5 master database (ISQL/w)
To change to the current server name in the SQL Server 6.5 master database

Start Microsoft? SQL Server? in minimal configuration mode. In a command prompt window, from the \Mssql\Binn directory, run:
sqlservr -f

On the Start menu, point to Programs /Microsoft SQL Server 6.5, and then click ISQL/w.

Enter the sa password, and then click Connect.

Execute SELECT @@SERVERNAME to retrieve the former server name.

Execute sp_dropserver to drop the former server.

Execute sp_addserver to add the current server.

Stop SQL Server. In the command prompt window, press Ctrl+C.

Restart SQL Server.

Execute SELECT @@SERVERNAME to verify the current server name.
Examples
--Start SQL Server in minimal configuration mode.
--Retrieve the former server name.
SELECT @@SERVERNAME
--Drop the server returned from the previous select.
sp_dropserver 'SERVER6X'
--Add the current server.
sp_addserver 'SERVER70', local
--Stop SQL Server.
--Restart SQL Server in minimal configuration mode.
--Verify the current server name.
SELECT @@SERVERNAME

</quote>

Anthony

Author

Commented:
thanks for the info on how to do it, but will this effect any other settings, scheduled tasks, etc. already established under the previous server name?
CERTIFIED EXPERT
Top Expert 2012

Commented:
I have no idea.  I never had a need to use it.

Sorry I could not be of more help,
Anthony

Author

Commented:
thanks for the info on how to do it, but will this effect any other settings, scheduled tasks, etc. already established under the previous server name?

Explore More ContentExplore courses, solutions, and other research materials related to this topic.