Forum > Databases

[Solved] MSSQLConnection with windows authentification

(1/1)

Zoran:
By following the wiki, I installed FreeTDS dll files and I managed to connect to MSSQLServer using sql server login.

However, I don't know how to connect using Windows authentification. Is it possible at all with MSSQLConnection?

Remy Lebeau:
Simply leave the UserName and Password properties blank.  This is stated in the TMSSQLConnection documentation:

https://www.freepascal.org/docs-html/fcl/mssqlconn/tmssqlconnection.username.html
https://www.freepascal.org/docs-html/fcl/mssqlconn/tmssqlconnection.password.html


--- Quote ---TMSSQLConnection specific: if you don't enter a UserName and Password, the connector will try to use Trusted Authentication/SSPI (on Windows only).

--- End quote ---

SSPI is how MSSQL uses Windows authentication.

Zoran:
Ah, so simple, I missed it in docs.  :-[
Thank you, Remy, yes it works.

Navigation

[0] Message Index