July 17, 2006 at 2:00 pm
Currently using SQL Server 2000.
I know that SQL Server takes on the name of the server when you first install SQL Server, but
If I rename the server, does SQL Server take on that new server name? Seems to me that I remember that you cannot change SQL Servers name but I want to ask to be sure.
Thanks for any an all help.
Russ
July 17, 2006 at 2:43 pm
July 18, 2006 at 6:10 am
You are correct that the sql server takes the machine name on first install.
A machine name rename does not change the sql server name.
The sql server name does not have to be the same as the machine name, this can be useful if you have indecipherable server names.
For remote access the network name can also be different to both the machine name and the sql server name.
sp_helpserver will show you all the name info
sp_setnetname will allow you to change the network name
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply