What port is your SQL Server on? Could it be an ODBC connection error ?
The dynamic port setting may be looking at 1433 when it is actually on a
different port?

Mike


-----Original Message-----
From: Sheri Wallentine
[mailto:mssqldba-ezmlmshield-x30704651.[Email address protected]
Sent: Monday, July 30, 2007 3:45 PM
To: LazyDBA Discussion
Subject: Connection failed error

Hi,



I have a remote user that is connecting to our network through a VPN.
When he tries to log in to the CRM application that uses sql db, he gets
an error. Our local users are not having this issue. The remote user
is running XP Pro, SP 2. SQL Server 2000 is being run on a Windows 2000
Server, SP 4.



Connection failed:

SQLState: '01000'

SQL Server Error: 11001

[Microsoft][ODBC SQL Server Driver][TCP/IP
Sockets]ConnectionOpen(connect())

Connection failed:

SQLState: '08001'

SQL Server Error: 6

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server
not found



Sheri Wallentine

Network Specialist

PremiumWear Inc.

Office: 952.960.5041

Fax: 952.979.1717





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page