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
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 connect to sql server instances on same host

Author  Topic 

dmaxj
Posting Yak Master

174 Posts

Posted - 2010-10-12 : 11:53:09
I have installed another instance of SQL 2008 on my local box. I see both instances of the database engine in SQL Configuration Manager, but I cannot seem to connect to my new instance from Management Studio.

I need to be able to view both instances in Object Explorer. I click connect to database engine, but I only get the option to connect to my default instance. Instance names are MSSQLSERVER and PRODSQL (new instance).

Regards

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-12 : 12:00:46
Your instance then is to reach via:
MSSQLSERVER\PRODSQL


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

dmaxj
Posting Yak Master

174 Posts

Posted - 2010-10-12 : 12:08:25
Thanks, webfred!!!
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-12 : 12:31:45
welcome


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -