Cannot create SSPI context
It's quite a common error with a variety of causes: start here with KB 811889
- What version of SQL Server?
- And Windows on client and server?
- Local or network SQL instance?
- Domain or workgroup? Provider?
- Changing password
- Local windows log errors?
- Any other apps affected?
SQL server 2005 Connection Error: Cannot generate SSPI context
This MSDN blog page has some useful on this...
http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx
Related Topics
How to Upsert Multiple Rows with Individual Values in One Statement
Inserting Data into a Temporary Table
Remove Trailing Spaces and Update in Columns in SQL Server
How to Specify "Close Existing Connections" in SQL Script
Fastest "Get Duplicates" SQL Script
Pass Multiple Sets or Arrays of Values to a Function
How to Determine Which Columns Are Shared Between Two Tables
Identify a 3-Column Pk Duplicate in Vba Access
How to Import a SQL File into a Rails Database
Full-Text Search SQL Server 2005
Set Identity_Insert Off for All Tables
Count Case and When Statement in MySQL
Find Duplicate Entries in a Column