February 8, 2011 at 6:15 pm
Currently we have a server in the domain scopeapp. We have 30+ applications and items that connect to this database for data and maintenance and such.
Our IT team has offered us a server with a named instance "newserver/scopeapp"
Is there a way to alias that instance so that when connecting to scopeapp (server) it redirects that connection to the upgraded server instance?
2 different servers, old is scopeapp new is newserver .
2 different IP's of course.
We want to retire the old server scopeapp and replace it with newserver but in doing so we don't want to "break" our current system.
Any ideas?
February 8, 2011 at 7:34 pm
The only way I know of doing this is to create a client alias on every machine that will be connecting to that instance of SQL Server.
If this is a thick client application, then you really only have two options. Either add a client alias on every desktop, or update the connection information for each client desktop. Either way, you have to touch each desktop - and, just my opinion, if you have to touch every desktop you might as well change the connection information instead of using an alias.
If your application is web based - then all you need to touch is the web servers. Change the connection information on each web server instead of using an alias.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 8, 2011 at 10:14 pm
I don't understand what you mean by "client machine".
I want the connection string that my applications (30+) use currently to stay the same, and the named server instance to accept that as a connection on our network.
If this can't be done, it's pretty short sited of the Microsoft sql server team.
I thought you could alias an instance, in fact I know you can, but I don't know the specifics.
February 10, 2011 at 7:56 am
Heres hoping ive understood what your asking for.....
WHat kind of connection string do your app servers use? If they are hardcoded IP's or host names, then a redirect is not possible...
there are ways to do this however...
> CHange the app servers to have dns entries to the sql server.
eg: sqlserver_node1.xx.net
Then ask your sysadmin to change the IP to go to the new server..
create an alias in SQL Server configuration manager with the name you want the instance to be on EACH app server (as Jeffrey has mentioned)
> Shut down the old machine, and reconfigure the IP address for the new machine to be the old one..and rename host. This will sort out the hostname part.
Then follow http://technet.microsoft.com/en-us/library/ms143799.aspx
again, create an alias in SQL Server configuration manager with the name you want the instance to be on EACH app server (as Jeffrey has mentioned)
February 21, 2011 at 12:18 pm
I think I understand now what is meant by client machine.
The application servers acts as a client, we could do some stuff there.
Changing hostname doesn't do much because it is a sql server instance that needs to be part of the connection string: Instead of MYSERVER it's USA\Myserver
I could not see any way to alias USA\Myserver to be MYSERVER again on the network. because the host servername is USA. That's just confusing. I wish the instance had a way to enter a "pseudo" hostname because that would take care of the whole problem.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply