Page History

You can install the the  IDERA Dashboard and SQLSafe 8.4 5 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 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.

...

1. Run SQL Safe installer.
2. Before you begin, the SQL Safe wizard displays information about what is needed to complete the installation successfully.
3. Click Next and select a setup type to get started.
   1. The  Full setup installs the SQL Safe Backup and the IDERA Dashboard.
   2. The  Custom setup allows you to specify the components that you would like to install.

4. Click Next.

Anchor
Full Setup Full Setup

Full Setup

If you select to install the full setup, the SQL Safe Backup and the IDERA Dashboard components are installed.

The 

• SQL Safe Management Console
• SQL Safe Repository Database
• SQL Safe Backup Service
• SQL Safe Filter Service
• SQL Safe OLR Service
• SQL Safe Collection Service
• SQL Safe Rest Service

The 

• IDERA Dashboard Repository Database
• Dashboard Core Service
• IDERA Dashboard Web Application Service 

1. Review the license agreement. To accept this license agreement, select the I accept the terms and conditions checkbox. Click Next.
2. Specify the Destination Folder where you want to install the SQL Safe Backup and IDERA Dashboard. Specify different path for each one. Click Next.
3. Specify the SQL Server Instance, Database Name, and Authentication you want to use for the SQL Safe Repository and IDERA Dashboard Repository.
   By default, the Windows Authentication is selected. If you want to use the 

...

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.

   Tip
   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 save.
   Before you continue, you can Test Connections to make sure the SQL Server instance is connected. Then, click Next.
4. Specify the Service AccountsAccount 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.

   Tip
   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.

   the SQL Safe Backup and IDERA Dashboard services will run under.
5. Specify the account to be used by the SQL Safe Backup Management Service to connect to the SQL Safe Backup Repository Database.
   By default, the Windows account specified on the previous step is selected. If you want to use the Microsoft SQL Server authentication to connect your Management Service to the SQL Safe Repository Database, click Change to Authentication, select this option and specify the respective SQL Sever login credentials, and click 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.

...

1. Once SQL Safe is ready to install, review the settings you selected and click Install. If you want to edit your settings, select back and make your changes.
2. If not already available on the system, the Microsoft SQL Server 2012 Native Client installation is requested. Follow the wizard steps and the program will be installed.
3. When the SQL Safe installation completes, you can either:
   • Open the IDERA Dashboard through the URL https://localhost:9291 from a web browser.
   • Configure the Firewall.
   • Launch the SQL Safe Management Console.
   • Click Finish.

Anchor
Custom Setup Custom Setup

Custom Setup

If you select to install the custom setup, you can specify the components that you would like to install.

• IDERA Dashboard
• SQL Safe Backup
• SQL Safe Agent Components

• SQL Safe Management Console and SQL Safe Agent Components

• IDERA Dashboard and SQL Safe Backup
• IDERA Dashboard and SQL Safe Agent Components
• IDERA Dashboard, SQL Safe Management Console, and SQL Safe Agent Components

Anchor
Onlydashboard Onlydashboard

...

Installing only the IDERA Dashboard

If you select you only want to only install the IDERA Dashboard, provide the following information:install the IDERA Dashboard, then follow these steps:

1. In the installation wizard, select IDERA Dashboard.
2. Review the license agreement. To accept this license agreement, select the I accept the terms and conditions checkbox. Click Next.
3. Specify the Destination Folder where you want to install the IDERA Dashboard. Click Next. 
4. Determine the name and location ( SQL Server instance) of the Repository Database for the IDERA Dashboard. Instance, Database Name, and Authentication you want to use for the IDERA Dashboard Repository.
   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. Save.
   Before you continue, you can Test Connections to make sure the SQL Server instance is connected. Then, click Next
5. Specify the Service AccountAccounts 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.
6. 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
7. When you are ready to install the IDERA Dashboard, click Install.
8. When the installation completes, click Finish.

...

1. under.
2. Once IDERA Dashboard is ready to install, review the settings you selected and click Install. If you want to edit your settings, select back and make your changes.
3. When the installation completes, you can either:
   • Open the IDERA Dashboard through the link https://localhost:9291.
   • Configure the Firewall.
   • Click Finish.

Anchor
Onlysafe Onlysafe

Installing only the SQL Safe Backup Components

If you already have the IDERA Dashboard installed

...

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

1. In the installation wizard, select SQL Safe All components.select SQL Safe Backup.
2. Review the license agreement. To accept this license agreement, select the I accept the terms and conditions checkbox. Click Next.
3. Determine if you are going to register SQL Safe with an existing IDERA Dashboard.
   By default, the option Yes is selected. SQL 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 number of this server. Type administrator credentials to access this Dashboard and click click Next.
   

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

   Tip
   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."

5. 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.

6. 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.

   Tip
   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.

7. 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. 
8. 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.
9. 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.
10. Once you are ready to install, click Install. 
11. When the installation completes, click Finish.

...

1. If you select No, then proceed to the next step.
2. Specify the Destination Folder where you want to install the SQL Safe Backup application. Click Next.
3. Specify the SQL Server Instance, Database Name, and Authentication you want to use for the SQL Safe Backup Repository.
   By default, the Windows Authentication is selected. If you want to use the Microsoft SQL Server Authentication, select this option and specify the login name and password for this account, and click save.
   Before you continue, you can Test Connections to make sure the SQL Server instance is connected. Then, click Next.
4. Specify the Service Account under which the SQL Safe Backup and IDERA Dashboard will run under.
5. Specify the account to be used by the SQL Safe Backup Management Service to connect to the SQL Safe Backup Repository Database.
   By default, the Windows account specified on the previous step is selected. If you want to use the Microsoft SQL Server Authentication, select this option and specify the respective SQL Sever login credentials, and click Next.
6. Once SQL Safe is ready to installl, review the settings you selected and click Install. If you want to edit your settings, select back and make your changes.
7. If not already available on the system, the Microsoft SQL Server 2012 Native Client installation is requested. Follow the wizard steps and the program will be installed.
8. When the installation completes, you can either:
   
   • Go to the Start Menu: select IDERA - SQL Safe Management Console.
   • Configure the Firewall.
   • Launch the SQL Safe Management Console.
   • Click Finish.

Anchor
Onlyagents Onlyagents

Installing only the SQL Safe Agent Components

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

1. In the installation wizard, select SQL Safe Agent Components.
2. Review the license agreement. To accept this license agreement, select the I accept the terms and conditions checkbox. Click Next.
3. Specify the Destination Folder where you want to install the SQL Safe Backup Agent application. Click Next.
4. Specify the Service Account under which the SQL Safe Backup and IDERA Dashboard will run under.
   
5. Specify the name of the server that hosts the SQL Safe Management Service.
   
6. Once SQL Safe is ready to install, review the settings you selected and click Install. If you want to edit your settings, select back and make your changes.
7. If not already available on the system, the Microsoft SQL Server 2012 Native Client installation is requested. Follow the wizard steps and the program will be installed.
   
8. When the installation completes, you can either:
   
   • Configure the Firewall.
   • Click Finish.

Anchor
onlyconsoleandagent onlyconsoleandagent

Installing only the SQL Safe Management Console and SQL Safe Agent Components

If you only want to install the SQL Safe Management Console and SQL Safe Agent Components on your SQL Server Instances, then follow these steps:

1. In the installation wizard, select theSQL Safe Management Console and SQL Safe Agent Components.
2. Review the license agreement. To accept this license agreement, select the I accept the terms and conditions checkbox. Click Next.
3. Specify the Destination Folder where you want to install the SQL Safe Backup application. Click Next.
4. Specify the name of the server that hosts the SQL Safe Management Service.
5. Once theSQL Safe Management Console and SQL Safe Agent Components are ready to install, review the settings you selected and click Install. If you want to edit your settings, select back and make your changes.
6. If not already available on the system, the Microsoft SQL Server 2012 Native Client installation is requested. Follow the wizard steps and the program will be installed.
7. When the installation completes, you can either:
   
   • Go to the Start Menu: select IDERA - SQL Safe Management Console.
   • Configure the Firewall.
   • Launch the SQL Safe Management Console.
   • Click Finish.

Anchor
dashboardandsafebackup dashboardandsafebackup

Installing the IDERA Dashboard and SQL Safe Backup Components

If you want to install the IDERA Dashboard and the SQL Safe Backup components, then follow the Full setup steps.

Anchor
dashboardandagents dashboardandagents

Installing the IDERA Dashboard and SQL Safe Agent Components

If you want to install the IDERA Dashboard and the SQL Safe Agent Components on your SQL Server Instances, then follow these steps:

1. In the installation wizard, select IDERA Dashboard and SQL Safe Agent Components.
2. Review the license agreement. To accept this license agreement, select the I accept the terms and conditions checkbox. Click Next.
3. Specify the Destination Folder where you want to install the SQL Safe Backup and  IDERA Dashboard. Specify different path for each one. Click Next.
   
4. Specify the SQL Server Instance, Database Name, and Authentication you want to use for the IDERA Dashboard Repository.
   By default, the Windows Authentication is selected. If you want to use the Microsoft SQL Server Authentication, select this option and specify the login name and password for this account, and click save.
   Before you continue, you can Test Connections to make sure the SQL Server instance is connected. Then, click Next.
5. Specify the Service Account under which the SQL Safe Backup and IDERA Dashboard will run under.
6. Specify the name of the server that hosts the SQL Safe Management Service.
7. Once the IDERA Dashboard and SQL Safe Agent Components are ready to install, review the settings you selected and click Install. If you want to edit your settings, select back and make your changes.
8. When the installation completes, you can either:
   
   • Open the IDERA Dashboard through the link https://localhost:9291.
     
   • Configure the Firewall.
   • Click Finish.

Anchor
dashboardconsoleagent dashboardconsoleagent

Installing the IDERA Dashboard, SQL Safe Management Console, and SQL Safe Agent Components

If you want to install the IDERA Dashboard, the SQL Safe Management Consosle, and the SQL Safe Agent Components on your SQL Server Instances, then follow these steps:

1. In the installation wizard, select IDERA Dashboard, SQL Safe Management Console, and SQL Safe Agent Components.
2. Review the license agreement. To accept this license agreement, select the I accept the terms and conditions checkbox. Click Next.
3. Specify the Destination Folder where you want to install the SQL Safe Backup and  IDERA Dashboard. Specify different path for each one. Click Next.
4. Specify the SQL Server Instance, Database Name, and Authentication you want to use for the IDERA Dashboard Repository.
   By default, the Windows Authentication is selected. If you want to use the Microsoft SQL Server Authentication, select this option and specify the login name and password for this account, and click save.
   Before you continue, you can Test Connections to make sure the SQL Server instance is connected. Then, click Next.
5. Specify the Service Account under which the SQL Safe Backup and IDERA Dashboard will run under.
6. Specify the name of the server that hosts the SQL Safe Management Service.
7. Once the IDERA Dashboard, the SQL Safe Management Consosle, and the SQL Safe Agent Components are ready to install, review the settings you selected and click Install. If you want to edit your settings, select back and make your changes.
8. If not already available on the system, the Microsoft SQL Server 2012 Native Client installation is requested. Follow the wizard steps and the program will be installed.
9. When the installation completes, you can either:
   

...

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 
   • Go to the Start Menu: select IDERA - SQL Safe Management Console.
   • Open the IDERA Dashboard through the URL https://localhost:9291 from a web browser.
   • Configure the Firewall.
   • Launch the SQL Safe Management Console.
   • Click 
   • Finish.

Accessing SQL Safe with IDERA Dashboard 

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

Logging into the Web Application

 To log into into SQL Safe 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 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  to find out more information).

...