cannot generate SSPI context

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » cannot generate SSPI context

cannot generate SSPI context

Rate Topic

Display Mode

Topic Options

Author

Message

joe_kansal

Posted Tuesday, October 30, 2007 7:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, November 10, 2007 4:01 AM
Points: 3, Visits: 14

can anyone help with what causes the following error

Run-time error '-2147467259 (80004005)':

cannot generate SSPI context

it happen when i query the SQL database through an excel macro in a spreadsheet

Thanks

Post #416507

Source-NH

Posted Tuesday, October 30, 2007 8:00 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, December 11, 2012 9:07 AM
Points: 1,619, Visits: 473

SSPI errors are normally caused by authentication issues where the user who is trying to access the database is not a user in the SQL instance. Other cause could be because the user is logged on to the local machine instead of the domain. I would start with these two and then track from there.

HTH

Post #416525

Janet Keith-489067

Posted Tuesday, October 30, 2007 10:21 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 07, 2008 11:53 AM
Points: 46, Visits: 85

In many cases I've been able to resolve this by logging into the SQL Server, opening enterprise manager and ensuring the server is registered using the computer name, NOT (local).

Just delete the registration of local, and readd the server using the name.

I've made this a best practice in the enterprise.

This has to be done on the SERVER hosting SQL Server.

Post #416638

Maverick100877

Posted Tuesday, October 30, 2007 11:06 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, March 25, 2013 3:54 AM
Points: 1,238, Visits: 513

See if this helps

http://support.microsoft.com/kb/811889/en-us

Post #416871

Sugesh Kumar

Posted Friday, November 02, 2007 12:10 AM

Hall of Fame

Group: General Forum Members
Last Login: Saturday, November 10, 2012 8:18 AM
Points: 3,461, Visits: 346

Check for your connection properties.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Post #417766

Guillermo Licon

Posted Wednesday, June 09, 2010 8:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 7:34 AM
Points: 1, Visits: 13

Verify that the dates on the client and the server are valid. If the dates are too far apart, your certificates may be considered invalid.

Post #934648

« Prev Topic | Next Topic »

Permissions