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 15:02:17 +0100
Organization: Aioe.org NNTP Server
Lines: 22
Message-ID: <lfppd5$vev$1@speranza.aioe.org>
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>
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:1720

Erland Sommarskog submitted this idea :
> Bruno Campanini (brunocam@libero.it) writes:
>> With "SERVER,192.168.1.204" I get Error 87 and Error 0
>> With "SERVER,tcp" the same 87 and 0
>
> Mea culpa! I completely confused the syntax. That is the syntax to
> force a certain port number. This is what you should try to force TCP/IP:
>
>   tcp:SERVER
>
>> Command line SQLCMD from where?... not from Dos Prompt.
>
> Why not? If you installed SQL Server Native Client, I believe that you 
> get SQLCMD with the bundle. But I might be wrong.
>
>> And what sintax?
>  
> SQLCMD -S server -U user -P pwd

Nothing new, even with command line.

Bruno