Cannot login after creating the user in SQL Server

by

SQL Server was not configured to allow mixed authentication. Here are steps to fix:

  1. Right-click on SQL Server instance at root of Object Explorer,
  2. click on Properties.
  3. Select Security from the left pane.
  4. Select the SQL Server and Windows Authentication mode radio button, and
  5. click OK.
  6. Open up Services and restart the SQL Service (SQLEXPRESS) Windows service.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)