We have installed sitecore XP1 on our Servers and our SQL admin whats to disable the "contained database authentication" after installation because of security issues he was reading in a article from MS.
I've also seen this article: Why do we require Contained database for Sitecore 9?
So here the Question
How can I revert the contained Database setting after the installation without destroying my Sitecore instance?
We have allready tried to extract the Users and create local Server Logins for them but that doesn't seem to work for all Sitecore users.
When we try to extract the sitecore_coreuser with this SQL Script:
USE Sitecore_Core
ALTER USER [sitecore_coreuser] WITH NAME = [sitecore_coreuser_ORIG]
USE master
CREATE LOGIN [sitecore_coreuser] WITH PASSWORD=N'sitecore_coreuser'
USE Sitecore_Core
CREATE USER [sitecore_coreuser] FOR LOGIN [sitecore_coreuser] WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE [aspnet_Membership_BasicAccess] ADD MEMBER [sitecore_coreuser]
ALTER ROLE [aspnet_Membership_FullAccess] ADD MEMBER [sitecore_coreuser]
ALTER ROLE [aspnet_Membership_ReportingAccess] ADD MEMBER [sitecore_coreuser]
ALTER ROLE [aspnet_Profile_BasicAccess] ADD MEMBER [sitecore_coreuser]
ALTER ROLE [aspnet_Profile_FullAccess] ADD MEMBER [sitecore_coreuser]
ALTER ROLE [aspnet_Profile_ReportingAccess] ADD MEMBER [sitecore_coreuser]
ALTER ROLE [aspnet_Roles_BasicAccess] ADD MEMBER [sitecore_coreuser]
ALTER ROLE [aspnet_Roles_FullAccess] ADD MEMBER [sitecore_coreuser]
ALTER ROLE [aspnet_Roles_ReportingAccess] ADD MEMBER [sitecore_coreuser]
ALTER ROLE [db_datareader] ADD MEMBER [sitecore_coreuser]
ALTER ROLE [db_datawriter] ADD MEMBER [sitecore_coreuser]
GO
Sitecore is not working anymore. Did we miss something in the usersettings?