How to forward from a SQL default instance to a named instance

Hello,

We have a database migration application that insists on going to the default instance of our database. However, we are using a named instance.

How can we re-direct anything going to a default instance to our named instance on the MS Sql server please?

Thank you, Marc
marcustibesarAsked:
Who is Participating?
 
rar3zCommented:
In SQL Configuration Manager, you can setup alias for the instances. So multiple instance names can be assigned to the same SQL server.

The tool can be found in the SQL Server Configuration Manager > SQL native Cleint (32 bit) or regular for 64bit > Alias > create a new instance..
0
 
avirupsCommented:
If you are using a static port for the sql server then you can use myservername, portnumber instead of meservername\instancename. It will connect to the named instance running on the portnumber.

Otherwise, yes ALIAS is the way to go and here is a link explaining how you can configure it.
http://www.mssqltips.com/tip.asp?tip=1620

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.