March 28, 2024
On occasion you (usually with the help of PSS – Product Support Services) may need to verify the integrity of the MIM Synchronization Service Database. To do this you can use the Store Check tool, StoreChk.exe located in the bin folder under the root of your MIM Synchronization install.
While the storechk tool does read the registry to find the name of the database (almost always is FIMSynchronizationService) it does not read the Server or Instance name registry values in the parameters key of the registry. Instead it defaults to assume that the SQL Server is co-located on the same machine as MIM Sync.
Since this installation is not colocated we kept getting this error:
MMS Store Analysis Tool (v4.6.673.0) starting…
FAILED: hr = 0x80230406 OLEDB Provider Information: Description = ‘Login timeout expired’ Failure Code = 0x80004005 Minor Number = 0
We even used Process Monitor from SysInternals to see that it read the registry for the DB Name but did not see it read the ServerName value (which has the name of the SQL Server).
So we experimented a few times and found that -Server will make it work to talk to a remote SQL Server:
storechk.exe -Server CompanySQLServer
This really is a tool that you normally should run only with Product Support as there are a number of undocumented switches and parameters.
