Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 567
  • Last Modified:

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

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
0
Omega002
Asked:
Omega002
  • 2
  • 2
1 Solution
 
SQL_SERVER_DBACommented:
0
 
Omega002Author Commented:
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.
0
 
assystCommented:
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.

 
0
 
Omega002Author Commented:
Make this change on the client network protocol utility for SQL server on my laptop?
0
 
assystCommented:
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.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now