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.
Version: Sitecore 9.2 Initial
, Microsoft SQL Server 2017