Having the ability to specify a SID value when creating a login of type SQL_LOGIN, as this will allow us to ensure that SIDs match across all servers for logins of this type. This is required when cloning databases between environments for the permissions to be reflected
Describe the Solution You Would Like
A parameter for the sqlserver::login resource that allows you to specify the SID value directly
Describe Alternatives You've Considered
We are looking at conditionally creating anything of type SQL_LOGIN via a sqlserver_tsql resource and string interpolation, only using sqlserver::login for WINDOWS_LOGIN entries. This should work, but is pretty suboptimal!
Use Case
Having the ability to specify a SID value when creating a login of type SQL_LOGIN, as this will allow us to ensure that SIDs match across all servers for logins of this type. This is required when cloning databases between environments for the permissions to be reflected
Describe the Solution You Would Like
A parameter for the sqlserver::login resource that allows you to specify the SID value directly
Describe Alternatives You've Considered
We are looking at conditionally creating anything of type SQL_LOGIN via a sqlserver_tsql resource and string interpolation, only using sqlserver::login for WINDOWS_LOGIN entries. This should work, but is pretty suboptimal!