freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Authentication with tsql

From: Frediano Ziglio <freddyz77 AT tin.it>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>, Michael Stembridge <mstembridge AT gmail.com>
Subject: Re: [freetds] Authentication with tsql
Date: Sat, 23 Jul 2005 09:12:45 +0200

Il giorno ven, 22/07/2005 alle 15.36 -0400, Michael Stembridge ha
scritto:
> The online documentation has several connection options listed,
> including Server, UID and PWD.
>

I think you are using ODBC...

> Will I need to provide a valid Username and Password for that actual
> system, or a SQL username & password? I actually tried using a
> local system account to access with tsql, but that yeilded "login
> incorrect".
>
> My syntax was:
> tsql -Sintranetservername -Userveraccount -Paccountpassword
>

For -S you have to specify a server configured in freetds.conf, not a
"intranetservername". If you want to use system accounts use "domain
\user" syntax for user.

freddy77

[freetds] Authentication with tsql, Michael Stembridge, 07/22/2005
- Re: [freetds] Authentication with tsql, Frediano Ziglio, 07/23/2005