Page History

This procedure guides you through the installation of the IDERA Dashboard and SQL Diagnostic Manager 10.2.

...

You can install the IDERA Dashboard and SQL Diagnostic Manager 10.2 on any computer that meets or exceeds the product requirements.

...

1. Log on with an administrator account to the computer on which you want to install SQL Diagnostic Manager.
2. Run Setup.exe in the root of the installation kit.
3. Click Install SQL Diagnostic Manager on the Quick Start window.
4. On the Welcome window of the setup program, click Next.
   Image Removed
5. Review the license agreement. To accept this license agreement, click I accept the terms and conditions of this License Agreement and then click Next.
   Image Added
   

6. Choose the components you want to install by selecting the respective check boxes. By default, the setup program installs SQL DMSQLDM, and SQL DM SQLDM Repository and Services, allowing you to immediately begin monitoring your SQL Server environment. Select the IDERA Dashboard checkbox if you want a complete installation.
   

   Info
   By default, the Management Service, Collection Service, Predictive Service, and Predictive Rest Service are installed on the local computer where you are running the setup program.

7. Click Next.
   

Select a Windows user account to use for the service account

...

1. On the Service Account window, type appropriate credentials in the provided fields under which the services run.
2. Click Next. SQL Diagnostic Manager verifies the connection before continuing.

...

Select service ports to use for the IDERA Dashboard

The IDERA Dashboard uses ports 9094, 9290, 9291, and 9292 for the web application and dashboard services respectively. However, you can specify different service ports.

To specify a service port:

1. On the Service Ports window, specify the ports you want the web application and dashboard services to use.
   Image Added
2. Verify that the Firewall allows TCP (Transmission Control Protocol) traffic through your specified ports.
3. Click Next.

Select a SQL Server instance to use for the IDERA Dashboard Repository database

...

1. On the Repository Database screen, specify the host SQL Server instance you want to use for the IDERA Dashboard Repository database.
2. Type the name for the IDERA Dashboard Repository database.
    
    

3. If your SQL Server environment uses SQL Server Authentication, select the respective check box and click Change to enter SQL Server credentials. By default, the IDERA Dashboard uses your Windows credentials when connecting to the Repository database.

   Info
   If you use Microsoft SQL Server Authentication, a new window displays where you can type the respective SQL Server login and password.

4. Click Next.
   

...

1. Type the host name and instance in the space provided.
   
   
2. If your SQL Server environment uses SQL Server Authentication, select the respective check box and click Change to enter SQL Server credentials. By default, SQL Diagnostic Manager uses your Windows credentials when connecting to the Repository.
   
3. If want the SQL Diagnostic Management Service to use SQL Server Authentication , select the respective check box and click Change to enter SQL Server credentials. By default, SQL Diagnostic Manager uses your Windows credentials when connecting to the Repository.  
4. Click Next.

...

Select an installation location and type a display name for your instance

You can use the default install location or specify a different path. For your first install, we recommend using the default location. On the Display Name text box, type a unique name for your SQLDM instance. The display name helps you to distinguish different instances of the same product. Click Next to continue with the installation.

Image RemovedImage Added

Complete the install

The setup will grant the provided accounts access to SQL Diagnostic Manager and the IDERA Dashboard. The user that installs the IDERA Dashboard has access to this application by default as a Dashboard Administrator. You can choose whether you want other users to have access to the IDERA Dashboard in the Administration view.  

1. Click Install to indicate that you are ready to complete your installation with the configurations you specified. If you want to review or change any of your settings, click Back.

2. Click Finish to exit the IDERA Dashboard Setup Wizard.

...

The SQL Diagnostic Manager Console automatically launches. To access the IDERA Dashboard and the SQL Diagnostic Manager web console, see Log in the IDERA Dashboard and web console.       

...

SQLDM Mobile includes the IDERA Newsfeed and several dashboard views that define your server health and expose critical alerts. You can access the SQLDM Mobile Web application from most smartphones and mobile devices. The IDERA Newsfeed is a revolutionary new way for DBAs and managers to collaborate, share knowledge, and keep close tabs on your most critical SQL Server issues. With the IDERA Newsfeed, you can quickly share information to stay informed, be more productive and shorten the time to problem resolution. For more information, review the SQLDM Mobile architecture and components, as well as its requirements.