#64 Kerberos authentication for SQL Server

[Anupinder Rai]

HI,
I am interested to use sqsh for Kerberos authentication to connect to SQL Server. I could find any proper documentation for this.Can someone please provide some hints .
I have Kerberos environment fully configured. I am using sqsh 2.1.7.

sqsh -Sservername -Uusername -Z
sqsh-2.1.7 Copyright (C) 1995-2001 Scott C. Gray
Portions Copyright (C) 2004-2010 Michael Peppler
This is free software with ABSOLUTELY NO WARRANTY
For more information type '\warranty'
sqsh: ERROR: Network Authentication not supported

[Martin Wesdorp]

Hi,

Currently sqsh only supports the Kerberos implementation of SAP/Sybase OpenClient to connect to ASE using SSO. To connect to MSSQL you'll need the FreeTDS driver. The FreeTDS middleware implementation of Kerberos is much different from the SAP/Sybase one and it requires some coding effort to implement. Maybe I will add FreeTDS gssapi support in a later version.

Hope this helps.

Best regards,
Martin.

[Vento]

Try this:

kinit -k -t mykeytab myprincipal
sqsh -S myserver -U "" -P "" -D mydb -C "select 1"

In order to use Kerberos authentication, you must specify the "-U", "- P" parameters with empty values. Actual for versions sqsh since 2.1.7 and later.

[Anupinder Rai]

HI Vento,
Thanks a lot.It worked.

Thanks,
Anup

On Wed, Feb 13, 2019 at 4:56 AM Vento vento@users.sourceforge.net wrote:

Try this:

kinit -k -t mykeytab myprincipal
sqsh -S myserver -U "" -P "" -D mydb -C "select 1"

In order to use Kerberos authentication, you must specify the "-U", "- P"
parameters with empty values. Actual for versions sqsh since 2.1.7 and
later.

---

• [bugs:#64] https://sourceforge.net/p/sqsh/bugs/64/ Kerberos
  authentication for SQL Server*

Status: open
Group: v2.1
Labels: Kerberos SQL Server
Created: Tue Sep 06, 2016 08:07 PM UTC by Anupinder Rai
Last Updated: Wed Sep 07, 2016 07:19 PM UTC
Owner: Michael Peppler

HI,
I am interested to use sqsh for Kerberos authentication to connect to SQL
Server. I could find any proper documentation for this.Can someone please
provide some hints .
I have Kerberos environment fully configured. I am using sqsh 2.1.7.

sqsh -Sservername -Uusername -Z
sqsh-2.1.7 Copyright (C) 1995-2001 Scott C. Gray
Portions Copyright (C) 2004-2010 Michael Peppler
This is free software with ABSOLUTELY NO WARRANTY
For more information type '\warranty'
sqsh: ERROR: Network Authentication not supported

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/sqsh/bugs/64/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/