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

Re: Unable to connect Client to SQL Server

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Unable to connect Client to SQL Server
Date	Tue, 11 Mar 2014 08:51:58 +0000 (UTC)
Organization	Erland Sommarskog
Lines	34
Message-ID	<XnsA2ED645E08739Yazorman@127.0.0.1> (permalink)
References	<lfit86$thr$1@speranza.aioe.org> <XnsA2EC5B95F23F9Yazorman@127.0.0.1> <lfl1cr$e5b$1@speranza.aioe.org> <XnsA2ECD650A5C8DYazorman@127.0.0.1> <lflktn$1ek$1@speranza.aioe.org>
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
Injection-Date	Tue, 11 Mar 2014 08:51:58 +0000 (UTC)
Injection-Info	mx05.eternal-september.org; posting-host="5d404a5d864426cbf50ddbcd9433a6e4"; logging-data="3426"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18rFo0ELra78zim2qznVTPc"
User-Agent	Xnews/2005.10.03 Mime-proxy/1.4.c.4 (Win32)
Cancel-Lock	sha1:f/UAG40Lrso0vCngDqvk/UxZuJs=
Xref	csiph.com comp.databases.ms-sqlserver:1715

Show key headers only | View raw

Bruno Campanini (brunocam@libero.it) writes:
> - TCP/IP enabled
> - FILESTREAM enabled
> - Allow remote connection to the server
> - SQL Server Services are running
> - SQL Server Browser is running
> - SQL Server Agent stopped (it doesn't start!)
> - Firewall disabled on Server and Client
> 
> It seems all is ok, but it's three days I try to connect a Client,
> without any success!
> 

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.

Also try to make the connection from the command line with SQLCMD. It should
give the same error, but you never know.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

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