Configuring database source: Microsoft SQL Server

To configure MS SQL Server your database source:

1. Click on the Options navigation button.

2. Right-click on the Database Source node and select Set Database Source… This will bring up the database source configuration dialog.

Screenshot 44 - Database source configuration dialog: SQL Server

3. Select ‘MS SQL Server’ as the database type from the provided list of supported databases.

4. Specify the name or IP address of your MSDE/MS SQL Server database backend.

5. To use the credentials of an SQL Server account, select the ‘Use SQL Server authentication’ option and specify the user name and password in the provided fields.

NOTE: By default, the GFI LANguard N.S.S. ReportPack uses Windows logon credentials to authenticate to the SQL Server.

6. Click on OK to finalize your configuration settings.