469,600 Members | 2,367 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,600 developers. It's quick & easy.

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
Jul 23 '05 #1
1 8376
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
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Greg | last post: by
3 posts views Thread by HandersonVA | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.