Unable to connect - cannot generate SSP1 context' error message. When using Query Analyzer From Home

Posted on 2007-10-10
Last Modified: 2008-01-09
ISSUE: Unable to connect to a SQL Server DB server from home

when running SQL Query Analyzer, I  logged with my network login from home (as I am able to do in the office), I get 'Unable to connect - cannot generate SSP1 context' error message. Everything works fine when I am in my office but from home I get this error. Please advise.

Workstation OS: XP Professional installed on laptop
SQL Server 2000 Client installed on laptop
Question by:Omega002
    LVL 16

    Expert Comment


    Author Comment

    The link seems to discuss more setting on the server end rather than the client end. Everything works fine when I'm at work but it gives me the areas I mentioned in the first post once I attention.
    LVL 7

    Expert Comment

    Try the following
      Make sure that the Shared Memory protocol is enabled.
      On the Client Protocols change the protocol order list to have the Shared Memory as first in the order.


    Author Comment

    Make this change on the client network protocol utility for SQL server on my laptop?
    LVL 7

    Accepted Solution

    On the Server network utility in Server enable Shared Memory or/and Named Pipe.

     And on your laptop go to client network utility and enable Shared Memory or/and Named Pipe  and bring it on top of the order using the arrow button so that it becomes the first preference.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    It is only natural that we all want our PCs to be in good working order, improved system performance, so that is exactly how programs are advertised to entice. They say things like:            •      PC crashes? Get registry cleaner to repair it!    …
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now