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

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!newsfeed.datemas.de!rt.uk.eu.org!aioe.org!.POSTED!not-for-mail
From	Bruno Campanini <brunocam@libero.it>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Unable to connect Client to SQL Server
Date	Wed, 12 Mar 2014 17:10:29 +0100
Organization	Aioe.org NNTP Server
Lines	26
Message-ID	<lfq0to$k69$1@speranza.aioe.org> (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> <XnsA2ED645E08739Yazorman@127.0.0.1> <lfn01j$r2$1@speranza.aioe.org> <XnsA2EDD5DCC29C5Yazorman@127.0.0.1> <lfppd5$vev$1@speranza.aioe.org> <XnsA2EEA7FCDF520Yazorman@127.0.0.1>
Reply-To	brunocam@libero.it
NNTP-Posting-Host	//uEY67TBfFY4BQmJwuR4g.user.speranza.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding	8bit
X-Complaints-To	abuse@aioe.org
X-Notice	Filtered by postfilter v. 0.8.2
X-Newsreader	MesNews/1.08.05.00-gb
X-ICQ	1701145376
Xref	csiph.com comp.databases.ms-sqlserver:1722

Show key headers only | View raw

After serious thinking Erland Sommarskog wrote :
> Bruno Campanini (brunocam@libero.it) writes:
>> Nothing new, even with command line.
>> 
>
> So even if you said tcp:SERVER you got which error?
I get Connection string is not valid [67]
Server not found or not accessible

With sqlcmd -S server -H 192.168.1.202 -U xxx -P yyy
I get
Server not found or not accessible

Firewaal is disabled
SQL Server Browser is enabled and started
Protocol IP is enabled

I can connect SQL Server from within the same PC, but not
from a remote PC:
   not with sqlcmd
   not from within Access
   not with a remote SQL Server Management Studio

I'm just becoming crazy!!!

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