Want to remote access multiple instance using SQL studio express

Hi All,

I have one SQL server with 3 instance (Default , instance 2 and instance 3)

I can only access the default instance from the SQL studio express on different computer but could not access other 2 instance

any help is appreciated

LVL 6
InderjeetjaggiAsked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Steps are same as that of your default instance and follow the steps here to enable Remote connections in SQL Server 2005:

http://www.linglom.com/2007/08/31/enable-remote-connection-to-sql-server-2005-express/

for SQL Server 2008:

http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
You can access your named instances instance2 and instance3 by specifying servername\instance2 or servername\instance3 or servername\instancename

Hope you know your instance names
0
 
InderjeetjaggiAuthor Commented:
i know the instance name but i am unable to join to it. get error
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> I can only access the default instance from the SQL studio express on different computer but could not access other 2 instance

have you enabled remote connections on those instances in addition to the Default instance.
If not, then enable it and then try connecting to these named instances like

servername\instancename
or
serverip\instancename
0
 
InderjeetjaggiAuthor Commented:
Can you please guide me how to enable remote instance for a non default instance
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.