Failed to generate a user instance of SQL Server due to a fa

Posted by Community Admin on 04-Aug-2018 14:37

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.

All Replies

Posted by Community Admin on 12-Sep-2012 00:00

Hi,
My local Sitefinity website has stopped working.  This is the error I am getting when I launch the 'Sitefinity Project Manager':

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.

I am not sure what happened, everything has been working fine.  The only thing I did was to restart my computer.  I am guessing, maybe a windows update messed things up.

I ran this query in SQL Sever Management Studio:

exec sp_configure 'user instances enabled', 1.
Go
Reconfigure


and then restarted the SQL server and then found this folder and deleted it:
C:\Users\User Name\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

(by the way, after deleting this folder, each time I attempt to run Sitefinity Project Manager, the error pops up and this folder gets generated again on this path with four files in it: master.mdf, mastlog.ldf, msdbdata.mdf and msdblog.ldf)

And yet still I get the error message and no success.

I thought maybe my connection strings have been changed by windows update, but when I open my DataConfig.config file, I am not sure what has been changed here.

Can anyone shed a light on this?  This is getting frustrating.

Thanks,
Marz

Posted by Community Admin on 17-Sep-2012 00:00

Hi,

You can try the following: Open up the IIS Manager, select the Application Pool that corresponds to your site, and click "Advanced Settings" from the Actions menu on the right (or from the right-click menu).  Under Process Model change the setting for "Load User Profile" to True, then click OK and restart your website. After doing this you should be able to access your site normally.

Regards,
Atanas Valchev
the Telerik team
Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

This thread is closed