We want to switch from using the "Database" type of authentication (along with Integrated Security) to the more secure "Custom" type. Is there any way to convert existing users from one to the other? (without losing the private vaults)
There is a possible, non-documented method you could use.
AS-IS-NOT-FULLY-TESTED
BACKUP your database before trying this. You might want to test on a staging environment first.
CTRL + Edit the user
this will enable the "Authentication Type" drop down
Change it to Custom
OK
Rename the user using the Rename Login button
remove the domain for example
Click the "Change Password" and set a password
The user should be able to login using Custom auth
NOTE: this will not delete the integrated SQL Login for this user, you will need to do that manually via SSMS (SQL Server Management Studio)
USE [master]
GO
DROP LOGIN [yourdomain\username]
GOand
USE [your-database-name]
GO
DROP USER [yourdomain\username]
GOStéfane Lavergne