Connect SQL 2000 Server Network [Resolved]

[vjmehra]

Hi,

I have 2 SQL 2K Servers set up on my home network. Both PC's are running Windows XP and as far as I can tell are configured identically, however I can connect to the Server A from PC B but not Server B from PC A (both work fine when I am on the same machine I try to connect to). Any ideas anyone, the error message I am getting is attached.

[RobDog888]

Are there the same user accounts in SQL? XP firewall still on?

[vjmehra]

Both accouts are configurd idenicaly in SQL as far as I can tell (I configured them this morning at the same time so they should be!) The XP firewalls are disabled on both machines. I can actually see the server name if I try and add it in Enterprise Manager, it just won't let me connect to it.

[vjmehra]

Ok solved it, A had not had file and print sharing set up, didn't even think to check this as I could see it on the network, so assumed it was setup correctly!

[RobDog888]

Ok.

Don't forget to resolve this thread.

[vjmehra]

How do I resolve a thread?

[RobDog888]

It's in my signature.

Edit your original post's subject and add
"[Resolved]" when you have your questions answered.