
To configure a Microsoft SQL Server Data Source, you will need to enter the following information:
Data Source Name: this field will be displayed in the Data Sources list.
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.
You can find your IP address by following the steps below. Please note that the commands should be executed on the server.
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.
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.
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.
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.
This will cache the table you selected to create your widget, not the entire database.