Create new Microsoft SQL Server Database

Introduction

With this dialog you can create a new Microsoft SQL Server/SQL Server Express Edition database.
See the section Helium Music Manager with Microsoft SQL Server for more information.

Creating a new Microsoft SQL Server Database

1. Enter the server name in the first edit box. Generally you should enter <computername>\<instancename> in this box. For Microsoft SQL Server Express Edition this is often <computername>\SQLEXPRESS. (note the BACKSLASH (\). A regular slash (/) won't work). Click the Get Name button to automatically fill the Server Name edit box with the name of your computer.

2. Choose connection options

   1. Windows authentication choose this option to access the server as the logged in windows user, better for access to a database installed on the same machine as Helium Music manager.

   2. SQL Server authentication choose this option to access the server with user name and password, better for access to a database server installed on a different machine than Helium Music Manager.

3. Enter the name of the database you want to create in the second edit box. Click the Refresh button to get a list of databases already created on the server so you don't try to create a database that already exist.

4. Click the OK button. Helium Music Manager will now create and connect to the new database.

For more information look at the section Installing And Connecting To A Microsoft SQL Server 2005 Express Edition Database.