October 1, 2010 at 5:11 am
Hi
I got this error .Please help me to solve this.
Error: 17806, Severity: 20, State: 2.
SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection has been closed.
After this i got again another error...
Error: 18452, Severity: 14, State: 1.
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
we are using sql server 2005,standard eddition.
Thanks in Advance....
October 3, 2010 at 10:53 pm
The first error code indicates that SQL Server is unable to authenticate with the Active Directory. Check if the SPN is created properly. Refer this
Are you able to connect using SQL Server authentication?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
June 3, 2013 at 4:29 am
THanks adiga.
who will do "register an SPN " activity? Is it windows team, right?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply