July 3, 2013 at 3:51 am
Hi,
I connect to SQL servers which are all hosted on a virtual environment.
This virtual environment is not our on local network so we have to connect via IP & port number. I've set these servers up in my Registered Servers list in Management Studio.
Once a month, this virtual is refreshed with the latest updates but during the process, the IP addresses of these SQL servers change. I then have to go & update every registered server I created to point to the new IP address. There are 17 of them in total. The IP addresses I get from a view in another SQL database.
Question is... Is there a quick way I can update these IP addresses from this view? Maybe a process I can use to create a registered servers file & import that again?
It's not a serious issue but a tedious process to go through every server & fix it up manually. If there's any way I can automate this process it would make my life much easier.
Any help would be appreciated.
Thanks!
July 3, 2013 at 5:00 am
Step 1 DON'T CHANGE SERVER IP's.
Its just bad practice and should never happen.
I bet that should solve this issue?
July 3, 2013 at 5:06 am
D1rtyD0g (7/3/2013)
Hi,I connect to SQL servers which are all hosted on a virtual environment.
This virtual environment is not our on local network so we have to connect via IP & port number. I've set these servers up in my Registered Servers list in Management Studio.
Once a month, this virtual is refreshed with the latest updates but during the process, the IP addresses of these SQL servers change. I then have to go & update every registered server I created to point to the new IP address. There are 17 of them in total. The IP addresses I get from a view in another SQL database.
Question is... Is there a quick way I can update these IP addresses from this view? Maybe a process I can use to create a registered servers file & import that again?
It's not a serious issue but a tedious process to go through every server & fix it up manually. If there's any way I can automate this process it would make my life much easier.
Any help would be appreciated.
Thanks!
Try exporting tour registered servers, modifying the resulting file (its XML and can be edited in Notepad), and then re-importing it.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 3, 2013 at 5:10 am
I agree with that.
Two problems though...
1. It's a VIRTUAL environment which assigns IPs dynamically. We use this for development & not for production.
2. I'm not in control of this environment.
July 3, 2013 at 5:14 am
Oh well.
If i was in your shoes...i would use a technology called: mRemoteG, its free-ware which contains a XML editable file on your local OS.
Sorry could not be of more help?
July 3, 2013 at 7:51 am
I would suggest talking to the network admins, see if they can create DNS entries that will point to these servers and update automatically when the IPs change. The only potential hangup might be the port number, although you can set that in the registration for a server (IE: servername,port#)
In some ways, much easier than regularly having to edit the connections, in some harder as you've got to deal with the network admins.
Jason
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply