Microsoft KB Archive/896613

= You cannot connect to Visual Studio SQL Server Express on a remote Windows XP Service Pack 2-based computer =

Article ID: 896613

Article Last Modified on 8/29/2007

-

APPLIES TO

 Microsoft Windows XP Service Pack 2, when used with:  Microsoft Windows XP Professional

 Microsoft Windows XP Home Edition 

-





SYMPTOMS
Consider the following scenario:
 * 1) You have a Microsoft Windows XP Service Pack 2-based computer that is running Microsoft Visual Studio SQL Server Express (SSE).
 * 2) You connect to the computer from another computer by using the Microsoft Terminal Server Client (Mstsc.exe) connection utility.
 * 3) If you run a SQL Server program in a Command Prompt window to connect to SSE, the connection does not succeed.



CAUSE
This problem occurs because the Local Security Authority (LSA) uses the remote session's token for the SQL Server client's session token. The remote session's token is from session 1, and the SQL Server client's session token is from session 0.



Hotfix information
A supported hotfix is now available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next service pack that contains this hotfix.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:

http://go.microsoft.com/?linkid=6294451

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Prerequisites
This hotfix requires Windows XP Service Pack 2 (SP2).

Restart requirement
You must restart the computer after you apply this hotfix.

Hotfix replacement information
This hotfix does not replace any other hotfixes.

File information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel. <pre class="fixed_text">  Date         Time   Version           Size     File name ---  01-Apr-2005  18:39  5.1.2600.2645     423,936  Licdll.dll 01-Apr-2005 18:39  5.1.2600.2645     726,016  Lsasrv.dll 01-Apr-2005 18:19  5.1.2600.2645     502,784  Winlogon.exe

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
For more information about the standard terminology that is used to describe Microsoft software updates, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

Keywords: kbqfe kbhotfixserver kbwinxpsp3fix kbwinxppresp3fix kbfix kbbug KB896613

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.