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?