I currently run the Kaseya database on the Microsoft MSDE engine. I'd like to upgrade it to SQL 2005 Express Edition, or the full version of SQL 2005. How do I go about this?
Follow the Microsoft best practices outlined in the white paper at http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx with regards to upgrading MSDE to SQL Server 2005 Express Edition.
When you do any major software installation, you should ensure that you have a complete backup of the Kaseya server prior to beginning. You should also stop and disable the Kaseya Server service prior to the upgrade, and only set the service back to Automatic and restart it after verifying the upgrade has completed successfully.
Because Kaseya just uses the MSDE MSI installer, the in place upgrade should work option outlined in the article should work. However, to allow rollback in the event of an error, you may wisht to do a side by side installation.
The only real difference between SQL Express and SQL Standard, with regards to installation that is, is that you can install SQL Express directly to the most recent service pack level because Microsoft ships each service pack as a full install package. When installing SQL Standard, you have to install the RTM product first, and then apply the patch to bring it up to the current service pack level. Kaseya strongly recommend that you service pack your SQL Server 2005 to Service Pack 2 due to serious bugs that are present in earlier versions of the product.
All the information in the above white paper would apply to SQL Standard as well except where it refers to specific functional limitation of Express that don't exist in Standard.
If you choose Mixed Mode Authentication throughout the upgrade process, must provide a strong sa password if this is not already in place.
Mixed Mode authentication requires that you enter a strong sa password before you can continue to the next page of the Installation Wizard. A strong password must contain six or more characters, including at least one from three of the following categories: uppercase letters, lowercase letters, numbers, and non-alphanumeric characters (such as #, %, or ^). A strong password cannot be a reserved keyword, cannot include the computer name, and cannot include the username of the person logged onto the computer.
If you have not provided a stronger password containing six or more characters, including at least one from three of the following categories: uppercase letters, lowercase letters, numbers, and non-alphanumeric characters (such as #, %, or ^), please reset your current sa password to a password following these rules within your MSDE account setup.
SQL Server 2005 Express Edition
SQL Server 2005