Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 ALIAS, DNS and NAMED INSTANCE.

Author  Topic 

godard
Starting Member

1 Post

Posted - 2014-09-16 : 11:34:18
Hi,
I have a problem with an alias for sql server named instance.

I read a lot about that, but can't find any solution that works.

- I've two instances on same server. The first one is the default, the second one is named Recette_v2

I try to make an alias for this second instance (the application that must aceed to db on named instance can't call the classic name SERVER\INSTANCE_NAME).

I've a DNS registry with alias name for my serveur name and can connect to sql instance with management studio with it.

But it don't works with SQL alias added in configuration manager (Special tpc port with name of alias in DNS).

Have u a solution ?

T. Godard

Ifor
Aged Yak Warrior

700 Posts

Posted - 2014-09-16 : 12:07:12
You need to setup static ports.

http://msdn.microsoft.com/en-us/library/ms177440.aspx

The named instance can then be connected to with something like:

Server:<port number>

Go to Top of Page
   

- Advertisement -