Solved

Database connector with Azure SQL database

  • 27 May 2022
  • 1 reply
  • 162 views
R
Rank

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?

icon

Best answer by rzwambag 27 May 2022, 11:27

View original
This topic has been closed for comments

1 reply

R
Rank

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;

 

Terms & ConditionsCookie settings