Change of the IP Address

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Change of the IP Address

Change of the IP Address

Rate Topic

Display Mode

Topic Options

Author

Message

Jeetendra

Posted Monday, September 14, 2009 9:27 PM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, May 06, 2013 4:55 AM
Points: 612, Visits: 437

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

Elliott Whitlow

Posted Monday, September 14, 2009 9:30 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

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

Anam Verma

Posted Monday, September 14, 2009 10:34 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 14, 2013 3:27 PM
Points: 523, Visits: 1,178

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

Elliott Whitlow

Posted Monday, September 14, 2009 10:35 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

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

Shawn Melton

Posted Monday, September 14, 2009 10:53 PM

Right there with Babe

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:56 PM
Points: 754, Visits: 1,891

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
@wshawnmelton

Post #787892

Jeetendra

Posted Monday, September 14, 2009 11:39 PM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, May 06, 2013 4:55 AM
Points: 612, Visits: 437

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

Vishal Singh

Posted Monday, September 14, 2009 11:49 PM

Old 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 »

Permissions