connect to SQL server fail with error user is not DBowner

[HussamRabaya]

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 

[Dhayanand · Accepted solution]

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

[HussamRabaya]

it was there but i did it again and it worked