Ive had this before many years ago, you sure all service packs and hotfixes
aren't up to date(not only sql)? I am trying to remember ... could also be
to do with permissions..
Vanessa Fredanus- van Gelder| SQL DBA | DXS Systems | Tel. +27 21 853 3317|
Fax. +27 21 854 7953
You must be the change you want to see in the world. Mahatma Gandhi
-----Original Message-----
From: Hajkowski Michael
[mailto:mssqldba-ezmlmshield-x30241640.[Email address protected]
Sent: 30 July 2007 09:52
To: LazyDBA Discussion
Subject: RE: Connection failed error
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
---------------------------------------------------------------------
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
---
DXS - The Essential Healthcare Information Solution
http://www.dxs-systems.com/
DISCLAIMER:
This communication (including any attachments) may contain confidential or proprietary information. If you are not the intended recipient and you have received this communication in error, you should destroy it without copying, disclosing or otherwise using its contents and notify the sender immediately of the error.
Internet communications are not necessarily secure, and may be monitored, intercepted or changed after they are sent. DXS and its subsidiaries do not accept liability for any loss you may suffer as a result of interception, or any liability for such changes.
MS Sql Server LazyDBA home page