Showing posts with label allwill. Show all posts
Showing posts with label allwill. Show all posts

Monday, March 19, 2012

Changing SQL Server IP address effects

Hi All
Will changing SQL Server IP address affect/break anything in sql server?
Thank you in advance.from the server point it won't break anything.
clients using TCP/IP connection won't be able to connect 'til updated with
server new IP address
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:120646C1-6CDD-4909-809B-772E1C989B38@.microsoft.com...
> Hi All
> Will changing SQL Server IP address affect/break anything in sql server?
> Thank you in advance.
>

Changing SQL Server IP address effects

Hi All
Will changing SQL Server IP address affect/break anything in sql server?
Thank you in advance.
from the server point it won't break anything.
clients using TCP/IP connection won't be able to connect 'til updated with
server new IP address
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:120646C1-6CDD-4909-809B-772E1C989B38@.microsoft.com...
> Hi All
> Will changing SQL Server IP address affect/break anything in sql server?
> Thank you in advance.
>

changing SQL Server IP address

Hi All

Will changing SQL Server IP address affecting/break anything in sql server? Thank you in advance.

Possibly not, depending on your environment.

The critical thing is that all connection strings and references to the server must use it's NetBIOS name or DNS name. If you don't know what you're using, it's probably NetBIOS and thus you're probably ok :)

Also, if you change the IP address, any open connections to the server will break. So be sure you do this at a pre-determined downtime :)

-Ryan / Kardax