What are the steps to move the DS MSDE database to a SQL database?
- Stop the "Altiris Deployment Server DB Management" service.
- Run Enterprise Administrator for SQL, connect to the server where the eXpress database is.
- Take the eXpress database offline, detach the database from the server, and physically copy the eXpress database and log (eXpress.MDF and eXpress_log.LDF) to the new SQL destination server.
- With Enterprise Administrator, attach the database to the new server and bring the database online.
- Go to the Altiris server (where the database was), in Control Panel run the "Altiris Express Deployment Server Console" choose Option then Authentication, check for SQL authentication server account, and give the username and password for the account.
- With a text editor, open the file .\Program Files\Altiris\eXpress\Deployment Server\default.cfg and make changes to the following line items:
SQLDatabaseName= <new SQL server name>
ServerIPAddress= <new SQL server's IP address>
Note: The previous step is usually only necessary for doing upgrades and so on, but can also help prevent problems wherein the DB Manager still connects to the previous SQL server instead of the new on.
- On the Altiris server after the database is moved, it is also possible to start the "Data Sources (ODBC)" in Control Panel > Administrative Tools. Choose System DSN, check for Altiris eXpress database, perform a Configure, and give the name of the new server where you put the database.
- Restart the "Altiris Deployment Server DB Management" service. (Servers running a DS Web Console need to be restarted)
- On the Altiris server, run the "Deployment server console." The server should start using the database you moved to the new SQL server.
- The account username and password in Altiris config must match the one used on the SQL server.