Can’t log in to SQL Server Management Studio?

0

The following steps apply to the built-in SQL Server administrator account(sa), but with minor adjustments they should work for any account. Successfully tested on MS SQL Server 2008 R2. The same steps should apply both to SQL Server Express instances (SQLEXPRESS) and to instances of the “full” MS SQL (MSSQLSERVER)

Steps:

  1. Log in to SQL Server Management Studio using Windows Authentication:

    sql server login dialog
  2. Change the password of the sa user if you need to:


    sql server login properties sa

  3. Enable login for the sa account

    sql server login properties sa grant access
  4. Allow login using both Windows Authentication and SQL Server authentication

    sql server server properties
  5. Open SQL Server Configuration Manager and restart all running services, the main one being, of course, SQL Server:

    Sql Server Configuration Manager Services

From then on I was able to log in as the sa user, and hopefully you will be too. I hope this helps someone :-).

Categories

Leave a Reply