<div>
You can access your named instances instance2 and instance3 by specifying servername\instance2 or servername\instance3 or servername\instancename<br />
<br />
Hope you know your instance names
</div>


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

<div>
i know the instance name but i am unable to join to it. get error 
</div>


i know the instance name but i am unable to join to it. get error

<div>
&gt;&gt; I can only access the default instance from the SQL studio express on different computer but could not access other 2 instance<br />
<br />
have you enabled remote connections on those instances in addition to the Default instance.<br />
If not, then enable it and then try connecting to these named instances like<br />
<br />
servername\instancename<br />
or<br />
serverip\instancename
</div>


>> 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

<div>
Can you please guide me how to enable remote instance for a non default instance
</div>


Can you please guide me how to enable remote instance for a non default instance

<div>
<div class="content wysiwyg-content">
Hi All, <br />
<br />
I have one SQL server with 3 instance (Default , instance 2 and instance 3)<br />
<br />
I can only access the default instance from the SQL studio express on different computer but could not access other 2 instance<br />
<br />
any help is appreciated<br />
<br />

</div>
</div>


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



Want to remote access multiple instance using SQL studio express

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.