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?
Related Articles
Switch SQL Script Settings to Use Oracle ODBC Driver 7Number of Views Conditionally Run SQL Scripts During Uninstall 6Number of Views Use a SQL script to accept asset links in bulk 8Number of Views Spider Setup: SQL connection user needs ALTER permission on database 16Number of Views Perfom a bulk insert into Database using Sql Scripts view 4Number of Views
Revenera Assistant
Online
Hi, I am Reva - Ask me anything.
Updates
No new updates
Chat
Home
Updates
/**/
Thanks for the feedback!
Your feedback has been saved.Rate this response:
1
2
3
4
5
Add Additional feedback ( Optional )
0/240
English
English
Language changed successfully
Something went wrong
Email sent successfully
Something went wrong
Case create successfully
Are you sure you want to cancel
the case creation?
Please select a product to submit the case.
Please select a product version to submit the case.
0/255
Upload Attachment
File Upload
Maximum file
size allowed is 3 MB.
File type
not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to cancel the case creation?
Case closed successfully
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
File Upload
Maximum file
size allowed is 3 MB.
File type
not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Revenera Assistant
© 2026 Flexera Software. All Rights Reserved.
Case id: 00001065
Activity: Status change: 2 hours ago