Hi. I'm trying to use the ASPNETDB database for user management and store it in tha Amazon Web Services RDS SQL server service.
I tried numerous ways to create the DB there, like, scripting the local DB and running that script against the AWS DB, Backup/restore, logging from the aspnet regsql tool that comes with ASP.NET, etc. but I can't make it work.
Even though I get a big OK after running the scripts with everything created perfectly, I get:
The EXECUTE permission was denied on the object 'aspnet_CheckSchemaVersion', database 'ASPNETDB-XXXXXXX', schema 'dbo'.
Also, from the tool i get :
Exception: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 3701 and the SqlException message is: Cannot drop the procedure 'aspnet_Setup_RestorePermissions', because it does not exist or you do not have permission.
---------------------------------------- Details of failure ----------------------------------------
NestorLeone
Member
183 Points
46 Posts
Amazon RDS - Has Anyone got it working?
Feb 02, 2013 07:31 PM|LINK
Hi. I'm trying to use the ASPNETDB database for user management and store it in tha Amazon Web Services RDS SQL server service.
I tried numerous ways to create the DB there, like, scripting the local DB and running that script against the AWS DB, Backup/restore, logging from the aspnet regsql tool that comes with ASP.NET, etc. but I can't make it work.
Even though I get a big OK after running the scripts with everything created perfectly, I get:
The EXECUTE permission was denied on the object 'aspnet_CheckSchemaVersion', database 'ASPNETDB-XXXXXXX', schema 'dbo'.
Also, from the tool i get :
Exception:
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 3701 and the SqlException message is: Cannot drop the procedure 'aspnet_Setup_RestorePermissions', because it does not exist or you do not have permission.
----------------------------------------
Details of failure
----------------------------------------
SQL Server:
Database: [ASPNETDB-AWSUAT]
SQL file loaded:
InstallCommon.sql
Any ideas from anyone? Has anyone tried this and has it working flawless, or is the AWS RDS not compatible?
Thanks!