We help IT Professionals succeed at work.

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

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
Watch Question


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.

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.



Make this change on the client network protocol utility for SQL server on my laptop?
Unlock this solution and get a sample of our free trial.
(No credit card required)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.