I am trying to create various websites using one database. I am having the following problems:
1. The user guide says nothing about multiple websites that use one database, despite what one of your moderators says on these forums.
2. The lists module items are shared between databases. This, I presume, is due to the fact that a default provider is being used for the lists. However, I can find nothing in the documentation that tells me how to add a provider and give it a distinct applicationName attribute.
[Note: This is the sort of thing that would be nice to have in video documentation.]
3. When I try to add an admin user for a new app, I go to <my project>/sitefinity/cmsstartup.aspx, as recommended by the moderators of this forum. However, this only results in a redirect to the login page, so I can neither login nor add a new user for that application. I have given all the security providers distinct applicationName attributes.
[Note: One thing I could do is: a. login to the default app. b. create a user. c. open the database, and edit the application id for that user. d. Logout, and login to the new application. Would this work?]
4. Is using one database for multiple sites the recommended practice? What is the best use of server resources?