We recently implemented a new SBS 2008 server for one of our clients.  A user was going to be working from home and wanted to utilize thier corporate office desktop to get some tasks done.  They were able to authenticate to the Remote Web Workplace webpage successfully,  but were unable to connect to their Windows 7 desktop computer.  Every time they attempted to do so, their account was rejected with an error message: “The logon attempt failed”

I discovered the problem was due to an incorrect setting within IIS.

Here’s what I did to correct the problem:
I went to IIS Manager → Sites → SBS Web Applications → Rpc → Authentication.  There I found only “Basic Authentication” was enabled.

Enabled “Windows Authentication” then ran an IIS reset. When IIS came back online, I was able to connect via TS Gateway to the server and at least one workstation. I connected and disconnected multiple times and it had no problems. The end user verified they were also able to authenticate without error, and gained remote control of their Windows 7 computer.

When running WSUS on a Small Business Server, the default location is the C:\ drive, when that drive gets full you need to move the content and the SQL database. Below are the steps to move the SQL database to another location.

1. Open command prompt and type: net stop “update services”

2. Next, at the command promt type: net stop w3svc (if it is SBS 2008 it will also stop the Terminal Services Gateway, remember to restart)

3. Open Microsoft SQL Express Management Studio (if you don’t have this, go to http://tinyurl.com/ynl9tv to download) and connect to the MICROSOFT##SSEE database, which is the WSUS database and the SharePoint databases in SBS 2008. You can’t just connect to the database normally, you need to type this in server name area:   \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

 4. Detach the SUSDB database, move the SUSDB folder to the new location and attach the database again with Management Studio

5. Restart the services: “update services”, “w3svc”, and “Terminal Services Gateway”