Page History
In order to monitor a BI Service, access its details, and add it to your monitored environment, you need to register it with SQL BI Manager. This section helps you register one or more BI Service instances with SQL BI Manager.
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Take into consideration the following notes before adding instances to BI Manager: SSRS: You can only add one instance at a time for SSRS when it's a stand alone instance. You can only add multiple SSRS instances if you are registering a scale-out implementation. To register SSRS instances that are part of a scale-out deployment refer to Adding SSRS Scale-out instances . SSAS: To register SSAS instances installed on a clustered environment you must use the "virtual server name" (network name). The use of an instance name is not supported. Because clustered instances always run on port 2383, specifying an instance name is not required. SSIS: In order to view execution history and details for packages, when executing packages logging must be turned on. If logging is not turned on for package execution, there will not be any information displayed in the Activity section. |
Access the Add Instance Wizard
You can access the the Add Instance wizard wizard from the Welcome Wizard , when the first time you first log in to the IDERA Dashboard after installation. You can also find the Add BI Service option in the Administration view.Additionally, you can register specific BI Service Intances from the SSAS, SSRS, or SSIS tabs. For example, while in the SSAS tab, click the Add SSAS Instance option displayed above the Instances list, this option opens the Add Instance Wizard and allows you to add a SSAS instance.
To add a BI Instance follow these steps:
1. Specify the Instance
...
Select a BI service you want to add, in
...
In the BI Instance Name field, type the name of the instance or instances where the BI Services you want to monitor are hosted. Use a semicolon to separate instances. Then select the service for the instance(s) to be monitored. You can only select one service for the instance(s) (SSAS, SSIS, SSRS). If there are multiple services on an instance then register the instance for each service to be monitored.
You can use the Browse button to access a list of discovered instances that have not been registered yet with SQL BI Manager. Select the BI instances you want to add and click Apply.
By default, all BI Services are enabled in the Add Instance Wizard when registering a BI Instance. Deselect the BI Services you do not want to monitor in the specified Instances.
Alternatively, the Import button allows you to import a list of BI instances to be monitored by SQL BI Manager .
Click Upload to choose a .csv file to import and s s elect the instances you want to import.
Note: When you select SSRS you need to specify the location of the SSRS ReportServer database and the Reporting Service Database name.
2. Specify Credentials
SQL BI Manager connects to registered SQL Server BI instances and their host computers to collect information. The collection service requires permissions to connect and gather information using the following types of connections:
- SQL connection credentials: To perform queries on registered instances.
- WMI connection credentials: To gather data from the host computers.
By default, SQL BI Manager connects using the SQL BI Manager Service Account. However, if you need to provide alternative credentials for any of these two connections, you can choose from the respective options on each section.
- SQL Connection Credentials: Specify the type of account that you want to use to access your SQL Server BI instance and collect its information. If you do not want to use the the SQL BI service account , you can choose to use a a Windows user account or a or a SQL Server login account from the from the Account Type list.
If you select a Windows user account or SQL Server login account, type the respective user name and password. - WMI Connection Credentials: On this section, you can choose to use the SQL BI service account or or a Windows user account by by selecting either of them from the Account Type listlist.
If you choose to use a Windows user account , type the respective user name and password.
Use the the Test Credentials option to verify that SQL BI Manager can gather data for instances and host computers.
...
On this section, you can review your Instance Registration Details such as: Instance name, SQL Connection Credentials, WMI Connection Credentials, and monitored BI services.
To change registration details you can:
...
After you review your registration details click FINISH.
SQL Business Intelligence Manager identifies issues within the SQL BI environment to help optimize BI service performance. Learn more > >
...