I built my websites using this book. I have new computer and installed VS 2008, copied my programs (websites) and installed SQL 2008 Express R2.
I get errors when I try to run in ASP.net (or click ctrl F5) It also won't use my database. I see my databases in the server explorer window but when I click refresh, I get message:
"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."
When I connect to the existing database, it adds the full path and then adds "
.dbo" extension to end of database name. But even then, it will not run in the web browser local copy window when I click CTRL F5. At that point, I get
error message:
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.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: 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.
Source Error:
Line 5: void Application_Start(object sender, EventArgs e) {
Line 6: SiteMap.SiteMapResolve += new SiteMapResolveEventHandler(AppendQueryString);
Line 7: if (!Roles.RoleExists("Administrators")) Roles.CreateRole("Administrators");
Line 8: if (!Roles.RoleExists("Friends")) Roles.CreateRole("Friends");
Line 9: }
(Old computer was XP, new computer Window 7 Professional, 64 bit)
Please help!
copying to new computer
button below this post to show your appreciation!
