Configuring SQL Server on AWS RDS, local SQL Express


I’ve downloaded and installed DLM Dashboard, but we use AWS RDS for testing and production and when I try to run the script to setup the server I get some errors:

Msg 2104, Level 14, State 1, Procedure RG_SQLLighthouse_DDLTrigger, Line 27
Cannot create the trigger 'RG_SQLLighthouse_DDLTrigger', because you do not have permission.
Msg 3902, Level 16, State 1, Line 23
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.

Is there any workaround for RDS?

Also, when I added my local SQL Express server and some of its dbs, the dbs always have a status of “Checking schema...”. Is SQL Express not supported?



Sign In or Register to comment.