FIM 2010 Troubleshooting: Error 25070 These workstations have sessions with open files on this server
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.