Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change of the IP Address Expand / Collapse
Author
Message
Posted Monday, September 14, 2009 9:27 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 5:32 AM
Points: 612, Visits: 461
Hi ALL,

My company is changing the IP address of our network.

As i know there won't be any effect as far as the SQL Server 2005 is concerned.

Just wanna know what would be the effect of changing the IP Address on the SQL Server Reporting Server, Integration Services & Analysis Services.

Please do let me know as all this services are configured in our environment.




Kindest Regards,

Jeetendra

Post #787873
Posted Monday, September 14, 2009 9:30 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
Provided the severname doesn't change all that will likely be needed is a restart of the services to use the new ip address..

CEWII
Post #787875
Posted Monday, September 14, 2009 10:34 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:52 PM
Points: 528, Visits: 1,258
Elliott W (9/14/2009)
Provided the severname doesn't change all that will likely be needed is a restart of the services to use the new ip address..

CEWII


This option of servername will only be valid if you are connecting sql server using servername rather than IP. I have seen some people using IP rather than server name.
Post #787884
Posted Monday, September 14, 2009 10:35 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
Then they won't be able to connect.. But that is a client problem and not something that will be resolved at the server. It is also not a good practice and should be avoided.

CEWII
Post #787885
Posted Monday, September 14, 2009 10:53 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 12:09 PM
Points: 860, Visits: 2,413
I would just focus on ensuring the DNS records update for the SQL Server (host and pointer records). As well, IIS may need to be checked for the web services used by Reporting or Analysis services.

Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #787892
Posted Monday, September 14, 2009 11:39 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 5:32 AM
Points: 612, Visits: 461
Also since we are using the ADS the old server needs to be removed and new Entry of the server along with the New IP address needs to be added.
Please correct me if i m wrong.



Kindest Regards,

Jeetendra

Post #787900
Posted Monday, September 14, 2009 11:49 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 12:30 AM
Points: 353, Visits: 487
Jeetendra (9/14/2009)
Also since we are using the ADS the old server needs to be removed and new Entry of the server along with the New IP address needs to be added.
Please correct me if i m wrong.


If there is no change in the Server name but only in the IP address, the post reboot after changing the IP will automaticaly update the AD. One doesn't need to manually update it.


-Forum Etiquette: How to post Performance Problems

-Forum Etiquette: How to post data/code to get the best help
Post #787907
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse