topic Python Extension SDK fails connecting to MS SQL Server by using Windows Authentication - Linux AGs in Extensions

Python Extension SDK fails connecting to MS SQL Server by using Windows Authentication - Linux AGs

chris_cho — Fri, 02 Jan 2026 09:33:43 GMT

Hello,
I created a generic custom extension using Dynatrace Python Extensions SDK to extract some data from MS SQL Servers - database tables.
Below are some specs:

ActiveGates are RHEL VMs with Python 3.6
for development I am using VS Code with Python 3.10.
connecting to MS SQL Server, I am using pypyodbc with driver ODBC Driver 17 for SQL Server; due to some compatibility issues I cannot use pyodbc. The functionality should be same as pypyodbc
additionally on the Linux AGs, to work with pypyodbc, I installed unixODBC, unixODBC-devel, msodbcsql17.
connecting to the target MS SQL servers we use Windows authentication, by providing AD usernames and passwords
the Python code uses the connection string as

conn_str = (f"DRIVER={{ODBC Driver 17 for SQL Server}};" f"SERVER={self.sql_server};" f"DATABASE={self.sql_database};" f"UID={self.ad_username};" f"PWD={self.ad_password};" "Encrypt=yes;" "TrustServerCertificate=yes;" "Connection Timeout=5;" )

where UID is provided from the extension UI as "domain\username".

It looks like the MS SQL servers consider the username and password as SQL Authentication, and not as Windows Authentication.
I have tried other properties defining the connection string conn_str, but still the code fails due to the exception.

Error fetching data from SQL Server for feed 'poc_mssql_extract': ('28000', "[28000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user '<domain>\\<username>'.")

where <domain>\<username> are the AD domain and username, provided by the extension UI, along with the password.
On the other hand, I tested the domain, username and password, by creating a SQL Extension from, Custom Extensions Creator, using NTLM Authentication. I executed successfully this SQL extension that connected to MS SQL Server and retrieved the expected dataset from.

Please let me know if you have any suggestions or workaround to my custom extension, created with Dynatrace Python Extensions SDK, connecting to MS SQL Server and getting data from.

Regards,

Chris

The UI configuration of my custom extension (SDK)	The UI configuration of Dynatrace SQL extension

Re: Python Extension SDK fails connecting to MS SQL Server by using Windows Authentication - Linux AGs

ChrisAtNG — Thu, 08 Jan 2026 22:50:42 GMT

I was recently in a similar situation. I ended up using pytds instead of pyodbc. The extension runs on Linux Active Gates. We have SQL Server running on both Windows and Linux servers. As I understand, pytds will work with Windows Authentication on Windows servers only, not Linux, although there may be a workaround. I am using sql authentication on both Windows and Linux servers and it works well for the most part.

Re: Python Extension SDK fails connecting to MS SQL Server by using Windows Authentication - Linux AGs

chris_cho — Fri, 09 Jan 2026 00:33:40 GMT

Thanks for your reply,

The Python libraries are accepted and provided within the company repo, thus I cannot use anyone.
The only library is working for me is pypyodbc being implemented for both Windows and Linux.
Additionally, based on the security policies the company doesn't allow SQL Server authentication, Windows authentication using AD service accounts.
However, I found a workaround using Windows authentication from Linux AGs, connecting to a Microsoft SQL Server, by impersonating the service account through Kerberos authentication at the time connecting to the SQL server.
This solution works for me, for now 🙂