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
 General SQL Server Forums
 New to SQL Server Programming
 Connect To SQLserver in Peer-To-Peer Env.

Author  Topic 

CharlesWhiteman
Starting Member

4 Posts

Posted - 2007-05-14 : 19:10:07
I have a few machines set in a workgroup which I want to use for testing SQL Server but I don't seem to be able to connect to an instance from a peer client. I can ping the machine and removed the firewall and can remote desktop.

any advice, thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-14 : 22:42:57
Got any error? Is sql server browser service running on sql server? Enabled tcp/ip or named pipes on the server?
Go to Top of Page

CharlesWhiteman
Starting Member

4 Posts

Posted - 2007-05-15 : 06:32:34
Thanks for the reply. I found the answer, being that both servers are running on XP I had to open Port 1433 and then connected fine.
Go to Top of Page
   

- Advertisement -