Post reply

cannot generate SSPI context

  • October 30, 2007 at 7:36 am

    #183301

    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

  • October 30, 2007 at 8:00 am

    #746648

    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

  • October 30, 2007 at 10:21 am

    #746740

    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.

  • October 30, 2007 at 11:06 pm

    #746914

    See if this helps

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

  • November 2, 2007 at 12:10 am

    #747624

    Check for your connection properties.

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

  • June 9, 2010 at 8:47 am

    #1178004

    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.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply