Troubleshooting MS SQL login failure

Troubleshooting MS SQL login failure

Problem: 
The following error message appears in MS SQL monitor during login:
"Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication" 

Solution:
  1. Verify if the password of the SQL account (domain\username) is correct:
    To check the same, connect the SQL Server to any one of the query tools (SSMS/DB visualizer with MS JDBC) with the same user account. If you're able to connect, the password is correct.
  2.  Add the user account to "Access this computer from the network" local security policy. (Refer this link for more details)
  3.  If the SQL account is the same as its service account, then the password may not have be updated at SQL service. If you recently changed the windows authentication password, then you need to update it at the service level as well.
    Steps:
                  1. Open SQL Server Configuration Manager.
                  2. Click SQL Server Services.
                  3. In the details pane, right-click SQL Server (<instance name>), and then click Properties.
                  4. In the SQL Server (<instance name>) Properties dialog box, on the Log On tab, for the account listed in the Account Name box, type the new password in the Password and Confirm Password boxes, and then click OK. (For more details, click here)

If you have verified and executed the above steps and still unable to login to MSSQL, kindly send the following to AppManager Support team:
  1. MsSQLDebug Result (For more information, click here)
  2. Screenshot of successful connection made in db query tool(SSMS/Dbvisulazer)
  3. Screenshot of access provided. (From Step 2)
  4. SIF

          • Related Articles

          • Problem occurs while adding MS SQL Monitor.

            Solution: Check if hostname/IP address is resolving correctly from Applications Manager machine.  Check if port is able to telnet from Applications Manager machine. If instance name is provided, check the UDP port(Default: 1434) is reachable. Check ...
          • How to enable Kerberos Authentication for Applications Manager's MS SQL backend database?

            Follow the steps given below to enable Kerberos authentication for MS SQL backend database: 1. Stop Applications Manager service. Open Applications Manager Home directory in command prompt and run the below commands one by one.             For ...
          • Azure SQL Database - Troubleshooting - Add client IP to Azure firewall

            "Connection to the database failed with error : Cannot open server <ServerName> requested by the login. Client with IP address <SomeIP> is not allowed to access the server.  To enable access, use the Windows Azure Management Portal or run ...
          • Real User Monitor (RUM) - Troubleshooting

            If the monitor has not polled data for long time. Follow below steps for troubleshooting Check prerequisites to done : Real User Monitor requires RUM Agent to be installed and mapped to Applications Manager. Refer the help page to know how to setup ...
          • How is Backup Age calculated for MS SQL DB monitor?

            Backup Age displays the number of hours passed since the backup operation was completed. In simple terms, it is the difference between the current time and the time at which backup was performed. Backup Age (hours) = Current Time - Backup Time By ...