RDP & Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The c

Hot Topic

Suppress Event Errors
help on SELECT
How to use cubes of 2000 in 2005
How to current logged windows user name in tsql
group rpt hdgs not appearing on all pgs
Query the Full-Text Words List?
Data types in SQL Server
Error when browsing data
Table partitioning with multiple key coulmns
Report Builder Filter Prompt...

SQL Server

some guidance for an SSIS newbie wanted
What do I do with SQLDEV.udf
Email Trigger in SQL 2005
Unable to access Report Manager
string to int????
Lookup Transformation with parameter
Refresh of Dataset Takes forever...
Connect to remote analisys services 2000?
Upgrade MSDE with SP3a with SP4
What are the difference between SQL Server 2000 and SQL Server 2005 Express Edition

RDP & Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The c

As a starter i tried to modify and translate the Personal Website Starters kit from the VS2005Team SDK.

When i'm working on the machine were it's installed , under debugging, all works great.

But when i try to develop from my laptop, via RDP on the develop machine, i've got this message and can not debug (connect to the SQLxpres Server)

Does anybody now a solution

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.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: 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.

Source Error: 

Line 5: 	Sub Application_Start(ByVal sender As [Object], ByVal e As EventArgs)
Line 6: 		AddHandler SiteMap.SiteMapResolve, AddressOf Me.AppendQueryString
Line 7: 		If (Roles.RoleExists("Administrators") = False) Then
Line 8: 			Roles.CreateRole("Administrators")
Line 9:    End If


This is the connecting string

<add name="Personal" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient" />

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" />

Answer this question

RDP & Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The c

  • drinkwater

    i've to do that as well. I had planned to set up a system without any monitor and keyboard to save space and work on it via RDP. Now i had to connect all this and i have to go to that machine as well !!

    I heard MS is working on it but we've to wait until a new SP.

    Hopes it comes yesterday!!!

    It works , but not the way i planned

    Good Luck all.

  • Sue_NC

    I don't have a real solution, but I can reproduce the exact problem. I work around it for now by logging on to the machine locally, and then attaching to that session via RDP. Sucks to have to do that, and not always practical.
  • RDP & Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The c
Answer this question