<div>
Ensure that TCP-IP is enabled for SQL Server.<br />
<br />
Ensure that the login/security context that you are using to go from PC2 to PC1 has appropriate privileges on PC1.<br />
<br />
BTW - what error are you getting?
</div>


Ensure that TCP-IP is enabled for SQL Server.

Ensure that the login/security context that you are using to go from PC2 to PC1 has appropriate privileges on PC1.

BTW - what error are you getting?

<div>
Configure firewall to have the access<br />
Turn ON SQL Server services<br />
Configure domain ID to have access on both the machines<br />
Enable TCP/IP<br />
Check the application security log for SSMS to find out error while connecting the server
</div>


Configure firewall to have the access
Turn ON SQL Server services
Configure domain ID to have access on both the machines
Enable TCP/IP
Check the application security log for SSMS to find out error while connecting the server

<div>
Read Article.<br />
<br />
<br />
<a href="https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_10612-SQL-Server-does-not-exist-or-access-denied.html" rel="ugc">https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_10612-SQL-Server-does-not-exist-or-access-denied.html</a>
</div>


Read Article.


https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_10612-SQL-Server-does-not-exist-or-access-denied.html [https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_10612-SQL-Server-does-not-exist-or-access-denied.html]

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have two pcs connected through router. Say PC1 is running windows xp.I have installed Sql server 2008 in PC1.<br />
<br />
I have another PC2 which is running on windows 7. I have also installed Sql Server 2008 in PC2.<br />
<br />
I want to access instance of Sql serverof PC1 from PC2 via management studio.<br />
<br />
I am not able to get access fromPC2 to PC1. But i am able to doso fromPC1to PC2.<br />
<br />
How can i access sql server from PC2 to PC1.<br />
<br />
thanks
</div>
</div>


Hi,

I have two pcs connected through router. Say PC1 is running windows xp.I have installed Sql server 2008 in PC1.

I have another PC2 which is running on windows 7. I have also installed Sql Server 2008 in PC2.

I want to access instance of Sql serverof PC1 from PC2 via management studio.

I am not able to get access fromPC2 to PC1. But i am able to doso fromPC1to PC2.

How can i access sql server from PC2 to PC1.

thanks

Sql Server Connection problem

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

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.