Yes, I've actually tried that but I get this error (I have the "SiteSqlServer" and my other conn string both pointing to my .NET Membership Users database, though I guess only one would suffice if I understand correctly) when installing:
0:05 Minutes | 23% ERROR occured - System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'vw_Users' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception...
And so the stack trace goes on.
Just to make sure I have this correct: Set "InstallMemberRole" to "False", set the "AspNetSqlMembershipProvider" to use my .NET Users database, and set the "SqlDataProvider" to use my .NET Users database. Then browse to the DNN site and run the install. For the Database Configuration before the install, I also entered my Users database.
I believe I have found a way to use my Users database and have DNN use it's own database. I just need to populate the "Users", "UserRoles", and "UserPortals" tables in the DNN database with relevant info from my Users database. I made a simple script to insert the necessary rows in the DNN db for a single user from my Users db and it worked perfectly. Of course the "Authorised" bit must be "True" in "UserPortals" table as well. Any new users that register should work fine, as I mentioned in my original post.
I'd rather not have to mess with SQL, but that is my only option so far, if I want to accomplish my goal.
Thanks much for the help! Any thoughts?