Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MSSQL database user #158

Closed
seanlucey opened this issue Sep 19, 2023 · 2 comments · Fixed by #168 or #192
Closed

MSSQL database user #158

seanlucey opened this issue Sep 19, 2023 · 2 comments · Fixed by #168 or #192
Labels
bug Something isn't working

Comments

@seanlucey
Copy link

What happened?

Attempting to create MSSQL User. User fails to create with managed/user.mssql.sql.crossplane.io cannot create user: mssql: You can only create a user with a password in a contained database.

How can we reproduce it?

Using the following:

apiVersion: mssql.sql.crossplane.io/v1alpha1
kind: User
metadata:
  name: user-name
spec:
  deletionPolicy: Delete
  forProvider:
    databaseRef: 
      name: database-name
    passwordSecretRef:
      name: password-secret
      namespace: namespace
      key: password
  providerConfigRef:
    name: provider-config

What environment did it happen in?

Crossplane version: 1.12.2
@seanlucey seanlucey added the bug Something isn't working label Sep 19, 2023
@AGrzes
Copy link

AGrzes commented Sep 28, 2023

I encountered this bug and was able to workaround the issue by enabling contained databases.
https://stackoverflow.com/a/51671176
But it would be nice to be able to set the options automatically when creating database using provider-sql

Alternatively the create user operation could split login and user creation
https://stackoverflow.com/a/54679117

@vykovalenko
Copy link

Hi Team do you have any updates about this bugfix?

@arielsepton arielsepton mentioned this issue Dec 29, 2023
Merged
@bakito bakito mentioned this issue Sep 19, 2024
Merged
2 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
3 participants
@AGrzes @seanlucey @vykovalenko