Sql Server Connection problem


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.

Who is Participating?
Paul SConnect With a Mentor Desktop Support Manager / Network AdministratorCommented:
if work group than local usernames and passwords must be the same. if on a domain setup the local admin group to have the correct domain group. turn off windows firewall.
Matt BowlerDB team leadCommented:
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?
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
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.