Thursday, October 04, 2012 5:15 PM
We have an old installation of IIFP that still works and is connected to a remote SQL Server. We'd like to move the database to another SQL server installation. We understand how to do that on the SQL side, but can't find where the database location is configured in IIFP.
Thanks for any solutions or links,
Thursday, October 04, 2012 8:46 PMOwner
Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation
- Marked As Answer by Markus VilcinskasMicrosoft Employee, Owner Monday, December 03, 2012 4:33 PM
Thursday, October 04, 2012 8:53 PMThanks Markus. I had seen that. I was just hoping there was a line somewhere in MIIS to change the IP address or name of the SQL Server without having to do an uninstall/reinstall. Do my Management Agents stay in tact, or should I export them first knowing that I may need to import them back in?
Friday, October 05, 2012 5:07 PMAlthough the fine details escape me now, and it wouldn't be a supported way to change the database server, I have successfully moved MIIS and ILM databases in the past by editing the registry in the general vicinity of HKLM\System\CurrentControlSet\services\miiservice. Another thing I recall is that while the database name *appears* to be variable as per the registry, changing it there has no effect.