Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs
Resources for IT Professionals >
> 
> 
> 
IIFP v3.2 SQL Move

Odpovědět IIFP v3.2 SQL Move

  • Thursday, October 04, 2012 5:15 PM
     
     
    Sign In to Vote
    0

    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,

    Paul

     

All Replies

  • Thursday, October 04, 2012 8:46 PM
    Owner
     
     Answered
    Sign In to Vote
    0

    How To: Relocate the MIIS 2003 Database

    Cheers,
    Markus

    Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation

     
  • Thursday, October 04, 2012 8:53 PM
     
     
    Sign In to Vote
    0
    Thanks 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 PM
     
     
    Sign In to Vote
    0
    Although 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.