Try It Out section never work right on me. I am able to set up WroxUnited site and see it at http://localhost/wroxunited/default.aspx
. However when I open a site, let say C:\BeginningASPNET20\Begin\Chapter03\WroxUnited in VWD I always got the error below.
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. [CLIENT: <local machine>]
I logged in as local admin. That is same and only user acct I use on this machine. I did delete SQLEXPRESS folder in C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\ and reboot but it is recreated later. However in VWD, when I open Data Connections in Solution Explorer if I change User Instance to False then I can connect to the database. But that's it. After I changed User Instance to False, save All, and choose to Build Web Site Again I still got the same error. Toggling b/w False and True for User Instance doesn't help. I use SSEUTIL -L, it shows same error.
What should I do now? Thx.