We are receiving this error for a particular login on one server. SQL 2008 Enterprise
The default db is set to master, but it doesn't have rights to master.
I ran a trace and see that it's trying to access the Master db.
We have this login on other server with the same setup, but they aren't having issues.
Please make sure that the SQL Server service is running, the login is existed on the SQL Server instance. If the SQL Server service is enabled and the login is the SQL Server service account with sysadmin fixed role, you may try to apply the Service Pack 3 for SQL Server 2008 instance. Please have a look at this site on Microsoft Connect: Sever Login failure storm for SQL Server 2008 x64 SQL Service account
For troubleshooting this issue, please pay attention to the blog below:
Troubleshoot Connectivity/Login failures (18456 State x) with SQL Server
If you have feedback for TechNet Subscriber Support, contact firstname.lastname@example.org.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.