Configuring SQL Server on AWS RDS, local SQL Express
rchinoy
Posts: 2 New member
Hi,
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?
Thanks,
Russ
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?
Thanks,
Russ
Tagged:
Comments
Unfortunately neither RDS nor SQL Server Express are supported (see the limitations section of the requirements page for more details). Sorry.
Redgate Software
Thanks for pointing that out.
- Russ