July 6, 2011 at 6:17 am
Dear All,
Iam facing the below login failed errors.
SQLServer 2008 - RTM - Enterprise Edition
Windows Server 2008 - 64 bit O/s
Message
Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: xxxxxx]
Error: 18456, Severity: 14, State: 38.
Login failed for user 'xxxxxxxx'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: xxxxxxxx]
Error: 18456, Severity: 14, State: 11.
Please advise.
Thanks and Regards,
Ravi.
July 6, 2011 at 7:02 am
Try login into the ssms using admin account (admin:instance name ) while connecting to the database engine ..It may help ....\m/
July 6, 2011 at 8:19 am
Dear All,
Iam facing the below login failed errors.
SQLServer 2008 - RTM - Enterprise Edition
Windows Server 2008 - 64 bit O/s
Message
Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: xxxxxx]
Error: 18456, Severity: 14, State: 38.
Login failed for user 'xxxxxxxx'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: xxxxxxxx]
Error: 18456, Severity: 14, State: 11.
Please advise.
Thanks and Regards,
Ravi.
This usally is refering to the login not having proper access. See this article about the failure:
http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply