Hi all,

I am using two different SQL server instances one is SQL server 2012 and SQL server 2008 r.

I am using SQL server 2012 but certainly i need to use the SQL server and unfortunately need to use same alias name as i have used for SQL server 2012 instance.

One more thing is that am using 1433 port for both SQL sever instances, but when am trying to connect to SQL server 2008 r2 using that alias, i am get connected to the SQL server 2012 database.

Am not getting that what mistake i have did, can some please help me to know what is wrong i did and how to solve this issue..

Any help is Appreciated

The best approach should be, migrating whatever databases you have in SQL 2008 to the 2012 instance and remove the 2008 instance.

In order to connect to the 2008 instance , open  sql configuration manager find the instance name

find the "protocols for instance"

make sure tcp is enabled. if tcp port defined is equal to the 2012 instance change it, restart the sql server service.

connect to the new port using    machinename/instancename,new port

You cannot install both instances on the same port.  You need to have unique ports for each instance on the same server.

https://msdn.microsoft.com/en-us/library/ms177440(v=sql.110).aspx

• Edited by Tom Phillips 15 hours 58 minutes ago

Hi

What are you trying to achieve here?

Having differing versions of SQL Server on the same Server can be problematic because of the counters etc.

Both instances cannot use port 1433.

Since both instances uses port 1433, only one of them can run at a time. Or more precisely only one of them can listen to that port - that will be the one start you started first.

I would not say that this is very practical, but if you want to test the application against different versions of SQL Server without changing the connection string, this is a handy solution. Just start the instance you want to test against, but first make sure that the other is stopped.

which port we can use other than 1433.

Hi Chetan,

Consult http://www.iana.org/assignments/port-numbers for a list of port numbers that are assigned to specific applications when selecting a port number. Select an unassigned number for your SQL Server instance.

Also, avoid numbers greater than 49151 which Windows might select for other purposes. For more information, please review this article: The default dynamic port range for TCP/IP has changed in Windows Vista and in Windows Server 2008.

Reference:
https://msdn.microsoft.com/en-us/library/ms177440(v=sql.105).aspx

Thanks,
Lydia