Please Note: This article is part of our historical archive. Because it was published a while ago, some of the information, links, or context may now be outdated.
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.
PREVENT YOUR SERVER FROM CRASHING!
Never again lose customers to poor server speed! Let us help you.
Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.
