Login to Microsoft SQL Server Error: 18456

sql-server connection error-code
merazuu picture merazuu · Jan 4, 2014 · Viewed 584.7k times · Source

I am getting this error while trying to connect to the SQL Server.

Microsoft SQL Server Error: 18456

Can anybody tell me what the error code means?

Answer

Ali Kashanchi picture Ali Kashanchi · Apr 30, 2014

If you're trying to connect using "SQL Server Authentication" then you may want to modify your server authentication:

Within the Microsoft SQL Server Management Studio in the object explorer:

  1. Right click on the server and click Properties

  2. Go to the Security page

  3. Under Server authentication choose the SQL Server and Windows Authentication mode radio button

  4. Click OK

  5. Restart SQL Services

Related questions

How to determine total number of open/active connections in ms sql server 2005

My PHP/MS Sql Server 2005/win 2003 Application occasionally becomes very unresponsive, the memory/cpu usage does not spike. If i try to open any new connection from sql management studio, then the it just hangs at the open connection dialog …

Read More
How to check for database availability

I have the following code to test DB connection, it runs periodically to test for DB availability: private bool CheckDbConn() { SqlConnection conn = null; bool result = true; try { conn = DBConnection.getNewCon(); ConnectionState conState = conn.State; if (conState == ConnectionState.Closed || conState == ConnectionState.…

Read More
How to connect to mssql using pdo through PHP and Linux?

I'm trying to for a new PDO connection using the following code. new PDO("mssql:driver=????;Server={$serverName};Database={$databaseName}", $username, $password, array(PDO::ATTR_PERSISTENT => false, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)); I'm not sure what drivers …

Read More