Documentation for Intellect 4.11.0-4.11.3. Documentation for other versions of Intellect is available too.

Previous page Selecting an Access database and setting up the connection  Connecting to the Events Log (PROTOCOL table) Next page


This section describes the connection to a Microsoft SQL database as the main Intellect database.

To connect a Microsoft SQL database, open the Data Link Properties window. To set the main database in Microsoft SQL format, do the following:

  1. Select the Microsoft OLE DB Provider for SQL Server line in the Provider tab and click the Next button or move to the Connection tab.
  2. Specify the name of the database SQL server in the Connection tab. This can be done using the Select or Enter a Server Name field.
    To enter the SQL server name, do one of the following:
    1. manually enter the name of the SQL server of the main Intellect database in the Select or Enter a Server Name field.

    2. select the SQL server in the drop-down list of all available SQL servers. The list opens by clicking the  button.

      Note.

      By default, the local server is selected named <local>\SQLEXPRESS.

      Note.

      To refresh the list of available servers, click the Refresh button next to the list field.
  3. Specify the authorization parameters for logging onto the SQL server. The following options are available:

    1. The Use Windows NT Integrated Security radio-button. The Windows login information is used for authorization on the SQL server.

      Note.

      Used mostly to connect to the local SQL server.
    2. The Use Specific User name and Password radio-button. The specific user name and password are used to connect to the SQL server.

  4. When the Use Specific User name and Password radio-button is selected, enter the information into the following fields: User Name and Password.

    Note.

    By default, the following information is set up during Intellect software installation: user name “sa”, password “axxonsoft” (see the  Installing INTELLECT™ software section).

    Note.

    By default while installing the Intellect complex, the user(login) «sa»  and Administrator password SQL Server (is registered while installing SQL Server, see  Installing INTELLECT™ software) are set for authorization on SQL server
  5. When the Use Specific User name and Password radio-button is selected, the Blank Password and Allow Saving Password checkboxes become enabled.

    The Blank Password checkbox allows to enable connection to the SQL server with no password.
    The Allow Saving Password button saves the password for the next connection to the SQL server.

  6. Select the database to be used as main in the Select the Database on the Server drop-down list. To open the list of available databases on the SQL server, click the  button.

    Note.

    If necessary, the name of the database to connect to can be entered in the Attach Database File as Database Name field, or in the Using the Filename field.

  7. Test the connection to the SQL server by clicking the Test Connection button.

    The information box showing the message "Test connection succeeded” will appear in case of successful connection.

    An information box with the error description will appear in case of connection error.

    Note.

     In case of connection errors, check the connection parameters in the Provider and Connection tabs.
  8. In case of a successful test, confirm the database change by clicking the OK button.

This completes the selection of the main database in Microsoft SQL format. The information from the selected database is now loaded into the Report system.

  • No labels