I configured private and shared session using
SQL Provider, following this link After I deployed the
Sitecore.Sessions.dacpac file, I tried to create a user for the database but it was failing with the error
USE [MyProject_Sessions] GO CREATE USER [sessionsuser] WITH PASSWORD='password@123', DEFAULT_SCHEMA=[dbo] GO
So I created a login assigned db_datareader and db_datawriter like in other users such as master user but the login did not work. Currently, I'm using 'sa'. If I want to create a separate login for this DB, what all roles are required.
Sitecore 9.2 Initial,
Microsoft SQL Server 2017