Posted by John Bell on 02/05/06 15:48

Hi

Check out the previous posts and links from http://tinyurl.com/c72g2

John

<anonieko@hotmail.com> wrote in message
news:1139144880.539193.116260@f14g2000cwb.googlegroups.com...
> Problem
>
> When Remote Desktop to my main office machine, and when trying to
> connect to SQL Express, I was becoming increasingly frustrated with the
> following error:
>
> Error: 'Failed to generate a user instance of SQL Server due to a
> failure in starting the process for the user instance. The connection
> will be closed.'
>
> What is the solution?
>
>
> Solutions: ( pick any of the 3)
>
>
> 1. Obtain and apply the patch http://support.microsoft.com/?id=896613
>
> 2. Wait for the next Windows Service pack
>
> 3.
>
> Of course if you can not get the patch, you can always do this (Note:
> You must have WinVnc server running in your remote computer)
>
>
> 1. In the remote desktop session, reboot your computer.
> Click Start->Windows Security->Shutdown->Restart.
>
> Wait for some time to get machine up.
>
> 2. Use your vncviewer to login to your remote computer. You can choose
> to do all work via VNC or go to next step.
>
> 3. Use remote desktop to login (this automatically closes the winvnc
> session).
>
>
> There you go, You did not create a remote session, but reused your
> local session.
>

[Back to original message]