Timeline for Convert SQL Server user based on login to contained database user based on Windows account
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 24, 2023 at 17:31 | comment | added | manniongeo | Per the OP, I'm trying to convert to a contained user based on a Windows account. This procedure only appears to be able to migrate to a user with a password stored in the contained database. See details in "Attempts" section of OP, plus first sentence of the doc referenced in this proposed solution: "Converts a database user that is mapped to a SQL Server login, to a CONTAINED DATABASE USER WITH PASSWORD." (caps for emphasis; not shouting). Is there a way to use this procedure to switch to a Windows-authenticated user? | |
| Apr 20, 2023 at 10:20 | history | edited | Paul White♦ | CC BY-SA 4.0 |
Expanded answer with a brief quotation
|
| S Apr 20, 2023 at 10:04 | review | First answers | |||
| Apr 20, 2023 at 10:20 | |||||
| S Apr 20, 2023 at 10:04 | history | answered | Aardvark | CC BY-SA 4.0 |