Registering a SQL Database

Once you have gone through the first three steps of the wizard you will need to specify the details of the SQL database that you want to register. To do this you should:

  1. Click Build.
    The Data Link Properties screen will open with the Provider tab open at the front of your screen.
  2. Select Microsoft OLE DB Provider for SQL Server from the list of OLE DB Providers.
  3. Click Next.
    The Connection tab will come to the front of your screen. On the Connection Tab:
  4. From the drop-down list, select the server name on which the database is installed. At this point you will select the SQL Authentication mode you have chosen forpayroll.
  5. Select the Database on the Server and then select the database from the drop-down list.
  6. Click Test Connection.
    A message will appear informing you if the test was successful and you have connected the database.

SQL databases should be already configured by your IT department on the server. If the test is unsuccessful or the database is not listed, please refer to your IT department for assistance.

  1. If the test was successful, click OK to save the settings.
    You will return to the Database Connections Wizard and the SQL Server Connection Details screen.
  2. Enter the Alias that will identify this database on the login screen.
  3. Click Next.
    You will receive a message informing you that the database has been successfully connected.

Related Topics Link IconRelated Topics