ASP.NET Membership Roles

August 27, 2007

I was getting bored lately since there is no office for three straight days. So I decided to develop an Art Gallery Acquisition System. This system is a web-based asset management systems specifically designed for Art Galleries. My group mate and I had already developed this kind of system way back in 3rd year college. It was, however, a window based application; and very simple.

I started it by creating the ASP.NET Users and Roles. At first, I was thinking that if I modify the web.config with the Enterprise Library Configuration, and point the connection string to the database I created, it is all done. Well, it was not. I have to do some tweaks, and this is how I do it:

1. Run aspnet_regsql.exe. Point the database to your defined database.
2. Modify the connectionstring under configuration of the web config as follows
• Remove LocalSqlServer as <remove name="LocalSqlServer" />
• Re-add LocalSqlServer with the connection string pointing to your intended database.

And, all the users that I am creating are saved in my database.