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



Firewall not opened?
/Henning

"winwin" <u22379@uwe> skrev i meddelandet news:60f3d2b1d9de8@xxxxxx
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


.



Relevant Pages

  • Re: Sql Remote Connection issue
    ... Remote access is set to 1. ... Sql Server is listening on 127.0.0.1:1433. ... The above would indicate it's using the default port. ... To verify the connection I'm using telnet to verify communications is ...
    (microsoft.public.sqlserver.connect)
  • Re: Best Practice for multiple servers
    ... >> separate SQL Server 2000 machine. ... remote access of some ... not set up the network yet. ...
    (microsoft.public.windows.server.sbs)
  • Remote connect and encounter SQL Server does not exist or access denied.
    ... I have tried to remote access my SQL server (from remote host to our ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ... When I try to connect within our LAN (from one PC to the local SQL server) it ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL 2005 Express Config
    ... Configuring Remote Access ... saying that the SQL Server does not exist as shown below. ... SQL Server Error: 6 ...
    (microsoft.public.sqlserver.setup)
  • Activating MSDE for remote Access
    ... I'm finding that when I install MSDE, by default no protocols are enabled ... for remote access. ... But how can I do this without having the SQL Server Client Tools installed? ...
    (microsoft.public.sqlserver.msde)

Loading