December 1, 2011 at 8:02 pm
I have a default instance standalone that is to be moved to a named instance on a cluster. These databases are accessed via a fat-client app located on hundreds of client machines.
The old server is going offline, and its name can be dns-aliased to the new server...(which doesn't help because I am going from a default instance to a named one).
It is not feasible to set up Sql Aliases on every one of the client machines.
Is there another technique to alias "old server\" to "newserver\instancename" without adding an alias on each client machine?
December 1, 2011 at 9:40 pm
One option is to use a central config file and have all of the clients use that central config for the app. Otherwise you will need to make a bunch of changes on the desktops.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2011 at 2:23 am
you could use SMS or group policy to push out the DSN registry change to all desktops, i have done this before with ease when migrating a database between a default and named instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 2, 2011 at 3:02 am
Another option could be a reverse proxy listening on the "old" address, port 1433, and redirecting to the new address, named instance port.
-- Gianluca Sartori
December 2, 2011 at 5:09 am
I had thought of the Group Policy push for the Windows-side of the house, but I have to address Mac, Linux, AIX, and mobile users as well.
Thanks for the response.
December 2, 2011 at 5:11 am
Gianluca Sartori (12/2/2011)
Another option could be a reverse proxy listening on the "old" address, port 1433, and redirecting to the new address, named instance port.
Could you elaborate, or provide a link to an example of this technique please?
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply