October 5, 2004 at 8:11 am
Good morning guys and gals,
We would like to rename the server that house our SQL server. It is a Windows 2003 Server that is presently named NM001. We would like to name it NM005. Will that affect the way the SQL server starts or logs in?
What other things should we be aware of when we reboot? Do we need to make any changes to the SQL server config in order for us to make the name change, or will SQL Server update itself once we change the machine name on the server.
Thanks in advance!
October 5, 2004 at 8:31 am
Here are the steps involved:
1. Rename the server in Windows.
2. Use sp_dropserver and sp_addserver. Refer to BOL 'Renaming a Server'
3. Refer to the following article too. http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b303774
4. Stop and restart SQL Server service.
October 5, 2004 at 8:35 am
Vas, when we rename the server, should we reboot first so that the server has a new name before changing SQL Server, or change them both and then restart?
Also, how do I run the stored procedures? Talking a dead newbie here...
Thanks for your fast response!
October 5, 2004 at 9:28 am
Sorry Vitaly that I forgot to mention to reboot after renaming the server. Connect to SQL Server using the new computer name after you have restarted the server. Then run the stored procedures I mentioned using Query Analyzer in Master database. I would read BOL 'Renaming Servers' and the article I mentioned before proceeding.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply