SQL script to check the database permissions for LicenseManagerUser
If the permissions for the LicenseManagerUser account are not correctly configured, it can cause issues with Snow License Manager and related components. The following SQL script checks both server-level and database-level permissions so you can verify that the correct roles and access rights are in place.
- Run the script below in your SQL Server query tool.
-- Check server-level permissions
SELECT
sp.name AS LoginName,
sp.type_desc AS LoginType,
sp.default_database_name,
sp.is_disabled,
perm.permission_name,
perm.state_desc
FROM sys.server_principals sp
LEFT JOIN sys.server_permissions perm ON sp.principal_id = perm.grantee_principal_id
WHERE sp.name = 'LicenseManagerUser';
-- Check database-level roles for SnowLicenseManager
USE SnowLicenseManager;
SELECT
dp.name AS UserName,
dp.type_desc AS UserType,
dr.name AS RoleName
FROM sys.database_role_members drm
JOIN sys.database_principals dp ON drm.member_principal_id = dp.principal_id
JOIN sys.database_principals dr ON drm.role_principal_id = dr.principal_id
WHERE dp.name = 'LicenseManagerUser';
-- Check database-level roles for SnowInventory
USE SnowInventory;
SELECT
dp.name AS UserName,
dp.type_desc AS UserType,
dr.name AS RoleName
FROM sys.database_role_members drm
JOIN sys.database_principals dp ON drm.member_principal_id = dp.principal_id
JOIN sys.database_principals dr ON drm.role_principal_id = dr.principal_id
WHERE dp.name = 'LicenseManagerUser';
-- Check msdb roles
USE msdb;
SELECT
dp.name AS UserName,
dp.type_desc AS UserType,
dr.name AS RoleName
FROM sys.database_role_members drm
JOIN sys.database_principals dp ON drm.member_principal_id = dp.principal_id
JOIN sys.database_principals dr ON drm.role_principal_id = dr.principal_id
WHERE dp.name = 'LicenseManagerUser';- Compare the results of this script against the provided screenshot to confirm that the
LicenseManagerUserhas the expected permissions. If any roles or permissions are missing, update the configuration accordingly.
Was this helpful?
