Groups > comp.databases.ms-sqlserver > #1718

Re: Unable to connect Client to SQL Server

From	Bruno Campanini <brunocam@libero.it>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Unable to connect Client to SQL Server
Date	2014-03-11 13:37 +0100
Organization	Aioe.org NNTP Server
Message-ID	<lfn01j$r2$1@speranza.aioe.org> (permalink)
References	(1 earlier) <XnsA2EC5B95F23F9Yazorman@127.0.0.1> <lfl1cr$e5b$1@speranza.aioe.org> <XnsA2ECD650A5C8DYazorman@127.0.0.1> <lflktn$1ek$1@speranza.aioe.org> <XnsA2ED645E08739Yazorman@127.0.0.1>

Show all headers | View raw

Erland Sommarskog was thinking very hard :

> The error message talks about named pipes, and the error code is 5, which 
> usually means "Access is denied". There could be two reason it is trying 
> TCP/IP: TCP/IP is not enabled on the client, or it using named pipes as a
> fallback when TCP/IP fails.
>
> You could try enabling Named Pipes on the sarver, but I don't really 
> recommend it.
>
> Instead try specifying the server as SERVER,tcp to force TCP/IP to see what
> error message we get this time.
With "SERVER,192.168.1.204" I get Error 87 and Error 0
With "SERVER,tcp" the same 87 and 0
>
> Also try to make the connection from the command line with SQLCMD. It should
> give the same error, but you never know.
Command line SQLCMD from where?... not from Dos Prompt.
And what sintax?

Bruno

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-10 00:24 +0100
  Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-10 08:00 +0000
    Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-10 19:47 +0100
      Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-10 21:04 +0100
        Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-11 01:21 +0100
          Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-11 08:51 +0000
            Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-11 13:37 +0100
              Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-11 21:01 +0100
                Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-12 15:02 +0100
                Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-12 15:30 +0000
                Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-12 17:10 +0100
                Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-12 17:46 +0100
                Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-12 21:16 +0100
                Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-12 21:45 +0100
                Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-12 23:20 +0100

csiph-web