Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Renaming a server Expand / Collapse
Author
Message
Posted Monday, August 24, 2009 5:13 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 19, 2014 2:44 AM
Points: 549, Visits: 1,016
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
Posted Monday, August 24, 2009 7:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 1:37 AM
Points: 28, Visits: 366
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
Posted Monday, August 24, 2009 8:09 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 11:36 AM
Points: 378, Visits: 1,001
Are you going to keep the same IP? Check out the following article

http://msdn.microsoft.com/en-us/library/ms143799.aspx
Post #776010
Posted Monday, August 24, 2009 8:48 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:03 AM
Points: 2,036, Visits: 1,381
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
Posted Monday, August 24, 2009 8:56 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 19, 2014 2:44 AM
Points: 549, Visits: 1,016
Its one of our sql 2000 servers actually. Plopped the question in here out of habit!
Post #776070
Posted Tuesday, August 25, 2009 7:40 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 11:40 AM
Points: 282, Visits: 2,209
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 »

Add to briefcase

Permissions Expand / Collapse