Appboard/2.5/admin/configuration database/example mssql

Overview

This document covers an example installation of Microsoft SQL Server for use with AppBoard as an external configuration database.


Installation

These installation instructions apply to SQL Server 2000. To install Microsoft SQL Server:

  1. Select Install SQL Server 2000 Components.
  2. Select Install Database Server. The InstallShield begins.
  3. On the first screen, select Local Install. Click Next or Yes on the following screens until the Setup Type screen opens.
  4. On the Setup Type screen, select Custom and click Next.
  5. On the Select Components screen change or accept the default settings and click Next.
  6. On the Character Set/Sort Order/Unicode Collation screen, in the Sort Order field, select Dictionary Order, Case Sensitive. Keep the other default settings and click Next.
  7. On the Network Libraries screen, accept the defaults and click Next.
  8. On the Services Accounts screen, select Use the same account for each service. Autostart SQL Server Service. For Service Settings, select Use the local system account. Then click Next.
  9. Click Next until you reach the final screen and then click Finish when the installation is complete.

Creating a Database and Configuring Security

To create and configure a Microsoft SQL database, do the following:

  1. From the Windows Start menu, select SQL Server – Enterprise Manager.
  2. Expand SQL Servers.
  3. Expand SQL Server Group.
  4. Expand your host name (to get to the local databases).
  5. Right-click Databases and select New Database.
  6. Enter portal in the Name field and click OK.
  7. Expand Security.
  8. Right-click Logins and select New Login.
  9. Enter portal in the Name field.
  10. Select SQL Server Authentication and enter a password for the portal user.
  11. For Defaults, select portal as the database.
  12. Click the Database Access tab and select portal as the permitted database.
  13. For Database roles for portal select:
    • db_ddladmin
    • db_datareader
    • db_datawriter
  14. Select OK.
  15. Because the default is blank, it is recommended that you change the password for the sa account.
    1. Click Logins.
    2. Right-click sa and select Properties.
    3. Enter a password and click OK.

Configuring Automatic Startup

To configure a Microsoft SQL database for automatic startup:

  1. From the Windows Start menu, select Settings→Control Panel.
  2. Open Services and double-click MSSQLServer.
  3. For Startup Type, ensure that Automatic is selected.
  4. For Log On As, select System Account.
  5. Click OK.