web deploy aspnet_membership_basicaccess

I get this error when trying using web deploy. I don't see a aspnet_membership_basicaccess.


Error 1 Web deployment task failed.((9/13/2010 10:18:14 PM) An error occurred when the request was processed on the remote computer.)
Failed to publish the database. This can happen if the remote database cannot run the script. Try modifying the database scripts, or disabling database publishing in the Package/Publish Web properties page. If the script failed due to database tables already exist, try dropping existing database objects before creating new ones. For more information on doing these options from Visual Studio, see http://go.microsoft.com/fwlink/?LinkId=179181.
Error details:
(9/13/2010 10:18:14 PM) An error occurred when the request was processed on the remote computer.
An error occurred during execution of the database script. The approximate location of the error was between lines '1' and '3' of the script. The verbose log may have more information about the error. The command started with :
CREATE ROLE [aspnet_Membership_BasicAccess] AUTHOR
http://go.microsoft.com/fwlink/?LinkId=178587
0 0 We

 

When I take a look at my SQL Svr 2008 database hosted on the DASP server that includes the aspnet membership / roles / profile schema, I can see there are many database roles present that were created when I originally executed the aspnet_regsql command line tool a long time ago, including the aspnet_membership_basicaccess role.

I know this doesn't help you out much but it at least clarifies that web deploy is failing to create a required database role for some reason. I'd try and create a web deploy verbose log if you can - it might contain the reason for this failure.

 

Thanks CrystalCMS. I'll give it a try.

 

sql express 2008

I should be able to web deploy a sql express 2008 data file, right? I tried to attach, but that failed.

 

Some of my problem is solved. My hosted SQL was 2008, but I'm using r2 express for development so I upgraded my hosted server to r2. Now web deploy is working. I'm still getting the same error as above, but my database seems to have deployed ok and is functional. I tried the attach tool and it worked as well.

 

...Thanks for posting updates.
Any 'gotchas' listed in these threads help many others at times.
All the best,
Mark