Can I use Amazon RDS to deploy my SQL server for BigFix?

Usage and Config
1

Hello,

I would like to install BigFix but I want the DB to be managed by AWS’s RDS service.

I’m not sure I’ll be getting full SA permissions on that database and the documentation says I need to have sysadmin permissions on the SQL server.

I couldn’t find posts about this specific topic so here I am. Can I use Amazon’s RDS service to deploy an SQL server for my BigFix installation?

Thanks :slight_smile:

2

I know at least a year ago some customers were running in RDS but had trouble performing upgrades because they could not acquire the server_admin role. I presume they had a configured deployment and migrated the existing database to RDS but I wasn’t involved with it, I heard about it second-hand.

I’m not sure whether anything’s changed on enabling that in the platform.

@Aram @davel anything to say on this?

2 Likes
3

Thanks. We’re actually not looking to upgrade an existing installation, we want to install a clean one. I’m assuming this would be relevant in the future if we’d want to upgrade at some point.

I guess we’ll have to go with a non-RDS way of installing our db. Thanks :slight_smile:

1 Like
4

I’ll keep my ear to the ground if I hear about progress on this I’m sure we’d have an announcement.

5

This was cross posted here: https://www.reddit.com/r/bigfix/comments/kzu1aa/can_i_use_amazon_rds_to_deploy_my_sql_server/

Please create an entry in the BigFix Ideas portal for this request with as much info as you can and promote the link to it here so others can vote on it: https://bigfix-ideas.hcltechsw.com/

1 Like
6

Actually, that’s me :slight_smile:
Thanks for the answer, will post there.

7

It is not advisable to install BigFix with AWS RDS for the BigFix databases. Either size your AWS nodes to run all BigFix and MSSQL services co-located or have an additional AWS node for your MSSQL instances.