Open a Microsoft SQL Server Database

Introduction

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

Opening a 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. Click the Refresh button to connect to the database server and get a list of all existing databases on the database server. create a database that already exist.

4. Select the database you would like to open from the list

5. Click the OK button. Helium Music Manager will now connect to the selected database.

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