By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,491 Members | 3,132 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,491 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.