Hi ,
im installing Identity manager 3.3.0 ,during the configuration im connection to external DB which is SQL server with settings mentioned first time in Workspace "VMware Workspace ONE UEM Installation Guide - VMware Docs " and then second time using below script
CREATE DATABASE saas
COLLATE Latin1_General_CS_AS;
ALTER DATABASE saas SET READ_COMMITTED_SNAPSHOT ON;
GO
BEGIN
CREATE LOGIN horizon WITH PASSWORD = N'H0rizon!';
END
GO
USE saas;
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'horizon')
DROP USER [horizon]
GO
CREATE USER horizon FOR LOGIN horizon
WITH DEFAULT_SCHEMA = saas;
GO
CREATE SCHEMA saas AUTHORIZATION horizon
GRANT ALL ON DATABASE::saas TO horizon;
GO
however im always getting error, current user is not DB owner
can anyone advice me if you faced this issue before
Hi Hussam,
Guess you are missing one more query at the end:
ALTER ROLE [db_owner] ADD MEMBER horizon;
GO
You can refer the below link :
Configure Microsoft SQL Database Using Local SQL Server Authentication Mode
Thanks
Dhayanand
Hi Hussam,
Guess you are missing one more query at the end:
ALTER ROLE [db_owner] ADD MEMBER horizon;
GO
You can refer the below link :
Configure Microsoft SQL Database Using Local SQL Server Authentication Mode
Thanks
Dhayanand
it was there but i did it again and it worked