I've set up a website on another computer using sql server express and visual web developer express, and it works as expected. However halfway through the development i've had to move to another computer. I installed visual web developer express + sql server express, and copied the project files across, but now when I attempt to run it I get the error:
Failed to generate a user instance of SQL Server due to afailure in starting the process for the user instance. The connectionwill be closed.
I've tried reinstalling the software and it doesn't help. Any idea why this is happening, and what I can do to fix it?
thanks
How to fix it is covered in the link below change the configuration. Hope this helps.
http://blog.krisvandermast.com/FailedToGenerateAUserInstanceOfSQLServerDueToAFailureInStartingTheProcessForTheUserInstanceTheConnectionWillBeClosed.aspx
|||Hi,
I changed the built in account to 'local system' in the SQL server configuration manager, and deleted my SQLEXPRESS folder, then restarted the computer, but the same thing is happening. Is there anything else I need to do to fix this?
thanks for your help
|||I am sorry you error sent me on the wrong track because moving a database created in one box and moving it to another is not a simple copying files over. That is the reason the solution I gave you did not fix your problem so delete the folder. When you are moving your database to a new computer you need to do it manually through code like the second link below. You need to check your access permissions to the new computer and follow the guide created by Microsoft in the second link if the forum posting in the first link below did not fix your problem. Hope this helps.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=125227&SiteID=1
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

No comments:
Post a Comment