Remote connect and encounter SQL Server does not exist or access denied.

From: "winwin" <u22379@uwe>
Date: Mon, 29 May 2006 01:55:34 GMT

Hi,

I have tried to remote access my SQL server (from remote host to our
localserver) but there is an error as below:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist
or access denied.

When I try to connect within our LAN (from one PC to the local SQL server) it
works great.

Pls advise......

winwin
.

Follow-Ups:
- Re: Remote connect and encounter SQL Server does not exist or access denied.
  - From: Henning

Prev by Date: Help for SQL 2000 connection??
Next by Date: SQL Server (2005 or other) - Permissions on Views Excel Connection
Previous by thread: Help for SQL 2000 connection??
Next by thread: Re: Remote connect and encounter SQL Server does not exist or access denied.
Index(es):
- Date
- Thread

Relevant Pages

Error 80040e14
... I have a simple Stored Procedure and all it does is it adds 4 ... Microsoft OLE DB Provider for SQL Server ...
(microsoft.public.sqlserver.programming)
VSS Errors using NTBackup
... Microsoft OLE DB Provider for SQL Server ... Error message: ...
(microsoft.public.windows.server.sbs)
Re: OLE DB Error 999 "Object Was in Use"
... Steven Bras wrote: ... Microsoft OLE DB Provider for SQL Server ...
(microsoft.public.data.ado)
Re: linked tables
... > Microsoft OLE DB Provider for ODBC Drivers ... then access the Jet table with a 4-part name ... provider, instead of the one for Jet. ... table defined in the Access database which is linked to a SQL Server ...
(microsoft.public.vb.database.ado)
Re: Oracle & SQL Server
... > Then consider to create Views to make it easy to access the remote Oracle ... Microsoft OLE DB Provider for SQL Server ...
(microsoft.public.sqlserver.programming)