https://community.hpe.com/t5/server-management-systems/how-do-i-change-from-msde-to-ms-sql-server-database/m-p/3465119#M9042 I have installed my HPSIM 4.2 with the default MSDE database but for use with Altiris on the same server, I have installed MS SQL Server 2000. How can I change the SIM database from MSDE to MS SQL the safest way? Tue, 18 Jan 2005 02:22:16 GMT Torben Kronborg 2005-01-18T02:22:16Z https://community.hpe.com/t5/server-management-systems/how-do-i-change-from-msde-to-ms-sql-server-database/m-p/3465119#M9042 I have installed my HPSIM 4.2 with the default MSDE database but for use with Altiris on the same server, I have installed MS SQL Server 2000. How can I change the SIM database from MSDE to MS SQL the safest way? Tue, 18 Jan 2005 02:22:16 GMT https://community.hpe.com/t5/server-management-systems/how-do-i-change-from-msde-to-ms-sql-server-database/m-p/3465119#M9042 Torben Kronborg 2005-01-18T02:22:16Z https://community.hpe.com/t5/server-management-systems/how-do-i-change-from-msde-to-ms-sql-server-database/m-p/3465120#M9043 Hi Torben,<BR /><BR />You already installed the MS SQL server on the same machine?<BR /><BR />The easiest way is installing the MSDE and then do an upgrade to MS SQL server. This is an option in the installationprocess.<BR /><BR />Now that the sql server is already installed I'm afraid that you 'll have to create the instance etc. yourself and then migrate your data to the new database.<BR /><BR />HTH<BR /><BR />Best regards<BR /><BR />Sam Tue, 18 Jan 2005 03:11:23 GMT https://community.hpe.com/t5/server-management-systems/how-do-i-change-from-msde-to-ms-sql-server-database/m-p/3465120#M9043 Sam De Coster 2005-01-18T03:11:23Z