Invalid SQL: REPLACE INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('ftt1bshu1gp79t9hsnvt3u1k5gb4vut1', '54.198.224.121', '1398374225', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '0', '40', '0', '1398374225', '0'); (The table 'swsessions' is full) Enabling Network Level Authentication on Windows XP Service Pack 3 for access to Server 2008 via Remote Desktop - Kayako SupportSuite Help Desk Software
24 Apr 2014 
Support Center » Knowledgebase » Enabling Network Level Authentication on Windows XP Service Pack 3 for access to Server 2008 via Remote Desktop
 Enabling Network Level Authentication on Windows XP Service Pack 3 for access to Server 2008 via Remote Desktop
Solution When connecting to a Windows 2008 Server using remote desktop from a Windows XP client running service pack 2 or earlier, you get the following error message:

The remote computer requires Network Level Authentication, which your computer does not support.

To enable NLA in XP machines; first install XP SP3, then edit the registry settings on the XP client machine to allow NLA

• Configure Network Level Authentication

1. Click Start, click Run, type regedit, and then press ENTER.
2. In the navigation pane, locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
3. In the details pane, right-click Security Packages, and then click Modify.
4. In the Value data box, type tspkg. Leave any data that is specific to other SSPs, and then click OK.
5. In the navigation pane, locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders
6. In the details pane, right-click SecurityProviders, and then click Modify.
7. In the Value data box, type credssp.dll. Leave any data that is specific to other SSPs, and then click OK.
8. Exit Registry Editor.
9. Restart the computer.


Article Details
Article ID: 221
Created On: 14 Nov 2008 08:25 PM

 This answer was helpful  This answer was not helpful

Posted By: Kahlen J On: 13 Jan 2010 02:02 PM
Very good!!! This work for me also!!! XP sp3 connecting to a RDP Server running Windows 7 Pro.
Posted By: Deepak On: 28 Feb 2010 06:29 AM
Very good. Thanks for sharing.
Posted By: Glenn H (glennjh66@gmail.com) On: 23 Nov 2009 03:07 PM
Thanks! That did the trick!
Posted By: Et On: 29 Dec 2009 01:20 PM
Just added the specified info to the keys listed above, Worked like a charm.
Posted By: Jay On: 29 Apr 2010 09:23 AM
Didn't work on XP x64.
Posted By: Jeff On: 06 Mar 2010 07:11 PM
Thanks...worked like a champ! Success with RDP between Windows XP SP3 and Windows 7 locally and via Internet.
Posted By: Syed Shomaail Mansoor Jafri On: 20 Apr 2010 02:18 AM
Excellent and precise solution!! Thanx . I wonder why the microsoft updates doeas not itself fix this problem.
Posted By: Richard On: 01 Jun 2010 03:14 PM
I noticed this only works with the hostname. I get a different error if I try by IP
Posted By: eduarda On: 27 Jul 2010 02:45 AM
Thx a lot, the trick really helped me out !!
Posted By: On: 31 Aug 2010 12:39 PM
Great job! Thanks!
Posted By: Jason (j316173@hotmail.com) On: 05 Sep 2010 10:59 AM
Thank you very much for sharing this! Very helpful. Would have never figured out how to resolve this MS oversight on my own.
Posted By: Bill Fink On: 15 Sep 2010 01:48 PM
I've been trying to get some closure on this problem for over 2 weeks, now.

WOW! Thanks! Perfect! It worked! (What else can I say.)
Posted By: Johnny5 (johnny5) On: 02 Oct 2010 10:26 PM
Yes! It worked! Thank you:)
Posted By: Trilok Mohnani (trilokmohnani@gmail.com) On: 11 Oct 2010 03:58 AM
Thankx Remote desktop tool now says NLA enabled but now when i COnnect to Server It gives me an error.

An authentication error has occured, The specified target is unknown or unreachable.

Thanks in advance
Posted By: William On: 27 Oct 2010 01:31 PM
Thanks! It worked for me on xpsp3 to 2008 server as soon as I closed regedit, I didn't even have to restart the computer.
Posted By: jOEY On: 07 Nov 2010 03:20 AM
Wow ....FANTASTIC
Posted By: Davinder On: 12 Nov 2010 01:40 AM
Fantastic :) It was really helpful.
Posted By: Kerry J On: 19 Nov 2010 06:34 AM
Thanks a million, made my life so much easier, this solution will be saved for the future :)
 Back
 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
Home | Register | Submit a Ticket | Knowledgebase | Troubleshooter | News | Downloads
Language:

Help Desk Software For Sound Enterprises