SQL Server Network Interfaces: The logon attempt failed

SQL Server Network Interfaces: The logon attempt failed error can be fixed with a little help from our experts. 

At Bobcares, we offer solutions for every query, big and small, as a part of our SQL Server Support.

Let’s take a look at how our SQL Server Support Team is ready to help customers resolve the “logon attempt failed” error.

Resolved: SQL Server Network Interfaces: The logon attempt failed

If you have been coming across an error message similar to the one below while trying to connect to the server, you have come to the right place.

OLE DB provider "SQLNCLI11" for linked server "LinkedServerName" returned message "Cannot generate SSPI context". Msg -2146893044, Level 16, State 1, Line 0 SQL Server Network Interfaces: The logon attempt failed

According to our SQL Server experts, try the following troubleshooting tips:

 

• Verify the server name and instance selected and configured are accurate
• Check the user account has appropriate permissions in the instance and database
• Verify Windows firewall is OFF on both the SQL Server and the remote server
• Ensure the server is pingable
• Check if we can telnet to the port without error

If the SQL Server logon attempt failed error still occurs, it is time to check whether the correct Service account is in use. We can use the user’s own id to narrow down the issue at the authentication level.

In order to change Computer Account objects on the OU, we have to be a Domain Administrator or have the right permission. Then, we can run SETSPN as seen below:

setspn -A MSSQLSvc/host.domain.tld:1433 domain\accountname

After configuring SPN for a service account, we can restart the server and access the database without running into the SQL Server Network Interfaces: The logon attempt failed error.

Alternatively, we can do the same thing automatically via the Active Directory.

[Need assistance with another query? We are available 24/7.]

Conclusion

In a nutshell, our skilled SQL Server Support Engineers at Bobcares demonstrated how to resolve SQL Server logon attempt failed error.