Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error: 17806, Severity: 20, State: 2. Expand / Collapse
Author
Message
Posted Friday, October 1, 2010 5:11 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 16, 2014 2:47 AM
Points: 84, Visits: 458
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....
Post #996539
Posted Sunday, October 3, 2010 10:53 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
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
Post #997352
Posted Monday, June 3, 2013 4:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 10, 2013 3:00 AM
Points: 21, Visits: 3
THanks adiga.

who will do "register an SPN " activity? Is it windows team, right?
Post #1459172
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse