Changing a server's TCP/IP address.

We are going to be changing our SQL Server's TCP/IP address. Is there
anything I need to do within SQL to make sure it works correctly?
The machine is not doing replication.
TIA - Jeff.If it's not a cluster, none.
Linchi
"Mufasa" wrote:
> We are going to be changing our SQL Server's TCP/IP address. Is there
> anything I need to do within SQL to make sure it works correctly?
> The machine is not doing replication.
> TIA - Jeff.
>
>|||If it's not in a cluster, then just do the IP change and there's nothing
else to do, outside of restarting SQL Server. If it's a cluster, then:
http://support.microsoft.com/kb/230356
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Mufasa" <jb@.nowhere.com> wrote in message
news:eSPpRDqYIHA.4180@.TK2MSFTNGP06.phx.gbl...
We are going to be changing our SQL Server's TCP/IP address. Is there
anything I need to do within SQL to make sure it works correctly?
The machine is not doing replication.
TIA - Jeff.|||What about if the server is involved in mirroring or tlog shipping?
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:D9BF238C-945E-47BE-B4D9-6B536A8BF9AE@.microsoft.com...
> If it's not a cluster, none.
> Linchi
> "Mufasa" wrote:
>> We are going to be changing our SQL Server's TCP/IP address. Is there
>> anything I need to do within SQL to make sure it works correctly?
>> The machine is not doing replication.
>> TIA - Jeff.
>>|||I don't believe they depend on the IP address, but I don't have a test
install to verify so I could be wrong. But in any event I certainly hope MS
knows much better than having an app component dependent on IP directly. But
then if an app directly depends on IP, perhaps we should have it failed so it
can fixed.
Linchi
"TheSQLGuru" wrote:
> What about if the server is involved in mirroring or tlog shipping?
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:D9BF238C-945E-47BE-B4D9-6B536A8BF9AE@.microsoft.com...
> > If it's not a cluster, none.
> >
> > Linchi
> >
> > "Mufasa" wrote:
> >
> >> We are going to be changing our SQL Server's TCP/IP address. Is there
> >> anything I need to do within SQL to make sure it works correctly?
> >>
> >> The machine is not doing replication.
> >>
> >> TIA - Jeff.
> >>
> >>
> >>
>
>|||Thanks everybody for your help.
J.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:u7pBQmqYIHA.4476@.TK2MSFTNGP06.phx.gbl...
> If it's not in a cluster, then just do the IP change and there's nothing
> else to do, outside of restarting SQL Server. If it's a cluster, then:
> http://support.microsoft.com/kb/230356
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Mufasa" <jb@.nowhere.com> wrote in message
> news:eSPpRDqYIHA.4180@.TK2MSFTNGP06.phx.gbl...
> We are going to be changing our SQL Server's TCP/IP address. Is there
> anything I need to do within SQL to make sure it works correctly?
> The machine is not doing replication.
> TIA - Jeff.
>
>sql

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 youHi,
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

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

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 i
n
the SQL server side which I need to make. Please advise. Thanks youHi,
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