IMPORTANT: Always back up the database before making direct SQL changes.

1. Review Flexera support policy

• Flexera Support doesn’t support database migration. If you need guaranteed assistance, contact your account representative to ask about Flexera Professional Services (additional costs may apply).
• If you’re migrating on your own, make sure you meet all prerequisites. See Database migration prerequisites.

2. Reconfigure database connections

After the migration is complete:

1. Open Snow Inventory Server Configuration Manager and reconfigure the database connection.
2. Open the Snow License Manager Web Configurator and reconfigure its database connection.
3. Verify if the Inventory Source is now visible in SMACC.

3. Verify SQL permissions

If the Inventory Source still doesn’t appear:

1. Make sure the LicenseManagerUser account has the required SQL permissions.
2. Follow the instructions in SQL script to check the database permissions for LicenseManagerUser to check the SQL server permissions for LicenseManagerUser for required roles and rights.
3. Correct any missing permissions and try adding the inventory source again.

4. Investigate why the DUJ is hanging

If the DUJ runs continuously after adding the Inventory Source, run these SQL queries against the SnowLicenseManager database:

SELECT * FROM SnowLicenseManager.dbo.tblCIDDataSource;

SELECT * FROM SnowLicenseManager.inv.tblSite;

Look for:

• Any record with CID = 0
• A mismatch between SourceId and CID values

5. Correct any SourceId and CID misalignment

If you find mismatched records:

1. Find the correct SourceId and CID values in tblCIDDataSource.
2. Identify the incorrect record in inv.tblSite using its SiteId.
3. Update the record (back up the database first):

UPDATE SnowLicenseManager.inv.tblSite

SET SourceId = <CorrectSourceId>, CID = <CorrectCID>

WHERE SiteId = <ProblematicSiteId>;

Run the DUJ again to confirm it completes successfully.