Renaming a server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Renaming a server

Renaming a server

Rate Topic

Display Mode

Topic Options

Author

Message

Shark Energy

Posted Monday, August 24, 2009 5:13 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, March 22, 2013 9:32 AM
Points: 547, Visits: 995

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

Post #775895

Torsten Schüßler-406123

Posted Monday, August 24, 2009 7:06 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:03 AM
Points: 25, Visits: 307

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

CU
tosc

www.insidesql.org

Post #775965

ggoble

Posted Monday, August 24, 2009 8:09 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:45 PM
Points: 366, Visits: 840

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

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

Post #776010

Lempster

Posted Monday, August 24, 2009 8:48 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 8:40 AM
Points: 1,450, Visits: 760

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.

Post #776061

Shark Energy

Posted Monday, August 24, 2009 8:56 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, March 22, 2013 9:32 AM
Points: 547, Visits: 995

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

Post #776070

Jason Crider

Posted Tuesday, August 25, 2009 7:40 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:08 AM
Points: 282, Visits: 2,126

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

Post #776671

« Prev Topic | Next Topic »

Permissions