Installing SQL Safe on IDERA Dashboard

You can install the IDERA Dashboard and SQLSafe 8.4 on any computer that meets or exceeds the product requirements.

Review the following sections before your installation:

• Product Components and Architecture
• Hardware Requirements
• Permission Requirements
• Software Requirements
• TSM Requirements

Installing SQL Safe

1. Log on with an administrator account to the computer on which you want to install SQLSafe.
2. Run Setup.exe in the root of the installation kit.
3. Click All Components under the Install option.
4. Click Next on the Welcome window of the setup program.

5. Review the license agreement. To accept this license agreement, select the I accept the terms and conditions checkbox, and click Next.

6. Select the components you want to install: IDERA Dashboard, SQL Safe All Components, and/or SQL Safe Backup Agent Only.

   1. If you selected the IDERA Dashboard option and the SQL Safe All Components option, proceed to the Installing the IDERA Dashboard and SQL Safe section below.

   2. If you selected the IDERA Dashboard option only, proceed to the Installing only the IDERA Dashboard section below.

   3. If you selected the SQL Safe All Components option only, proceed to the Installing only SQL Safe components section below.

   4. If you selected the SQL Safe Backup Agent Only option only, proceed to the Installing only SQL Safe Backup Agent section below.

7. Click Next.

Installing the IDERA Dashboard and SQL Safe

If you select to install the IDERA Dashboard and SQL Safe All Components, continue with the following steps:

1. Specify whether you want to install the Dashboard on a local or remote server.
   
   • If you select to install the Dashboard Locally, the installation wizard displays the localhost and port 9292 by default. 
   • If you select to register on a remote server, specify the HostName and port where the IDERA Dashboard currently resides and the respective credentials to access this server.

2. Determine the installation folder. You can specify different paths for the IDERA Dashboard and the SQL Safe application. Type the Display Name for your SQL Safe installation and click Next.

   Unique display names help you distinguish different instances of the same product if you have multiple installs. Use display names that refer to location or functionality, such as "SQLSafeWest" or "SQLSafeProd."

3. Determine the names and locations (SQL Server instances) of the Repository Databases for the IDERA Dashboard and SQL Safe. By default, the setup program uses your Windows Credentials to create these Databases. If you want to use Microsoft SQL Server Authentication, select this option and specify the login name and password for this account, and click Next.

4. Specify the Service Accounts under which the IDERA Dashboard, the SQL Safe Backup Agent, and the SQL Safe Management services will run. The "Log on as a service" right will be granted to these accounts. Click Next.

   If you are using the same account for all services, check the option Use the same account for all services to avoid typing the credentials several times.

5. If you want to use SQL Server authentication to connect your Management Service to the SQL Safe Repository Database, click Change to specify the respective SQL Sever login credentials, and click Next.

6. Specify the ports to be used for each service. If the Firewall is enabled, make sure it allows TCP traffic through these ports. By default, the following ports are used:

   • Idera Dashboard Core Services Port: 9292.
   • Idera Dashboard Web Application Service Port: 9290
   • Idera Dashboard Web Application Monitor Port:9094
   • Idera Dashboard Web Application SSL Port: 9291
   • Idera SQL Safe Rest Services Port: 9998
   • Idera SQL Safe Collection Service Port: 9299
     
7. Specify whether you want to install SQL Safe Extended Stored Procedures. The SQL Safe XSP extend the Backup Agent, allowing you to integrate SQL Safe backup operations with existing T-SQL scripts. If you want to install them, define the credentials that will be used to create SQL Safe Extended Stored Procedures. You can always deploy this feature at a later time. Click Next.
8. Determine your backup storage location. You can determine a specific location for each Backup Agent computer or specify an UNC path (\\server\share) to use a central location for all backups, click Browse to search for your storage location. Take into account that the Backup Agent service account should have read and write permissions to access the specified locations. Click Next.
9. Once SQL Safe is ready to install, click Install. 
10. When the installation completes, click Finish.

Installing only the IDERA Dashboard

If you select to only install the IDERA Dashboard, provide the following information:

1. Specify the Destination Folder where you want to install the IDERA Dashboard. Click Next. 
2. Determine the name and location (SQL Server instance) of the Repository Database for the IDERA Dashboard. By default, the setup program uses your Windows credentials to create this Database. If you want to use Microsoft SQL Server Authentication, select this option, then specify the login name and password for this account. Click Next. 
3. Specify the Service Account under which the IDERA Dashboard services will run. The "Log on as a service" right will be granted to this account. You can later log into the IDERA Dashboard to create additional users. Click Next.
4. Specify the ports to be used by IDERA Dashboard Services. If the Firewall is enabled, make sure it allows TCP traffic through these ports. By default, the following ports are used:
   • Idera Dashboard Core Services Port: 9292
   • Idera Dashboard Web Application Service Port: 9290
   • Idera Dashboard Web Application Monitor Port: 9094
   • Idera Dashboard Web Application SSL Port: 9291
5. When you are ready to install the IDERA Dashboard, click Install.
6. When the installation completes, click Finish.

Installing only SQL Safe components

If you already have the IDERA Dashboard installed elsewhere and you only want to install the SQL Safe components, then follow these steps:

1. In the installation wizard, select SQL Safe All components.
2. SQL Safe automatically detects if you have a local IDERA Dashboard installed in your computer. If your IDERA Dashboard is located on a remote server, then specify the HostName and Port of this server. Type administrator credentials to access this Dashboard and click Next.

3. Specify the destination folder where SQL Safe components will be installed, provide a name for your SQL Safe installation, and click Next.

   Unique display names help you distinguish different instances of the same product if you have multiple installs. Use display names that refer to location or functionality, such as "SQLSafeWest" or "SQLSafeProd."

4. Determine the location (SQL Server instance) and the name of the Repository Database. By default, IDERA uses Windows credentials to create the repository, but if you want to use SQL Sever authentication, select the respective option and specify these credentials, and click Next.

5. Specify the Service Accounts to be used by the SQL Safe Backup Agent and the SQL Safe Management Service. These accounts are granted with the "Log on as a service" rights. You can use them to log into the IDERA Dashboard and the SQL Safe web application. Click Next.

   If you are using the same account for all services, check the option Use the same account for all services to avoid typing the credentials several times.

6. By default, the SQL Safe Management Service uses Windows credentials. If you want to use SQL Server authentication, select this option and specify the respective credentials. 
7. Specify whether you want to install SQL Safe Extended Stored Procedures. The SQL Safe XSP extend the Backup Agent, allowing to integrate SQL Safe backup operations with existing T-SQL scripts. By default, Extended Stored Procedures will be created using Windows credentials. If you want to use SQL Server authentication, select this option and specify the respective credentials. You can always deploy this feature at a later time. Click Next.
8. Define your backup storage location. You can determine a specific location for each Backup Agent computer or specify a UNCpath (\\server\share) to use a central location for all backups. Take into account that the Backup Agent service account should have read and write permissions to access the specified locations. Click Next.
9. Once you are ready to install, click Install. 
10. When the installation completes, click Finish.

Installing only SQL Safe Backup Agent 

If you only want to install the SQL Safe Backup Agent on your SQL Server instance, then follow these steps:

1. Select SQLSafe Backup Agent only in your installation wizard. Click Next.
2. Specify the Destination Folder where you want to install the SQL Safe Backup Agent and click Next.
3. Determine the Service Account to be used by the SQL Safe Backup Agent service. The "Log on as a service" is granted to this account. 
4. Specify whether you want to install SQL Safe Extended Stored Procedures. The SQL Safe XSP extend the Backup Agent, allowing to integrate SQL Safe backup operations with existing T-SQL scripts. You can always deploy this at a later time. By default, the Extended Stored Procedures will be created using Windows credentials. If you want to use SQL Server authentication, select this option, specify the respective credentials, and click Next.
5. Once you are ready to install, click Install. 
6. When the installation completes, click Finish.
   

Accessing SQL Safe with IDERA Dashboard

To access the IDERA Dashboard, type the following URL into your browser: http://localhost:9290 or the port you specified.

Logging into the Web Application

 To log into SQL Safe web application you can use one of the following alternatives.

• Type an account with permissions to access SQL Safe (the account you provided at installation for example).
• Select Log on using Windows credentials to use Windows integrated authentication and bypass the login process. (You may need to configure your browser for this option, go to Configuring your browser for Windows Authentication to find out more information).