+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / 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.

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.

2 posts, 0 answered
  1. Marz
    Marz avatar
    7 posts
    Registered:
    29 Aug 2012
    12 Sep 2012
    Link to this post
    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
  2. Atanas Valchev
    Atanas Valchev avatar
    414 posts
    Registered:
    04 Jan 2016
    17 Sep 2012
    Link to this post
    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
2 posts, 0 answered