September 14, 2009 at 9:27 pm
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.
September 14, 2009 at 9:30 pm
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
September 14, 2009 at 10:34 pm
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.
September 14, 2009 at 10:35 pm
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
September 14, 2009 at 10:53 pm
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
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
September 14, 2009 at 11:39 pm
September 14, 2009 at 11:49 pm
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.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply