A product from

• Frequently asked questions
• News archive
• Blog
• Help and tutorials
  • User Interface
  • Functions and tools
  • Configuration and customization
  • Detailed information
  • Tutorials, tips and tricks
    • Helium Web Service API
    • How to connect your iPod and iPhone device
    • Installing Microsoft SQL Server 2008 Express
    • Setting up a working MySQL connection
    • Translating into your language
    • Using Helium Music Manager in a multi-user environment
    • Video tutorials
    • Creating or restore a MS SQL database backup on a remote server
    • Creating or restore a MySQL Database backup on a remote server
• Forum
• Customer Center
• Contact us
• About us

Installing Microsoft SQL Server 2008 Express

This guide is aimed at those who want to install and use Microsoft SQL Server Express as database backend to Helium Music Manager.

Microsoft SQL Server Express generally gives much better performance when having large collections. This is also the way to go if you plan on using Helium Music Manager in a multi-user environment where two or more clients want to access the same music collection.

Installing

Please follow the instructions below to install Microsoft SQL Server 2008 Express. If you will use Helium Music Manager in a multi-user environment this only needs to be done on the server (the computer where the music and the database resides).

1. Visit the following web page as Microsoft.com:
   
   http://www.microsoft.com/express/Database
2. Click on the 32-bit or 64-bit button depending on your computer setup. If you are unsure, use the 32-bit.
3. A new window will open. Optionally select a language and click the Download Now button. If a new window is not opened, please review your popup blocker settings.
4. Another window will open. You may see a yellow bar at the top of the window indicating that the file has been blocked. Click the bar and select Download File.
5. Run the installation file.
6. If the Microsoft Web Platform is not previously installed, just click the green Get the Microsoft Web Platform button. When a download dialog shows, asking if you want to run or save the wpilauncher_n.exe, click Run. If you get a security warning, make sure that the Publisher is Microsoft and then click Run. 
7. The installation is very straightforward and will sometimes ask you about installing required components. Always say Yes to this.
   
   Required components that will be automatically installed (if they aren't already) are:
   • Windows Installer
   • .NET 2.0 Framework
   • .NET 3.5 Framework
8. After having installed some components you may be asked to reboot your computer. Always say Yes to this.
9. After having rebooted your computer the Web Platform Installer may tell you that the installation failed but this information can safely be ignored as the installation will continue.
10. When asked by the installer, select Windows Integrated Authentication and click Continue.
11. When the installation is finished, click Close.

Congratulations! You are now ready to configure Helium Music Manager to use SQL Server Express.