A product from

• Frequently asked questions
• News archive
• Blog
• Help and tutorials
  • User Interface
  • Functions and tools
  • Configuration and customization
    • Album sorting and grouping
    • Artist Grouping
    • Auto Enqueue options
    • Change Track Details columns
    • Customize toolbar
    • Customizing a Music Explorer node
    • Equalizer
    • Library management
      • Create new Microsoft SQL Server database
      • Create new MySQL database
      • Import Music Browser data
      • Open a Microsoft SQL Server database
      • Open a MySQL database
    • Options
    • Select Play Queue columns
    • Track List sorting and grouping
  • Detailed information
  • Tutorials, tips and tricks
• Forum
• Customer Center
• Contact us
• About us

Create new Microsoft SQL Server database

Creating a new Microsoft SQL Server Database

Before you can create a new Microsoft SQL Server database you must have installed Microsoft SQL Server - see this guide on how to this.

1. Click Advanced > Library > Management from the main menu to launch the Library Management dialog. You can also press CTRL-D on your keyboard.
2. Click on the Microsoft SQL Server databases tab.
3. Click the New button on the toolbar.
4. Enter the server name in the Microsoft SQL Server Name edit box. Generally you should enter <computername>\<instancename> in this box (Click the Get Name button to automatically fill the Server Name edit box with the name of your computer). For Microsoft SQL Server Express Edition this is often <computername>\SQLEXPRESS. (note the BACKSLASH (\). A regular slash (/) will NOT work). A shorthand version is to type .\SQLEXPRESS.
5. Choose connection options
   
   Windows authentication - choose this option to access the server as the logged in windows user. This is the prefered and best method for using a database installed on the same machine as Helium Music Manager.
   
   SQL Server authentication - choose this option to access the server with user name and password. This method is best for accessing a database server installed on a different machine than Helium Music Manager. This is only recommended for experienced users.
   
6. Click the Refresh button to get a list of databases already created on the server. Enter the name of the database you want to create in the Database name edit box. Make sure that no database with the same name already exists.
7. Click the OK button.

Helium Music Manager will now create and connect to the new Microsoft SQL Server database.