Hello I have an sql server and a `Sql.Database` on...
# azure
r
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?
b
I think you can use the Pulumi mssql provider for that. https://www.pulumi.com/registry/packages/mssql/
a
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
@big-architect-71258 Oh I see that you are the creator of
pulumi-mssql
and also author of the issue
👍🏻 1
b
@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
@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