Hi Everyone,

 To  maintan multiple version of sql server I have intalled sql server 2005/2008 R2 and sql server 2012 on same developement server. When I am opening any of the SSMS (2005/2008 r2/2012) ,in server lists its showing only two server (even after brawse more ) even if I open SSMS of 2012 still I am geting these two server name. These two are one for sql server 2005 and another for sql server 2008 r2 .   Finally I am not able to connect with sql server 2012 instance.  Can any body help me to connect with sql server 2012 instance.

Thanks

Hello Vikas,

Have you check if the SQL Server 2012 instance is running?

To connect to just enter the instance in the login dialog, like like MachineName\InstanceName.

Thank you for reply.

 Where I can see what is the name of my sql server 2012 instance.

Can't you remind which instance name you have used during installation?

Open Windows Service manager (services.msc) and have a look at the "SQL Server" entries, the instance name is mentioned in the service name in brackets, e.g. "SQL Server (InstanceName)"

Check it here

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names

You can see the name of your SQL Server 2012 here