I have a windows application and a web site app that will use the same database so I combined the aspnetdb.mdf with the data db. The windows app creates the db(for deployment or in case it gets corrupted and needs to be deleted and replaced) so there is no web.config file initially. The db is created in the App_Data directory, used aspnet_regsql.exe to add aspnetdb functions and creates users with Membership.CreateUser and this all works fine.
The problem is I want to add 2 roles to the database - user and admin. When I use Roles.CreateRole I get a "role already exists" error, but the roles don't show up in the database.
If I change the role name it will create it the first time but then the second time I get the "already exists" error. But neither time does it get added to the database I want, but obviously it's adding it somewhere else.
Any ideas for a newbie?