SQL Server does not exist or access denied

Sue,

Sorry, did not work. Here are the results below


Microsoft SQL Server ODBC Driver Version 03.86.1830

Running connectivity tests...

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

TESTS FAILED!





Microsoft SQL Server ODBC Driver Version 03.86.1830

Data Source Name: test
Data Source Description: test
Server: DSL-COMPUTER2
Database: (Default)
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: Yes
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No
 >> Stay informed about: SQL Server does not exist or access denied 

There are over 20 possible causes listed in the article in
addition to which there are over 20 other links to follow to
try to address the issue. Running just connectivity tests
does nothing. There is just not enough info in your post for
anyone to provide specific steps or fixes. You need to work
through the entire article. Please note all of the different
variables that come into play that you can extrapolate from
reading the article: Protocols, the client, the version of
SQL Server, the edition of SQL Server, DSNs, registry
settings, firewall settings, TCP/IP issues, etc.

-Sue

On Wed, 5 Apr 2006 03:07:02 -0700, hal
wrote:

>
>
>Sue,
>
>Sorry, did not work. Here are the results below
>
>
>Microsoft SQL Server ODBC Driver Version 03.86.1830
>
>Running connectivity tests...
>
>Attempting connection
>[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist
>or access denied.
>
>TESTS FAILED!
>
>
>
>
>
>Microsoft SQL Server ODBC Driver Version 03.86.1830
>
>Data Source Name: test
>Data Source Description: test
>Server: DSL-COMPUTER2
>Database: (Default)
>Language: (Default)
>Translate Character Data: Yes
>Log Long Running Queries: No
>Log Driver Statistics: No
>Use Integrated Security: Yes
>Use Regional Settings: No
>Prepared Statements Option: Drop temporary procedures on disconnect
>Use Failover Server: No
>Use ANSI Quoted Identifiers: Yes
>Use ANSI Null, Paddings and Warnings: Yes
>Data Encryption: No
 >> Stay informed about: SQL Server does not exist or access denied 

Sue,

Do you know of a diagnosis tool to narrow the specific cause

Hal
 >> Stay informed about: SQL Server does not exist or access denied 

It depends on the error. So going back....the thing to do is
work through ALL the steps in the troubleshooting article,
follow all the links in the article, etc. The article is
long because the issue can be one of hundreds of things with
the error SQL Server does not exist or access denied
You need to narrow down the causes by going through the
article.

-Sue

On Thu, 6 Apr 2006 03:41:01 -0700, hal
wrote:

>Sue,
>
>Do you know of a diagnosis tool to narrow the specific cause
>
>Hal
>
 >> Stay informed about: SQL Server does not exist or access denied 

Sue,

I received the following error message on installing MDAC 2.0

MDAC 2.6 Setup
Snap-in failed to initialize
Name Sql Server Configuration Manager
CLSID {CA9F82727-31DF-41D2-975C-887D84903967}

Does this help narrow down the error

Hal
 >> Stay informed about: SQL Server does not exist or access denied 

No. You wouldn't want to be installing MDAC 2.0 though. And
the error is for MDAC 2.6 - I'm not sure what you are doing.

-Sue

On Fri, 7 Apr 2006 05:05:01 -0700, hal
wrote:

>
>Sue,
>
>I received the following error message on installing MDAC 2.0
>
>MDAC 2.6 Setup
>Snap-in failed to initialize
>Name Sql Server Configuration Manager
>CLSID {CA9F82727-31DF-41D2-975C-887D84903967}
>
>Does this help narrow down the error
>
>Hal
 >> Stay informed about: SQL Server does not exist or access denied 

It sounds like your server is not listening over TCP/IP. User SQL Server
Configuration Manager to ensure that the TCP/IP protocol is enabled. You
can also verify the port setting while you are there.

Chuck Heinzelman

"NCollins" wrote in message

> Hal,
>
> Did you get a resolution for this problem? I am having the same and have
> tried everything.
> --
> nwc
>
>
> "hal" wrote:
>
>> How do I resolve the Micosoft SQL Server Login Error Message Prompts:
>>
>> Connection fail:
>> SQLState: 08001
>> SQL Server ERROR: 17
>> {Microsoft}{ODBC SQL Server Driver} {TCP/IP Sockets} SQL Server does not
>> exist or access denied
>>
>> Regards,
>> Hal
 >> Stay informed about: SQL Server does not exist or access denied 

Thanks for the response. I am on vacation now but will invetsugate when I
return.
--
nwc


"Chuck Heinzelman" wrote:

> It sounds like your server is not listening over TCP/IP. User SQL Server
> Configuration Manager to ensure that the TCP/IP protocol is enabled. You
> can also verify the port setting while you are there.
>
> Chuck Heinzelman
>
> "NCollins" wrote in message
>
> > Hal,
> >
> > Did you get a resolution for this problem? I am having the same and have
> > tried everything.
> > --
> > nwc
> >
> >
> > "hal" wrote:
> >
> >> How do I resolve the Micosoft SQL Server Login Error Message Prompts:
> >>
> >> Connection fail:
> >> SQLState: 08001
> >> SQL Server ERROR: 17
> >> {Microsoft}{ODBC SQL Server Driver} {TCP/IP Sockets} SQL Server does not
> >> exist or access denied
> >>
> >> Regards,
> >> Hal
>
>
>
 >> Stay informed about: SQL Server does not exist or access denied