Hello I have an sql server and a `Sql.Database` on that server. I need a user/login in addition to t...

rough-car-14453

08/27/2024, 9:11 AM

Hello I have an sql server and a

Sql.Database

on that server. I need a user/login in addition to the admin user/login, without admin permissions, for use on the database. How should I do this?

big-architect-71258

08/27/2024, 11:50 AM

I think you can use the Pulumi mssql provider for that. https://www.pulumi.com/registry/packages/mssql/

adventurous-butcher-54166

08/27/2024, 5:59 PM

Just be aware that the underlying terraform provider which

pulumi-mssql

is based on hasn't been updated since Feb 2023. https://github.com/PGSSoft/terraform-provider-mssql/issues/140

adventurous-butcher-54166

08/27/2024, 6:02 PM

@big-architect-71258 Oh I see that you are the creator of

pulumi-mssql

and also author of the issue

👍🏻 1

big-architect-71258

08/27/2024, 7:25 PM

@adventurous-butcher-54166 because my issue collected 14 thumbs up and I need some updates on this provider for a customer project anyway I think I'll fork the repository into a new version and base the Pulumi provider on it. But it really depends on the decision of my customer. No spare time to work on such a provider right now.

🙏 1

big-architect-71258

08/28/2024, 2:44 PM

@adventurous-butcher-54166 there is a promising PR https://github.com/betr-io/terraform-provider-mssql/pull/93 in the mssql Provider of betr-io which seems to be still monitored by the owner and thus can be considered active. Perhaps I can base the Pulumi mssql provider on this Terraform provider. I've to check though if it's possible to create aliases for the old resources or configure the mapping in a way that it does not create a bunch of breaking changes.

🙌 1

15 Views

Open in Slack

Previous Next

Pulumi Community

No matter how you like to participate in developer communities, Pulumi wants to meet you there. If you want to meet other Pulumi users to share use-cases and best practices, contribute code or documentation, see us at an event, or just tell a story about something cool you did with Pulumi, you are part of our community.