One Way Traffic Only

[LeonAtRC]

SQL Server 2000 is installed on 2 machines on the same LAN. One is running W2k Server and the other is running XP Pro.
The following query will run on the XP machine but not on the W2K machine.

SELECT PE_ID FROM OtherServer.database.dbo.PeopleTable

Turning off my XP firewall doesn't help. I scoured this forum and found similiar problems but nothing exacly that help.
Thanks
Leon

 

[mrdenny]

What error message are you getting?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[LeonAtRC]

server does not exist or access denied

 

[mrdenny]

That is a network access issue. Either the linked server is setup incorrectly or the connection to the XP machine is being blocked by something. I've got an FAQ over in the Admin forum forum962 which has some troubleshooting techniques that should help.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[LeonAtRC]

Denny,
Surprise!! the connection works if I use W2k's IP address.
(All my machines have fixed IP addresses.)
So...is there something about the name resolution that I should be looking at?

 

[mrdenny]

I though that it was working from XP -> W2K but not from W2K -> XP?

As far as name resolution make sure that both machines are registered in DNS and/or WINS with the correct IP address and that both machines are using the correct DNS / WINS server(s).

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[LeonAtRC]

Sorry Denny. I meant to say "XP's IP Address"
I'll check out your FAQ and then keep trying. If I come across something definitive I'll post it.
Thanks.
Leon