SQL Server database using Active Directory authentication

Question

Hi Team,

I am trying to connect to a SQL Server database using Active Directory authentication method with following connection string format . For this i have full powershell script and which is working fine in local machine but while i try to configure it through Enterprise jenkins getting error as Error connecting to the database server: Exception calling ".ctor" with "1" argument(s): "Keyword not supported: 'authentication'." Can some one help me to fix this error .

Server=,1433;Initial Catalog=;Persist Security Info=False;User ID=;Password=;authentication=ActiveDirectoryPassword;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;column encryption setting=enabled;Connection Timeout=30;

Answer 1

Erland Sommarskog Can you explain a little more? or share any document link. which API ?

To communicate with SQL Server, an application must use a client API. There are many such APIs in sway, and which an applicaiton would use, largely depends on what it is implemented in. A .Net application would use SqlClient, a Java application would use JDBC. An application written in C++ would use ODBC or OLE DB, and there are a few more options.

Furthermore, client APIs are not cast in stone, but they come out in new versions to keep up with new features in SQL Server and the cloud. The Authentication keyword is relatively new addition, maybe 3-4 years old. So if you are using an version of Enterprise Jenkins from, say, 2015, it is not likely that it will support AAD authentication.

In any case, as I said, you need to find a support forum for Enterprise Jenkins to have this issue resolved.

Answer 2

I don't know anything about Enterprise Jenkins, but from the error message it is clear that it is using a client API of an older version that does not support the Authentication keyword in the connection string.

I would suggest that you find a forum for Jenkins to inquire what your options may be.