Change of IP address for SQL Server

Hi
I have a SQL server that may have to change the IP address. However if I
change the IP address and name of the server, is there any reconfiguration in
the SQL server side which I need to make. Please advise. Thanks you
Hi,
After the Server name change..Use the below command after login into SQL
server using Query Analyzer.
sp_dropserver 'old_server_name',
go
sp_addserver 'new_server_name', 'local'
After this restart SQL server service and change the conenction string.
Thanks
Hari
SQL Server MVP
"Christina" <Christina@.discussions.microsoft.com> wrote in message
news:F4B0BFFC-C7F4-4D08-B2C7-F3041DA08AF8@.microsoft.com...
> Hi
> I have a SQL server that may have to change the IP address. However if I
> change the IP address and name of the server, is there any reconfiguration
> in
> the SQL server side which I need to make. Please advise. Thanks you
|||Depends if you are in a stand-alone or clustered configuration. If
stand-alone, after you rename and reassign the new ip address, bring SQL
Server back online and execute sp_dropserver oldservername and sp_addserver
newservername, local.
Verify the syntax in Books Online but if you use Enterprise Manager, in
security, there is a group for remote servers, this will show a mapping to
the old name, and, after execution of the above, will show the new server.
If a clustered installation, just run setup again and choose Advanced
Options and walk through the setup dialogue screens to reconfigure.
Sincerely,
Anthony Thomas
"Christina" wrote:

> Hi
> I have a SQL server that may have to change the IP address. However if I
> change the IP address and name of the server, is there any reconfiguration in
> the SQL server side which I need to make. Please advise. Thanks you
|||Christina,
Changing the IP won't affect SQL Server. See the other posts for
changing the name.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Christina wrote:
> Hi
> I have a SQL server that may have to change the IP address. However if I
> change the IP address and name of the server, is there any reconfiguration in
> the SQL server side which I need to make. Please advise. Thanks you