Database deploy to AWS RDS failing
I've got a SQL Server database deploy setup in Deployment Manager and when I deploy it to any other database than an AWS RDS SQL Server DB it works fine.
It appears to create all the database objects and reports completion but then throws an error that it can't log back in to the database like so..
2014-06-28 18:43:46 +00:00 INFO Creating extended properties
2014-06-28 18:43:46 +00:00 INFO The database update succeeded
2014-06-28 18:43:46 +00:00 INFO Dropping users
2014-06-28 18:43:46 +00:00 INFO Skipping post-deploy validation; "Use postdeploy validation" is set to "No" in the database package step options
2014-06-28 18:43:46 +00:00 INFO Deployment complete:
2014-06-28 18:43:46 +00:00 INFO - Writing deployment details to the database for deployed version [Tradesquare_Store_Database\22.0-master]
2014-06-28 18:43:46 +00:00 ERROR Cannot open database "Saas_Store" requested by the login. The login failed.
2014-06-28 18:43:46 +00:00 ERROR Login failed for user 'admin'.
2014-06-28 18:43:46 +00:00 ERROR Caused by:
2014-06-28 18:43:46 +00:00 ERROR -Cannot open database "Saas_Store" requested by the login. The login failed.
Also, after the deploy, the database becomes unusable from SSMS and/or VS Sql Explorer. You can't even delete the DB, it just reports that 'The database <name> is inaccesible'
I have to restore a backup or spin up a new RDS instance.
I've also tried manually creating the database before the deploy, checking that I can create objects ok then doing the deploy and the same thing happens.
Any help would be great,