SQL Server 2000 on Windows Server 2003

[lucyv]

Greetings. A colleague of mine is having problems on his Windows Server 2003 machine and he's asked me for some help.

Problem:
He is unable to connect to his Windows Server 2003 from any client workstations on his network. From the client he can ping the server (which means it can be found) but he can't connect to it. He's even installed the MDAC 2.7 on each client just to make sure, but that still doesn't work.

Details about his configuration:
- He has Windows Server 2003 machine with the MDAC that comes with it (I believe MDAC 2.8)
- On this machine he's installed SQL Server 2000 with the latest server pack (service pack 4 I believe)
- He has the internal firewall turned off.
- He has it configured to listen on port 1433.

Error Message:
When he tries to connect to the server via Access 2003 through an .adp file he gets these error messsage:
- Error Message 1: "SQL SERVER Does Not Exist of Access Denied."[/color red]
- Error Message 2: "Login failed. Catalog information can not be retrieved."[/color red]


Has anybody experienced this problem before? If there any kind of configuration setting that needs to be done on the server (or clients)? Will the MDAC 2.7 allow clients to connect to the server, or do they need version 2.8?

Thanks in advance,

-lucyv

 

[mrdenny]

You should be able to connect no problem with mdac 2.7.

Try to telnet from the client machine to port 1433 on the server. This will tell you if the SQL Server is actually listening.

Check the application log on the server to see if there are any errors from the SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)

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

http://www.mrdenny.com

Donate to Katrina relief

 

[monsterjta]

MDAC 2.7 is fine. Have you tried setting up an ODBC connection?