DAP CLI - MSSQL connection with Windows Authentication

[wa22]

Hi there, 

We're new to the DAP CLI (for MSSQL) and we managed to get the initdb and syncdb working with MSSQL using SQL Authentication. However does anyone managed to connect to the MSSQL with Windows Authentication and if so, how should the connection string be looked like?

Many thanks in advance!

WL

[sgergely]

Hello @wa22!

Great question! DAP CLI uses pysqlsync to connect to various databases, and this dependency is using pyodbc to connect MSSQL. We don't test your use case, only ODBC based connections.

So I have just searched around for solutions and I have ended up on this page: https://stackoverflow.com/questions/16515420/connecting-to-ms-sql-server-with-windows-authentication...

I haven't verified if it works, nor support it officially but it might help you.

[wa22]

Hello, thanks for your reply. Did you mean I should specify the connection string like below? 

cnxn = pyodbc.connect(r'Driver=SQL Server;Server=.\SQLEXPRESS;Database=myDB;Trusted_Connection=yes;')

The question is the DAP CLI accepts "--connection-string mssql://username:password@servername:port/instancename", I couldn't relate the two different string to get around it ...