Skip to main content

When I connect to an external database with the database connector I get the following error: 

ERROR  HY000]  Microsoft]]ODBC SQL Server Driver]]SQL Server]Windows logins are not supported in this version of SQL Server.
ERROR 01S00] Microsoft]]ODBC SQL Server Driver]Het kenmerk voor de verbindingsreeks is ongeldig
ERROR HY000] Microsoft]]ODBC SQL Server Driver]]SQL Server]Windows logins are not supported in this version of SQL Server.
ERROR 01S00] Microsoft]]ODBC SQL Server Driver]Het kenmerk voor de verbindingsreeks is ongeldig

I use the following Connection string:

Driver={SQL Server}; Server=xxxxx.database.windows.net,1433; Database=xxxxx; User Id=xxxxx; Password=xxxxx;

I tried different variations based, for example to add the following to the connection string: 

Trusted_Connection=False;Encrypt=True;

I couldn’t get it working, is there maybe someone with a solution?

I tried another driver and now I’ve got it working with the following connection string:

Driver={ODBC Driver 17 for SQL Server}; Server=xxxxx.database.windows.net; Database=xxxxx; UID=xxxxx; PWD=xxxxx;