29 Aug 2012
12 Sep 2012
Link to this post
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.
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.