October 23, 2011 at 8:14 am
Hi all,
We have moved our database from default instance to named instance of SQL SERVER 2008 R2 (default instance has been uninstalled).
However, we have distributed client software which connect only to default instance of SQL Server over internet on a static IP address.
Any pointers about how to forward connection requests to default instance by clients to the named instance which is hosting the database now?
Thanks and Regards,
Michael Brown
October 23, 2011 at 8:51 pm
Have you looked at SQL Native Client aliases...
An alias is an alternate name that can be used to make a connection. The alias encapsulates the required elements of a connection string, and exposes them with a name chosen by the user. To create an alias for the Microsoft SQL Server clients on this computer, right-click Aliases in the console pane, and then click New Alias. To configure an existing alias for the SQL Server clients on this computer, click Aliases in the console pane, right-click the desired existing alias in the details pane, and then click Properties.
http://msdn.microsoft.com/en-us/library/dd981072.aspx
Blog: http://crazyemu.wordpress.com/
Twit: @crazySQL
October 24, 2011 at 2:32 am
I did try aliases. But it didn't seem to work. Can you provide me an example for setting alias for Default instance such that it will point to a named instance?
Thanks and Regards,
Michael
crazyEmu (10/23/2011)
An alias is an alternate name that can be used to make a connection. The alias encapsulates the required elements of a connection string, and exposes them with a name chosen by the user. To create an alias for the Microsoft SQL Server clients on this computer, right-click Aliases in the console pane, and then click New Alias. To configure an existing alias for the SQL Server clients on this computer, click Aliases in the console pane, right-click the desired existing alias in the details pane, and then click Properties.
http://msdn.microsoft.com/en-us/library/dd981072.aspx%5B/quote%5D
October 24, 2011 at 2:42 am
There are at least few possible solutions here.
As long as you don't have a default instance on the new server, you can specify that your named instance shall listen on port 1433 (which the default instance normally use). That should do the trick if your clients connect to your server using IP address (and default port).
If it the client applications are using SQL Native Client (or whatever it is called today), you can configure alias as said. However, this alias must be on every client, it is not a server configuration. Most likely, you can find a way of setting this on all clients by using group policy preferences.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply