Skip to main content
Solved

Database connector with Azure SQL database

  • May 27, 2022
  • 1 reply
  • 211 views
R
Rookie

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?

Best answer by rzwambag

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;

 

View original
    This topic has been closed for comments

    R
    Rookie

    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

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings