Connection Error

  • I am running SQL 2K on Win 2K Advanced server and run the Enterprise Manager on an XP Pro workstation. I am receiving the following error everytime that I try to register the server.

    --

    SQL Server Registration failed

    Can not generate SSPI context

    --

    What is the meaning behind this error and how do I resolve it?

    Thanks,

    Wills

  • Hi,

    SSPI stands for Security Support Provider Interface. When you connect to SQL Server using NT authentication this interface is used. From time to time I also get this error, but it happens only once. Second start of EM is normal. Maybe you should take a look at MSDN

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Please read this KB article.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;811889

  • quote:


    I am running SQL 2K on Win 2K Advanced server and run the Enterprise Manager on an XP Pro workstation. I am receiving the following error everytime that I try to register the server.

    --

    SQL Server Registration failed

    Can not generate SSPI context

    --

    What is the meaning behind this error and how do I resolve it?

    Thanks,

    Wills


Viewing 4 posts - 1 through 3 (of 3 total)

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