Changing SQL Server Box name | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Changing SQL Server Box name

I have SQL Server 2005 running on one of my Windows 2003 box. If I change the computer name, restart the SQL Server service, will it work normally? I know this use to be an issue with earlier versoin of SQL Server, dont know about SQL server 2005. Can somebody please advice on this?
Many thanks,
Cali
It should work fine but you may need to need change the server name by executing the following procedure… exec sp_dropserver ‘OldServerName’
go
exec sp_addserver ‘Newservername’, ‘local’
go
restart sql services… Make sure remove DNS cache/entries for old server…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Thank you so much MohammedU. You are awesome and have a great stealth of knowledge. Thanks again,
cali
Thanks for your complements [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Good luck<br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by california6</i><br /><br />Thank you so much MohammedU.<br /><br />You are awesome and have a great stealth of knowledge. Thanks again,<br />cali<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />you mean great "wealth" of knowledge? [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br /><br />***********************<br />Dinakar Nethi<br />SQL Server MVP<br />***********************<br /<a target="_blank" href=http://weblogs.sqlteam.com/dinakar/>http://weblogs.sqlteam.com/dinakar/</a>
[<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />][<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />][<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />][<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />][<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />]<br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />
.. addup on Mohd. reply:
Select information from either @@servername or sys.servers. The @@servername function will return the new name, and the sys.servers table will show the new name. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>