Can't connect to SQL Server (developer edition) from another PC?

[ITM]

I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
SP2 machine. It's installed without any problems.

When I try to connect to it from another XP SP2 machine (by creating
an ODBC data source) I get a Login error:
[ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
Connection failed: SQLState: 08001 SQL Server Error: 17
SQL Server does not exist or access denied

I can ping the server fine from the other machine, and I've tried the
standard "sa" user/pw as welll as my own logins.

The server is configured for mixed authentication (Windows/SQL
Server).

Can anyone suggest what the problem might be?

TIA for any help
Ian

[Erland Sommarskog]

ITM (it*@nospam.com) writes:

I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
SP2 machine. It's installed without any problems.

When I try to connect to it from another XP SP2 machine (by creating
an ODBC data source) I get a Login error:
[ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
Connection failed: SQLState: 08001 SQL Server Error: 17
SQL Server does not exist or access denied

I can ping the server fine from the other machine, and I've tried the
standard "sa" user/pw as welll as my own logins.

The server is configured for mixed authentication (Windows/SQL
Server).

Can anyone suggest what the problem might be?

Windows firewall sounds like the most likely reason.

In the Control Panel, open the Windows Firewall applet. Go to the Advanced
tab and select the applicable network. Click Settings. Here you can check
SQL Server to permit it to accept connections on the network.

Think at least twice before you expose SQL Server on the Internet,
particularly if you are using SQL authentication.

For other possibilities, see here:
http://support.microsoft.com/default...;EN-US;q328306.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp