Can someone tell me how to re-create the ASPNETDB database either in SQL Express or SQL Server?

Question

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?

Answer 1

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\

(mouse over the line above, yahoo answers is truncating it, grr).

this folder may change depending on your OS (Winnt/WinXP)

There are .Sql files that will configure your database. one of which, installcommon.sql is the file i believe you're looking for.

Answer 2

the best way is to do this

%SYSTEMROOT%\Microsoft.net\Framework \v2.XXXX\aspnet_regsql.exe

it will launch a wizard to recreat the db also remember that there are stored procedures the must be included in the ASP.NET database that is necessary for the login, personalization and provider functions to work.

your sql database must be mountable via the SQL network service.

- Mike Roth