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 Programming
 How to start second instance in sql server 2005

Author  Topic 

sqlvijay
Starting Member

16 Posts

Posted - 2008-11-26 : 05:29:32
Hi Guys,

I have just installed the second instance in sql server 2005.
I need to know how to connect with the second instance in sql server 2005.
whenever i tried to start sql server mangement studio.It is defaultly connect with the first instance of sqlserver 2005.
The second instance is already strated in sql server configuration manager.

I need to start second instance.please tell me the method to start
the second instance of sql server 2005.

Thanks in Advance
vijay

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-26 : 05:32:06
use machinename\instancename in server dialog box in sql mgmnt studio.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-26 : 05:43:01
You can register both instances in "Registered Servers" window for easier access.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

sqlvijay
Starting Member

16 Posts

Posted - 2008-11-26 : 06:29:15
quote:
Originally posted by visakh16

use machinename\instancename in server dialog box in sql mgmnt studio.





thank you


Go to Top of Page
   

- Advertisement -