IGEL UMS error: Schema ILUMS not configured as default schema


Hi, I am migrating from EmbeddedDB to MSSQL. I got up to copy DB and it worked. Now when I select Activate I receive the following message.

“Schema ILUMS not configured as default schema”

Any ideas? We followed the IGEL KB precisely for this process.


Hi, can you post the SQL Script commands you used?


We followed the following kb.igel.com/endpointmgmt-6.05/en/setting-up-the-sql-database-31599020.html

we created a new SQL DB called “ILUMS”. We didn’t use the “rmdb”. Does this matter?

CREATE DATABASE ILUMS

GO

USE ILUMS

GO

CREATE LOGIN igelums with PASSWORD = ‘XXXXX’,

DEFAULT_DATABASE=ILUMS

GO

CREATE USER igelums with DEFAULT_SCHEMA = igelums

GO

CREATE SCHEMA igelums AUTHORIZATION igelums GRANT CONTROL to igelums

GO


No, that doesn‘t matter. Can you also forward a screenshot of the DB adding mask in UMS Administrator? I‘m expecting a mix up in the Schema / name.


igelcommunity.slack.com/archives/C8FC01UNM/p1602625922281700

igelcommunity.slack.com/archives/C8FC01UNM/p1602626196282700


I mean, when you add or edit the SQL DB, in your screenshot you show the SQL Server as selection, but the Window is still showing the Embedded DB infos.

Is this what you are asking for?


The issue might be with the way jdbc makes dynamic queries under mmssql.

For UMS to work properly, the UMS database user needs to have a default database assigned to the user object. Im guessing your database is assigned to master or may not have correct privs.

From sql server management studio — edit the user and select the ums database as the default


More that:

(see all images in the IGEL Community on Slack – join below)


We have that set already.

I sent the screen shot earlier in this forum. Did you see it? Regarding your questions to my set up.

Host is the SQL HA listener.

I also have this which I never reported.


I would follow IGEL’s suggestion. We had an issue when we set things up in our lab with user misconfiguration due to security policies overriding the script


May I ask a dumb question? In your script you used the Schema name igelums, in UMS Administrator ILUMS.

Did you changed it in the meantime?

Continue reading and comment on the thread ‘IGEL UMS error: Schema ILUMS not configured as default schema’.  Not a member? Join Here!

Learn more, search the IGEL Knowledge Base



Ask a question or comment on the above messasge thread?

Join or log in to the IGEL Community to ask us anything and meet other IGEL customers, partners, and EUC enthusiasts.

Submit a question, or Join Today!


Popular Message Threads


Categories & Tags: