{"id":107890,"date":"2022-09-27T12:17:53","date_gmt":"2022-09-27T12:17:53","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=107890"},"modified":"2024-10-01T05:07:08","modified_gmt":"2024-10-01T05:07:08","slug":"how-to-fix-sql-server-database-error-18456","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-database-error-18456\/","title":{"rendered":"How to Fix SQL Server Database Error 18456?"},"content":{"rendered":"

When trying to connect to the SQL Server, you may encounter the SQL Server database error 18456. The complete error message reads as follows.<\/p>

\"Login failed for user 'Username'. (.Net SqlClient Data Provider)\"\n\"Server Name: yourServer\"\n\"Error Number: 18456\"\n\"Severity: 14\"\n\"State: 1\"\n\"Line Number: 65536\"\n<\/code><\/pre>
In the above message, “State 1” means that you cannot see more details about the error due to permission restrictions. “Severity 14” is associated with security errors, like permissions.<\/p>
Causes behind the SQL Server Database Error 18456<\/strong><\/h2>
This error usually occurs when you try to log in to SQL Server with SQL Server Management Studio (SSMS) or another tool and the login fails. The most common reasons behind this problem are:<\/p>
    \n
  1. The login is wrong.<\/li>\n\n\n\n
  2. The password is wrong.<\/li>\n\n\n\n
  3. SQL Authentication is not enabled.<\/li>\n<\/ol>
    Solutions to Resolve the SQL Server Database Error 18456<\/strong><\/h2>
    Here are some solutions to fix the error 18456 in SQL Server<\/p>
    Verify the Login<\/strong><\/h3>
    To check if the login is correct, type the login name again correctly and make sure there are no special characters.<\/p>
    To verify that the login is correct, go to Security > Logins<\/strong> in SSMS and verify that your login name exists.<\/p>
    \"\"<\/figure>
    If you cannot see the login, ask the database administrator for help. Another way to verify the login is using the following query:<\/p>
    select name from sys.syslogins<\/code><\/pre>
    Alternatively, you can use the stored procedure<\/p>
    sp_helplogins<\/code><\/pre>
    If you need to modify the existing login name in SSMS, right-click the login and select Rename.<\/p>
    \"\"
    How to fix SQL Server Database Error 18456?<\/figcaption><\/figure>
    Alternatively, you can change the login using the ALTER LOGIN statements.<\/p>
    ALTER LOGIN User1 WITH NAME = tester;<\/code><\/pre>
    The above statement will change the login name ‘User1’ to tester.<\/p>
    If you have a Windows login and not a SQL Server login, you need to coordinate with the system administrator to modify the Windows Account.<\/p>
    SSMS can detect the current Windows user automatically. However, other tools may require you to enter the login manually. If that is the scenario, there are chances that you can write an incorrect login. Make sure to check that the domain is correct and the user name is correct.<\/p>
    If you are not sure about your login name, you can go to the command-line tool and write whoami and the command prompt will return your Windows login. <\/p>
    Check the Password to fix SQL Server Database Error 18456.<\/strong><\/h3>
    If you’ve entered a wrong password, you only need to enter it again correctly. If not, you will need to coordinate with the system administrator to modify the password if you do not have enough privileges. <\/p>
    If it is a SQL Server login, you can modify the password by right-clicking the login and selecting properties.<\/p>
    \"\"
    Check password to Fix SQL Server Database Error 18456<\/figcaption><\/figure>
    In the General page, you can modify the password.<\/p>
    \"\"
    SQL Server Error 18456<\/figcaption><\/figure>
    If your login is an Active Directory account, you need to contact the system administrator in charge of the Active Directory accounts.<\/p>
    Another way to change the SQL Server login password is using the T-SQL. The following code illustrates how to do it.<\/p>
    ALTER LOGIN testuser WITH PASSWORD = 'Write$#”paSsw23”ord';<\/code><\/pre>
    \n
    Note<\/strong>: If you need to recover and reset multiple passwords in SQL Server, you can use Stellar Password Recovery for MS SQL which is a tool included in Stellar Repair for MS SQL Technician<\/em><\/p>\n<\/blockquote>
    \"\"
    Stellar Repair for MS SQL <\/figcaption><\/figure>
    Enable SQL Authentication<\/strong><\/h3>
    By default, SQL Server is installed with Windows Authentication only. This means that you can only log in with Windows users. However, there is an option to create SQL Server database logins. If this option is not enabled, you may receive the 18456 error.<\/p>
    The following steps show you how to enable SQL and Windows Authentication.<\/p>