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

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
Are you running XP firewall on that machine? If so, turn it off and any
other firewall (Norton Internet Security, etc).
Chris
"ITM" <itm@.nospam.com> wrote in message
news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
> 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
|||On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:

>Are you running XP firewall on that machine? If so, turn it off and any
>other firewall (Norton Internet Security, etc).
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com.. .
>
I've tried turning off XP firewall but it made no difference. I'm not
running Norton, but am using AVG anti-virus (free edition). No other
firewall/AV software installed.
Ian
|||What happens when you telnet to port 1433 on that machine (or whatever port
you're running it on)?
Chris
"ITM" <itm@.nospam.com> wrote in message
news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com...
> On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
> <schmidtc@.KvalleyDotCom> wrote:
> I've tried turning off XP firewall but it made no difference. I'm not
> running Norton, but am using AVG anti-virus (free edition). No other
> firewall/AV software installed.
> Ian
|||On Sun, 20 Mar 2005 09:41:09 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:

>What happens when you telnet to port 1433 on that machine (or whatever port
>you're running it on)?
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com.. .
>
Have just downloaded and installed SP3 for SQL Server - it seems to
have done the trick. Should've tried that before :-(

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

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
IanAre you running XP firewall on that machine? If so, turn it off and any
other firewall (Norton Internet Security, etc).
Chris
"ITM" <itm@.nospam.com> wrote in message
news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.
4ax.com...
> 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|||On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:

>Are you running XP firewall on that machine? If so, turn it off and any
>other firewall (Norton Internet Security, etc).
>Chris
>"ITM" <itm@.nospam.com> wrote in message
> news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.
4ax.com...
>
I've tried turning off XP firewall but it made no difference. I'm not
running Norton, but am using AVG anti-virus (free edition). No other
firewall/AV software installed.
Ian|||What happens when you telnet to port 1433 on that machine (or whatever port
you're running it on)?
Chris
"ITM" <itm@.nospam.com> wrote in message
news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.
4ax.com...
> On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
> <schmidtc@.KvalleyDotCom> wrote:
>
> I've tried turning off XP firewall but it made no difference. I'm not
> running Norton, but am using AVG anti-virus (free edition). No other
> firewall/AV software installed.
> Ian|||On Sun, 20 Mar 2005 09:41:09 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:

>What happens when you telnet to port 1433 on that machine (or whatever port
>you're running it on)?
>Chris
>"ITM" <itm@.nospam.com> wrote in message
> news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.
4ax.com...
>
Have just downloaded and installed SP3 for SQL Server - it seems to
have done the trick. Should've tried that before :-(

Cant connect to SQL Server (developer edition) from another PC?

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
IanITM (itm@.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/defaul...B;EN-US;q328306.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

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