[Microsoft] [ODBC SQL Server Driver] [SQL Server] Login failed for user...

Issue

Web application fails to connect to MS SQL Server 2017 Express with following error:

-2147217843 - [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sql_user'.

Resolution

Issue was resolved by enabling mixed authentication in Microsoft SQL Server Management Studio:

  • Right click on the server in Object Explorer > Properties > Security 
  • Change Server authentication to SQL Server and windows Authentication mode.
    MS SQL Server Properties
  • Restart SQL instance. 

Windows Server 2016
Microsoft SQL 2017 Express Edition

Newsletter

Subscribe to receive occasional updates on new posts.
Your email will not be used for any other purpose and you can unsubscribe at any time.
Please wait