You are here: Re: How to go around the SQL Server 2005 User Instance problem when using Remote Desktop « MsSQL Server « IT news, forums, messages
Re: How to go around the SQL Server 2005 User Instance problem when using Remote Desktop

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация