Last post Aug 28, 2008 08:17 AM by JeffH
Aug 27, 2008 01:18 PM|JeffH|LINK
I've been using VWD 2005 with SQL Server Express 2005 for a long time with great results. Two days ago I upgraded to VWD 2008 SP1 and SQL Server Express 2008. Now whenever I try to use the VWD database explorer I get the following error:
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.
My various web applications run fine, but I'm not able to view/modify the databases in VWD.
Aug 27, 2008 10:54 PM|HypAJace|LINK
I would guess that you need to enable user instances just like with 2005.
Run this in the management console:
sp_configure 'user instances enabled', 1
Hope that helps!
Aug 28, 2008 08:17 AM|JeffH|LINK
I decided to do a complete remove/reload/clean out of VWD and SQL Express last night. If the problem pops up I'll give it a try.