June 30, 2008 at 1:44 pm
I am moving an old server to a new server. The old server is SQL 7 and Windows 2000. The new box is windows 2003 and I installed SQL 2k5. Now, I purposefully put a bogus name for the server as to be able to connect to the network without any naming/trust issues. I then installed SQL 2k5. I accepted the default for the instance name. Will this change when I change the server name to the good name? Will I have to update the master database?
From my research, the default instance of sql 2005 should change to demonstrate the new server name because it is not actually named the server name but MSSQLSERVER or something. Is this true? Do I have to touch the Master database in a sys table since this is only the default instance name? Is all I have to worry about is just changing the name of the server and rebooting?
June 30, 2008 at 1:48 pm
The following BOL article should answer all these questions.
http://msdn.microsoft.com/en-us/library/ms143799.aspx
Kyle
June 30, 2008 at 2:07 pm
The most simplest approach you can take is :
sp_dropserver [servername]
sp_addserver [new server name], local
I hope you have disabled or Shutdown the previous server before this one goes online.
Maninder
www.dbanation.com
July 1, 2008 at 6:30 am
Thank you both and I will have the other one off-line before I bring this new one on the network with the new name 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply