https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298056#M3388 If you are just migrating from one remote SQL server to another. After ensuring the same user/password, all you have to do is change the System DSN's in the ODBC Administrator. Point to the new server keeping the database names the same and test connectivity. I just did this yesterday Fri, 11 Jun 2004 10:20:00 GMT Matthew Kelner 2004-06-11T10:20:00Z https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298052#M3384 Hi,<BR /><BR />Is there a proceedure for pointing SIM 4x at a different SQL backend after it has been installed on MSDE?<BR /><BR />Also, what is the SA password SIM uses when it installs MSDE?<BR /><BR />TIA<BR />RIch<BR /><BR /> Mon, 07 Jun 2004 12:31:42 GMT https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298052#M3384 richard simpson 2004-06-07T12:31:42Z https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298053#M3385 Hi,<BR />I'll answer my own questions...<BR /><BR />I have DTS'd the insight DB to a SQL2k box, set up a DBO account on the new database,<BR />hacked the various DB related config files in the \conf dir to point to this,<BR />run the createDSN script in the root intall dir and configured the DNSs to point to the new DB,<BR />and who'd have thought it- it seems to work!<BR /> <BR />Still not sure what the default SA password it- changed authentication to mixed mode but it wont accept blank.<BR /><BR />cheers<BR />RIch<BR /><BR /> Tue, 08 Jun 2004 02:58:34 GMT https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298053#M3385 richard simpson 2004-06-08T02:58:34Z https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298054#M3386 Hi Rich.<BR /><BR />I need to move the db from one SQL Server to another SQL server.<BR /><BR />Could you please specify wich files in wich \conf dir you changed?<BR /><BR />Any help is appreciated.<BR /><BR />Sincerely,<BR />Frank Aune<BR />ITpro.no, Norway Fri, 11 Jun 2004 06:00:08 GMT https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298054#M3386 Frank_148 2004-06-11T06:00:08Z https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298055#M3387 Hi,<BR /><BR />the config files should be in <BR />c:\Program Files\HP\Systems Insight Manager\config<BR /><BR />and are database.props and database.admin<BR /><BR />the createDSN script is in E:\Program Files\HP\Systems Insight Manager<BR /><BR />I think you need to ensure the insight service account has sysadmin rights to the new DB (check its rights on the old one)<BR />cheers<BR />RIch Fri, 11 Jun 2004 08:26:49 GMT https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298055#M3387 richard simpson 2004-06-11T08:26:49Z https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298056#M3388 If you are just migrating from one remote SQL server to another. After ensuring the same user/password, all you have to do is change the System DSN's in the ODBC Administrator. Point to the new server keeping the database names the same and test connectivity. I just did this yesterday Fri, 11 Jun 2004 10:20:00 GMT https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298056#M3388 Matthew Kelner 2004-06-11T10:20:00Z https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298057#M3389 It worked. I stopped the IM-service, detached the database and attached it to the new SQL Server, edited registry and changed the value "Server" to the new servername under the keys:<BR /><BR />HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Insight_v1_0<BR />HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Insight_v1_master<BR /><BR />Started the HP Systems Insight Manager service and everything worked. "Easy as Dell" ;-)<BR /><BR />Thank you very much for the help guys!<BR /><BR />Frank Aune<BR />ITpro.no, Norway Tue, 15 Jun 2004 05:12:31 GMT https://community.hpe.com/t5/server-management-systems/how-to-migrate-database/m-p/3298057#M3389 Frank_148 2004-06-15T05:12:31Z