Thursday, May 17, 2007

ASPNETDB Database in ASP.NET

The membership database ASPNETDB is automatically created under APP_Data folder when we set the Connection string for the Membership Provider in the web.config to be "LocalSqlServer" and run that web project the first time. We may see the contents of this database by attaching the created database to your local instance of SQLExpress and using Management Studio.

Alternately, we may run the aspnet_regsql.exe tool from Visual Studio 2005 prompt and it will step us through creating a new membership database on the server (SQL Server 2005 or SQL Express) wherever we ask it to in the wizard. We ofcourse would have to create a new connection string(that looks at this database) and point the membership provider to look at this new connection string in the web.config file of the respective project.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.