I want to add a second web application to our server.
The existing one (ISSVIP) is using a sqlmembership provider, i can see it in my Sql Server management studio, the db is called aspnetdb.
I can see inside the db, in the aspnet_Applications table, there is one row as follows:
ApplicationName = /
LoweredApplicationName = /
ApplicationID = some gibberish text, presuming the id of this particular app
Description = ISSVIP
I tried adding another web app (ROVA) to IIS, and the Default page loads fine.
The problem starts when i try to add users to this new application. When i run the ASP.Net configuration tool, it tells me that I already have users and roles defined in the system. It's taking the list of users and roles from the first app, ISSVIP.
How do i separate these app while still using the same provider? inside the aspnet_Applications table i still see only 1 application.
i tried changing the following, but the first app stopped working when i made these changes..
1) i edited the applicationName property of <membership><profile> to \ISSVIP
2) i edited the value of ApplicationName inside aspnet_Applications to \ISSVIP
any help is appreciated.