PROBLEM STATEMENT

Launching the installation of the Microsoft Forefront Identity Manager 2010 Build 4.00.3576.2 hotfix generates a dialog with the error message, “Error 25070. These workstations have sessions with open files on this server.” However, there are no files or applications listed to close.

ERROR MESSAGE

Error 25070. These workstations have sessions with open files on this server:

STEPS TO DISCOVER CAUSE AND RESOLUTION

Utilize Windows Installer Verbose Logging to help isolate the issue.

msiexec /update <filename and path of the MSP file> /l*v myinstalllog.txt

WINDOWS INSTALLER LOG FILE – ERROR MESSAGE

Error 25070.Error connecting to database FIMSynchronizationService. These workstations have sessions with open files on this server:

MSI (c) (EC!58) [11:41:54:062]: Product: Forefront Identity Manager Synchronization Service -- Error 25070.Error connecting to database FIMSynchronizationService. These workstations have sessions with open files on this server:

Action ended 11:41:54: GetGroupNamesFromDB. Return value 1.

CAUSE

The logged in user executing the installation does not have SysAdmin permissions on the backend SQL Server.

RESOLUTION

Give the logged in user SysAdmin permissions on the backend SQL Server long enough to execute the installation.

Or

Log into the machine as a user that has SysAdmin permissions on the backend SQL Server.

SEE ALSO