- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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.
- Labels:
-
Users and Groups
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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. ๐
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ07-05-2023 10:54 AM
Ah okay, I get it. Let me see what I can dig up for you ๐
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ10-10-2023 10:57 AM
Please do as three months on, they still have it set as "reviewing" ๐
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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