Renaming a server

Question

Post reply

Renaming a server

Shark Energy

SSCrazy Eights

Points: 8389
More actions
August 24, 2009 at 5:13 am

#135063

Hi all,
I have a server that will be replacing another (let's call the original SQL1, and the new one SQL1A).
Now when server 1A is ready to go live, it will be taking the place of SQL1. I take it when the server itself gets renamed when we go live, the instance of sql will remain as SQL1A.
If I want to change this with the least amount of trouble, what should I do?
Cheers
Shark

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Torsten Schüßler-406123 SSC-Addicted Points: 496 More actions · Answer 1

Hi Shark,

first, you can follow the KB article 918992 to transfer

logins and passwords.

after this, you can refer to this article:

How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL

Server 2008/2005

http://msdn.microsoft.com/en-us/library/ms143799.aspx

[font="Verdana"]CU
tosc[/font]

www.insidesql.org

ggoble Hall of Fame Points: 3337 More actions · Answer 2

Are you going to keep the same IP? Check out the following article

http://msdn.microsoft.com/en-us/library/ms143799.aspx

Lempster SSCoach Points: 15651 More actions · Answer 3

Be aware that if you have any remote logins set up on the instance, e.g. if you are using replication, the sp_dropserver command will error; you'll need to drop the remote logins first.

Shark Energy SSCrazy Eights Points: 8389 More actions · Answer 4

Its one of our sql 2000 servers actually. Plopped the question in here out of habit!

Jason Crider SSCertifiable Points: 6019 More actions · Answer 5

You can look here: http://www.sqlservercentral.com/Forums/Topic271619-146-1.aspx

There should be plenty of past posts asking similar items.

I'm in the middle of the process myself with a 2000 to 2005 move.

MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter