Re: SQL Server does not exist or access denied

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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" <NCollins@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3EC82DD9-61B8-43DC-9ED4-75F9602D1711@xxxxxxxxxxxxxxxx
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


.



Relevant Pages

  • Re: Umstieg von Access auf SQL-Server
    ... > Bei Port 1433 sabber ich dann immer gleich Named Pipes. ... Nein, TCP/IP. ... How To Change SQL Server Default Network Library Without ... How To Set the SQL Server Network Library in an ADO Connection String ...
    (microsoft.public.de.vb.datenbank)
  • Re: Problem connecting ODBC to SQL
    ... Stephen, as mentioned by Tom, please try TCP/IP. ... I am new to using SQL Server. ... connection to SQL Server. ...
    (microsoft.public.data.odbc)
  • Re: Can I Upgrade
    ... Yes I am using the program svrnetcn to configure the protocols. ... As you can see SQL server is only listening on Shared Memory ... So the big question of the day is why is Named Pipes and TCP/IP not ... Microsoft SQL Server 2000 Developer Edition. ...
    (microsoft.public.sqlserver.setup)
  • Re: Slow access on XP using ADO with ODBC to SQL Server 2000 - any ideas?
    ... Just a thought but you might try changing the SQL server name in the ... connection string to the server's IP address as a test. ... | and keep all the machines here configured the same way using TCP/IP. ...
    (microsoft.public.data.ado)
  • RE: Tracing SQL Server 2000 Connections
    ... In TCP/IP network model, there is no middle ground between Transport layer ... you get all the requests all the way into your SQL Server. ...
    (microsoft.public.sqlserver.connect)