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 with a user that has SysAdmin permissions on the backend SQL Server.
SEE ALSO Current Forefront Identity Manager 2010 Resources Current Certificate Lifecycle Manager Resources GalSync Resource Wiki PCNS-Password Synchronization Wiki
Richard Mueller edited Revision 2. Comment: Removed (en-US) from title, added tag
Patris_70 edited Revision 1. Comment: added en-US title