July 20, 2009 at 11:06 am
I've installed SQL Server 2000 Developer Edition on a Windows Vista machine. It's installed without any problems.
When I try to connect to it from another PC (Windows 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?
I've also used Connection Strings but i get the same error
July 20, 2009 at 11:38 am
Be sure you allow remote connections. This is disabled by default in some places.
Also, check the firewall. That would be my guess that it's preventing TCP 1433 from coming through.
July 20, 2009 at 12:10 pm
I thought every developer edition from 2000 onward was configured with only shared memory turned on at default. You probably have to turn TCP/IP on as well as what the editor pointed out, make sure the firewall isn't blocking in..
CEWII
July 21, 2009 at 9:08 am
Be sure you allow remote connections. This is disabled by default in some places.
Also, check the firewall. That would be my guess that it's preventing TCP 1433 from coming through.
How can i do that please.
I've checked the Server Network utility and found the protocols to be enable.
Please do enlighten me.
Thank you.
July 21, 2009 at 9:35 am
The firewall is a Vista thing. Check the control panel, Firewall. Be sure that it allows SQL Server or 1433, 1434 through.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply