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

cannot generate SSPI context Expand / Collapse
Author
Message
Posted Tuesday, October 30, 2007 7:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, October 30, 2007 8:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:16 AM
Points: 1,626, Visits: 478
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
Posted Tuesday, October 30, 2007 10:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 7, 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
Posted Tuesday, October 30, 2007 11:06 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 11, 2013 3:40 AM
Points: 1,256, Visits: 529
See if this helps

http://support.microsoft.com/kb/811889/en-us
Post #416871
Posted Friday, November 2, 2007 12:10 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:39 AM
Points: 3,461, Visits: 350
Check for your connection properties.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Post #417766
Posted Wednesday, June 9, 2010 8:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 9, 2014 2:13 PM
Points: 1, Visits: 19
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 »

Add to briefcase

Permissions Expand / Collapse