adding/attaching/using aspnetdb (membership db)

I'm developing a database web app in ASP.NET 2.0 on my desktop using MS Visual Web Dev 2005 Express and SQL Server 2005 Express.

I just signed up with DASP a couple days ago, and had no problem putting the database and app on the site, attaching the business db, and running the app.

Today I added a membership/login layer to the app on my desktop, which creates (automatically, when using SQL Express), a new database file called aspnetdb.mdf (and the corresponding .ldf file). This system works fine on my desktop, but...

I have not been able to get it working on the DASP server. I have spent several hours searching the KB, Forums, and general Google searches in addition to re-reading the Security and Membership chapters several times in the book I'm using as a reference (yes, this is my first foray into database web apps...).

Could someone please provide or point me to a clear set of instructions on how to configure things. I can't figure out whether I'm having problems with connection settings in web.config, or whether I should/should not be uploading my aspnetdb files, or whether I should somehow be storing all of it in the apps database (PED15SQL.mdf)... I tried using SQL Server Mgt Studio Express and was able to connect to and see my DASP setup, but couldn't see the membership database files or attach them... I feel I must be a millimeter away from getting this to work but can't quite figure out all the parts...

Thanks in advance for your help.

Chris

 

Bruce,

As I am VERY new to ASP.NET development and DASP, I am going to have to ask a few very stupid questions.

1) As my project will be using memberships/roles, I am obviously needing the use a DB. I am using VWD Express for the development. Will the SQL Express databases that are on my local machine work on DASP?

2) Do I need to get the MS SQL add-on in order for it to work, or can the DB be on the same server as the App itself?

Lance

 

To use the membership/roles on DASP servers,you need purchase the MS SQL add-on .You can use your local environment(SQL database) for development purposes and then transfer over the local copy to DASP database servers (using SQL tools in your control panel(available once you purchase the MS SQL add-on)- which lets you attach,restore etc. to the DASP database server)

Vikram

DiscountASP.NET
www.DiscountASP.NET