Active Directory Password Authentication

Toad for SQL Server
1

Is it possible to authenticate using Active Directory Password Authentication in Toad for SQL Server 6.8? In Microsoft SQL Server Management Studio there’s an option for this, but in Toad for SQL Server there’s only “Windows Authentication” and “SQL Server Authentication”. My Login name is my email address, e.g., last.first@domain.com. When I login with SQL Server Authentication in Toad, it fails with the error message “Cannot open server “domain.com” requested by the login. The login failed.”

Thanks in advance

2

Hi Lukhon,

Active Directory Password Authentication was not support in this version of Toad.

and we are working on this feature, we will try to support it in next version fo Toad.

Thanks,

Michael

3

Hi Michael,
I also need this method of authentication. I see it is not offered. What workaround is available from Toad/Quest if there is no flexibility to change the method on SQL Server?
Thank you

4

Hi,
there are four connection methods available in Toad for SQL Server 7.2:
image

5

I need to know how to change the Domain for the windows authentication.
It automatically picks up the domain\login from the network login. but all our DB's are accessed through a different domain shared group through AD. I can not change the domain.
I am on a trial licence if that makes a difference.

6

Hi Shelley, what happens when you enter "domain\login" manually?

7

I am getting the Certificate Chain Error when attempting to use Toad for SQL Server 7.2 to connect from my home PC (over VPN) to corporate server using my corp AD

AKI-BOBSRV01.tbaki.com ... TBAKI\msilberkleit

I tried adding the TrustServerCertificate True parameter and it seemed to change the error to
Logon Failed for user ... no user name is given.

on one server I did try setting the NAtive Client Parameter Trust Server Certificate = yes .. and restarted .. same error Login Failed for User with no name .. yet I can logon locally no problem ..