Troubleshooting MS SQL login failure

Troubleshooting MS SQL login failure

Alert
Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Follow the steps given below the resolve this error.

1. Verify Credentials

  • Ensure that the username and password of the SQL account (domain\username) are correct.

  • Check if the user account is locked or disabled.

  • Try connecting to the SQL Server using a query tool like SQL Server Management Studio (SSMS) or DB Visualizer (with MS JDBC driver) using the same account.

Notes
If the connection is successful, the credentials are valid.

2. Check Local Security Policy

  • Ensure the user account is added to the "Access this computer from the network" policy.

NotesRefer to this page for more details.

3. Update SQL Service Account (if required)

If the SQL account is also used as the SQL Server service account, and you've recently changed its password, make sure the updated password is reflected in the service configuration:

  1. Open SQL Server Configuration Manager.
  2. Click on SQL Server Services.
  3. In the right pane, right-click on SQL Server (<instance name>) and select Properties.
  4. Under the Log On tab, enter the new password in both the Password and Confirm Password fields.
  5. Select OK to apply the changes. 
NotesNote: Click here for more details.

4. Check for NTLM Restrictions

On the database server, check if NTLM authentication is restricted:

  1. Navigate to Computer Configuration → Windows Settings → Security Settings → Local Policies → Security Options
  2. Look for the NTLM-related settings.
  3. If NTLM is restricted, remove the restriction or configure it to allow Windows authentication.
NotesStill facing issues?
If you've followed the above steps and are still unable to log in to MSSQL, please send the following details to the Applications Manager Support Team:
  1. MsSQLDebug result – Click here for instructions.
  2. Screenshot of successful login using a query tool (SSMS/DBVisualizer).
  3. Screenshot showing user access from Step 2.
  4. SIF (Support Information File).

                  New to ADSelfService Plus?