sql server name

[Jones25]

hello,

if my computer name is x and sql server was installed and therefore took on the default name of x, can I change the sql server name to y at a later date? If so how do I do it?
The sp_addserver is internal recognition. But I want to connect to sql server using the new name y.

Any help is appreciated.

 

[MAK9974]

u have to rerun the setup again on that machine.

 

[tlbroadbent]

You must only run setup if you have SQL 7. When you run setup again, it will recognize the server name is different and update the registry. A complete reinstall is not required.

If you have SQL 2000, you can simply run sp_dropserver to droip the old server name and sp_addserver to add the new name.

See the following article.

http://www.swynk.com/friends/knight/renameserver.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[MAK9974]

change the alias name in Client network utility and register the new alias in EM