<div>
there is a KB on this one.<br />
<br />
<a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;811889" rel="ugc">http://support.microsoft.com/default.aspx?scid=kb;en-us;811889</a>
</div>


there is a KB on this one.

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

<div>
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.
</div>


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.

<div>
Try the following<br />
&nbsp; Make sure that the Shared Memory protocol is enabled.<br />
&nbsp; On the Client Protocols change the protocol order list to have the Shared Memory as first in the order.<br />
<br />
&nbsp; 
</div>


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.

 

<div>
Make this change on the client network protocol utility for SQL server on my laptop?
</div>


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

<div>
<div class="content wysiwyg-content">
ISSUE: Unable to connect to a SQL Server DB server from home <br />
<br />
when running SQL Query Analyzer, I &nbsp;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. <br />
<br />
Workstation OS: XP Professional installed on laptop<br />
SQL Server 2000 Client installed on laptop<br />

</div>
</div>


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


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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Windows XP is the sixth release of the NT series of operating systems, and was the first to be marketed in a variety of editions: XP Home and XP Professional, designed for business and power users. The advanced features in XP Professional are generally disabled in Home Edition, but are there and can be activated. There were two 64-bit editions, an embedded edition and a tablet edition.