06-29-2023 08:37 AM - edited 07-24-2023 06:50 AM
We have a large number of Amazon RDS virtual SQL servers
Currently administering users on them is a manual task as they are not domain connected and to do so in with an Amazon hosted domain is crazy expensive 😞
I know if it were a "real" SQL server there is a workaounnd that has JC sync users down to a windows user group on the machine and from there you make that a member of a usergroup in SQL server
However that is not an option for us as you don't get direct access to the underlying server.
So, is there, or is there plans for, a mechanism to sync JC users into SQL as native users? (I know the SQL to add, remove, change users has existed for decades)
https://jumpcloud.com/blog/domainless-access-to-ms-sql-server-tutorial
Solved! Go to Solution.
12-13-2023 05:16 AM
I have found there is a third-party that can do it, it's called "Employee IT Onboarding" by Aquera and plugs in JC using SCIM
07-05-2023 09:19 AM
Hello! 🙂
So we do have an AWS IAM integration. Would this work for you? https://jumpcloud.com/support/integrate-with-aws-iam-identity-center
Let me know if what you're looking for isn't covered by this integration. 🙂
07-05-2023 09:50 AM - edited 07-05-2023 09:51 AM
Sadly not, IAM integration for RDS is just for mysql, postgres and aurora
A quick look around the web will bring up lots of SQL scripts for adding/removing/listing users/roles, changing passwords etc so I could imagine that your dev's could use them and reuse some of your existing user-sync code.
https://stackoverflow.com/questions/1601186/sql-server-script-to-create-a-new-user
07-05-2023 10:54 AM
Ah okay, I get it. Let me see what I can dig up for you 🙂
07-05-2023 11:58 AM
...and I'm back with an update. Unfortunately it looks like a custom script is the only option right now but our Professional Services can help with that if you need: https://jumpcloud.com/professional-services/pse
I'm not sure about the feature being built in though but you can put in a feature request if you'd like: https://jumpcloud.com/support/request-features
07-20-2023 07:01 AM
Hi, I don't see how a custom script would works as I don't think the jumpcloud api exposes the account password, which is what you'll need for account creation and password resets
07-20-2023 07:05 AM - edited 07-20-2023 07:09 AM
I have raised it in "request features" 00200326 but tbh whatever I have put there in past doesn't get a response and most are just sitting at "new"
07-20-2023 11:48 AM - edited 07-20-2023 11:51 AM
Hi ncarmichael, I understand that that's frustrating. I'll make sure I pass on the feature request and your feedback internally.
10-10-2023 10:57 AM
Please do as three months on, they still have it set as "reviewing" 🙄
10-11-2023 10:13 AM
Hi @ncarmichael I'll update the feature request internally and see if I can get an update for you.
12-13-2023 05:16 AM
I have found there is a third-party that can do it, it's called "Employee IT Onboarding" by Aquera and plugs in JC using SCIM
New to the site? Take a look at these additional resources:
Ready to join us? You can register here.