I have Visual Web Developer and I’m developing remotely to a third-party web host. I’ve set up the standard ASP.NET 2.0 Login and CreateUser pages. They were working before with a SQL Express copy of aspnetdb. I don’t know how aspnetdb got set up; I think my web host helped me put the database out there.
Today I came back from vacation and the log in was crashing with a DB error. I didn’t save the error, so I can’t tell you what it was. Then I deleted the aspnetdb file from the App_Data folder thinking it would be re-created when I created a new user. That didn’t happen and now I don’t know how to get the aspnetdb created again.
I can’t find where MSDN discusses this at all. Can someone please give me a link to that info and maybe I could figure this out myself? If not, can some tell me how to re-create the aspnetdb database either in SQL Express or SQL Server?