Merging Databases?

I'm knew to .NET, SQL and such. Anyway, I've created a small database-driven website that is hosted on discountAsp.net. I've created the site using Visual Web Developer 2005 Express Edition. The databases are SQL Server 2005 Express Edition. I am using two databases: one for login criteria, the second for the actual data for the website. I uploaded the entire site and attached the data database to a SQL 2005 Server database. After some tweaking I got this to work. Great. My problem has to do with the security database. I used VWD's ASP.NET configuration to setup login, security, and such. When I did that, it created the well-known aspnetdb.mdf database. I only want discountAsp.net to host one database. So, is there a way I can merge the two together. OR, since I do not need an extensive user login database, can I bypass the builtin security stuff and code something simple....esentially creating a login page that verifies users/passwords that are hardcoded in the web.config, or something similar?

Thanks for your help!

Ron

 

You can create the membership schema on the same database as follows:

a) navigate to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
b) execute this aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name]

But you may have to to add logins /roles to the newly created tables.You can still use the ASP.NET configuration tool,just have your DASP MS SQL Server configured in your web.config.


Vikram

DiscountASP.NET
www.DiscountASP.NET