(ASP.NET 2.0) CreateUserWizard and ISP Woes

[rjbudz]

Hi,

I'm setting up a website. I want to use the Login control and CreateUserWizard control. Being pretty new to ASP in general, the controls appear to be a Godsend.

So using VS 2005 I create the pages, set up both controls the way I want them, test the app. Everything works fine. No problem.

I upload it to my Web Host. Problem.

My Web Host won't allow me to create the SQL Server 2005 database that the CreateUserWizard wants to make. They say "...we don''t give clients access to create databases on the SQL servers at will. We need to be able to track databases to know who they belong to and who should have access to them, plus we need to be able to limit databases per account based on which plan they are on."

I told them that they can create the database for me, using Aspnet_regsql.exe (See: http://msdn2.microsoft.com/en-us/lib...pprovider.aspx )

I know they are going to come back whining about this or that because they always do. Besides, I have another domain parked there, and I will want to do the same Login setup for that one. That will mean 2 databases. Even though the databases will exist only for user login purposes, I can see them all running around in circles flapping their arms, clucking like agitated chickens.

Now, besides changing Web Hosts (a cheery thought, but an expensive and stressful undertaking), is there a way to create the user in an existing database? Since I'm using a database with the app anyway, is there a way to point to a table containing the requisite fields?

I suspect there is a way to rewire the SqlMembershipProvider to look somewhere else, or do something to the CreateUserWizard to allow this.

I'm using an MS Access database with the app (the only other type I can use (Web Host limitations again) is MySQL which brings it's own Non-Microsoft headaches).

Please help.