[freetds] Authentication with tsql

Frediano Ziglio freddyz77 at tin.it
Sat Jul 23 03:12:45 EDT 2005


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





More information about the FreeTDS mailing list