sql server connect: Randy,

Try
INF: Potential Causes of the "SQL Server Does Not Exist or Access Denied"
Error Message
http://support.microsoft.com/?id=328306

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

[quoted text, click to view]

I have SQL Server 2000 running on a remote server, but can't seem to get
connected to it. It is a named instance, and I opened that port and 1433 &
1434. I have them forwarded to my Server, but I still can't see the
database? I can't ping the IP address, but I have a web site at the same
address and it works fine. Is there another port or something that I need
to configure? I do have it configured to listen on tcp/ip only. I have
tried to connect through VB6 and Enterprise Manager, and get the "SQL Server
does not exist or Access Denied" message.

Any help would be greatly appreciated.


Thanks,

Randy

Hi Randy,

I would like you to provide the following information so that I can narrow
this problem down for you.
1. To expedite process of troubleshoot, could you post the detailed error
message?

2. From your description "I can't ping the IP address, but I have a web
site at the same address and it works fine", It seems that the error is
mostly caused by the network problem. Can you connect to the web site via
IE?

3. Is there any firewall software on your Server side or Client side? If
so, please stop the software and try to connect to the SQL Server. Do any
errors occur?

4. Also, Does this error occur on the special client computer? If it is
possible, I would like you to change a client computer to connect to the
SQL Server. How is the connectivity from other client computers to the SQL
Server?

5. Could you please post the SQL Server error log? (Usually under
C:\Program Files\Microsoft SQL Server\MSSQL\LOG)

I am standing by for your response.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[quoted text, click to view]

Run-time error '-2147467259 (80004005)':

[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access
denied.

[quoted text, click to view]

Yes I can get to the web site from my home computer in IE.

[quoted text, click to view]

The only firewall is the router, and I have opened up ports 1433, 1434 &
3759 and forwarded them to the servers IP address.

[quoted text, click to view]

I am trying to access the server from my home computer. I haven't tried
from any other location.

[quoted text, click to view]

2003-09-02 09:53:12.84 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2003-09-02 09:53:12.95 server Copyright (C) 1988-2000 Microsoft
Corporation.
2003-09-02 09:53:12.95 server All rights reserved.
2003-09-02 09:53:12.95 server Server Process ID is 1080.
2003-09-02 09:53:12.95 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$PASSAIC\log\ERRORLOG'.
2003-09-02 09:53:13.10 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2003-09-02 09:53:14.78 server SQL Server configured for thread mode
processing.
2003-09-02 09:53:14.84 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2003-09-02 09:53:15.24 server Attempting to initialize Distributed
Transaction Coordinator.
2003-09-02 09:53:22.31 spid4 Starting up database 'master'.
2003-09-02 09:53:26.06 server Using 'SSNETLIB.DLL' version '8.0.194'.
2003-09-02 09:53:26.06 spid5 Starting up database 'model'.
2003-09-02 09:53:26.29 spid4 Server name is 'IMAGESERVER\PASSAIC'.
2003-09-02 09:53:27.03 spid8 Starting up database 'msdb'.
2003-09-02 09:53:27.14 spid9 Starting up database 'pubs'.
2003-09-02 09:53:27.14 spid10 Starting up database 'Northwind'.
2003-09-02 09:53:27.17 spid11 Starting up database 'ACSOnline'.
2003-09-02 09:53:28.15 spid5 Clearing tempdb database.
2003-09-02 09:53:37.23 spid5 Starting up database 'tempdb'.
2003-09-02 09:53:39.04 spid4 Recovery complete.
2003-09-02 09:53:46.57 server SQL server listening on TCP, Shared Memory.
2003-09-02 09:53:46.57 server SQL server listening on 192.168.0.133:3759,
127.0.0.1:3759.
2003-09-02 09:53:46.57 server SQL Server is ready for client connections

[quoted text, click to view]

Thanks Everyone!

As always it was something little and stupid that was giving me headaches.

I was specifying the port number but with a colon instead of a comma. Once
I changed that the connection went right through.


Thanks again,

Randy


[quoted text, click to view]

Hi Randy,

Thanks for your feedback. I also would like to thank for Dinesh's help.
This information provided by Dinesh in the previous post is very useful to
troubleshoot this problem. Your patience is appreciated. I would like you
to try and check the steps in the mentioned article below:
328306 INF: Potential Causes of the "SQL Server Does Not Exist or Access
http://support.microsoft.com/?id=328306

From you description, I searched on our documents and would like you to
install the latest version MDAC on your client machine. For additional
information regarding the latest version of MDAC, please refer to the
following article:
Microsoft Data Access Components (MDAC) 2.8
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-
b037-185d0506396c&DisplayLang=en

Can you connect to the SQL Server successfully?

If not, I would like you to provide more information below:
1. "But can't seem to get connected to it."

How do you connect to the SQL Server? Do you mean you connect to SQL Server
using Query Analyzer?

2. Because there is a known issue regarding Connecting to Clustered Named
Instance through a firewall. Could you confirm if your named instance on
your remote computer is clustered named instance?

For additional information regarding this issue, please refer to the
following article:
265808 INF: How to Connect to an SQL Server 2000 Named Instance with the
http://support.microsoft.com/?id=265808

Hope it helps and I am standing by for your response.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.