Login failed Sql Account sql 2016

After you install Microsoft SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005, or SQL Server 2000 and you try to connect to the server that is running SQL Server, you receive one of the following error messages:

  • Login failed for user ‘%.*ls’. The login is a SQL Server login and cannot be used with Windows Authentication.%.*ls
  • Login failed for user ‘<user_name>’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
  • Login failed for user ‘<user_name>’. (Microsoft SQL Server, Error: 18456)

This problem occurs if the user tries to log in with credentials that cannot be validated. To resolve this issue, configure SQL Server in Mixed Authentication Mode. To do this, follow these steps:

  1. Open SQL Server Management Studio. To do this, click Start, click All Programs, click Microsoft SQL Server 20xx (where xx is the version of SQL), and then click SQL Server Management Studio.
  2. Right-click the server, and then click Properties.

3. On the Security page, under Server authentication, click the SQL Server and Windows Authentication modeoption button, and then click OK.

4. In the SQL Server Management Studio dialog box, click OK to restart SQL Server.

 

Annunci

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione / Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione / Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione / Modifica )

Google+ photo

Stai commentando usando il tuo account Google+. Chiudi sessione / Modifica )

Connessione a %s...