Version
Diagram Step 2.png

Microsoft SQL Server

To configure a Microsoft SQL Server Data Source, you will need to enter the following information:

EnterSQLServerdetails_Desktop

  1. Data Source Name: this field will be displayed in the Data Sources list.

  2. Server Hostname: the computer name or IP address assigned to the computer on which the server is running.

You can find your Hostname information by following the steps below. Please note that the commands should be executed on the server.

WINDOWS LINUX MAC

1. Open the File Explorer.

1. Open a Terminal.

1. Open System Preferences.

2. Right Click on My Computer > Properties.

2. Type in $hostname

2. Navigate to the Sharing Section.

Your Hostname will appear as "Computer Name" under the Computer name, domain and workgroups settings section.

Your Hostname will appear along with your DNS domain name. Make sure you only include Hostname in ReportPlus.

Your Hostname will be listed under the "Computer Name" field on top.

You can find your IP address by following the steps below. Please note that the commands should be executed on the server.

WINDOWS LINUX MAC

1. Open a Command Prompt.

1. Open a Terminal.

1. Launch your Network app.

2. Type in ipconfig

2. Type in $ /bin/ifconfig

2. Select your connection.

IPv4 Address is your IP address.

Inet addr is your IP address.

The IP Address field will have the necessary information.

  1. Port: if applicable, the server port details. If no information is entered, ReportPlus will connect to the port in the hint text (1433) by default.

  2. Database Name. This is an optional setting that you can set if you want this data connection to be for a specific database on the server. To find your database name, open up an SQL query in the Server Management Studio and enter DB_Name([database_id]). If you leave this setting empty, your connection will allow you to browse and connect to any databases on this server.

  3. Account: after clicking Next, a new dialog will be displayed. You can either enter new credentials for Microsoft SQL Server or select existing ones if applicable.

Advanced Configuration: Caching the Tables

Once you create your SQL data source, you can check the "Preload data in memory" box in the Parameters section to store retrieved data, so future requests for it can be served faster.

MSSQLParameters_Desktop

This will cache the table you selected to create your widget, not the entire database.