Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note
The installation of SQL Safe Backup fails in scenarios where the Microsoft Visual C++ Redistributable requires Operating System updates.
The following patches are required depending on your Operating System:
  • For Windows 8.1, install KB2999226 which has a pre-requisite of KB2919355.
  • For Windows Server 2012 R2, install KB2919355 which has a pre-requisite of KB2919442.

Installing SQL Safe

  1. Log on with an administrator account to the computer on which you want to install SQLSafeSQL Safe.
  2. Run SQL Safe installer.
  3. Before you begin, the SQL Safe wizard displays information about what is needed to complete the installation successfully.
  4. 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.
  5. Click Next.

...

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

...

  1. Review the license agreement. To accept this license agreement, select the I accept the terms Terms and conditions 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 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 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, select this option and specify the respective SQL Sever login credentials, and click Next.
  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 select Back and make your changes.
  7. If not already available on the system, the Microsoft SQL Server 2012 Native ClientVisual C++ 2015 Update installation is requested. Follow the wizard steps and  Click Install to install the program will be installed.
  8. When the SQL Safe installation completes, you can either:
    • 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 to exit the wizard. 

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.

...

  1. In the installation wizard, select IDERA Dashboard.
  2. Review the license agreement. To accept this license agreement, select the I accept the terms Terms and conditions Conditions checkbox. Click Next.
  3. Specify the Destination Folder where you want to install the IDERA Dashboard. Click Next.
  4. Determine the SQL Server 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 Save.
    Before you continue, you can Test Connections to make sure the SQL Server instance is connected. Then, click Next
  5. Specify the Service Accounts under which the IDERA Dashboard services will run under.
  6. 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 select Back and make your changes.
  7. When the installation completes, you can either:

...

  1. In the installation wizard, select SQL Safe Backup.
  2. Review the license agreement. To accept this license agreement, select the I accept the terms Terms and conditions 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 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 Next.
    If you select No, then proceed to the next step.
  4. Specify the Destination Folder where you want to install the SQL Safe Backup application. Click Next.
  5. 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.
  6. Specify the Service Account under which the SQL Safe Backup and IDERA Dashboard will run under.
  7. 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.
  8. Once SQL Safe is ready to installlinstall, review the settings you selected and click Install. If you want to edit your settings, select back and select Back and make your changes.
  9. If not already available on the system, the Microsoft SQL Server 2012 Native ClientVisual C++ 2015 Update installation is requested. Follow the wizard steps and the program will be installed Click Install to install the program.
  10. When the installation completes, you can either:
    • Go to the 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

...

  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 Terms and conditions 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 select Back and make your changes.
  7. If not already available on the system,  the Microsoft SQL Server 2012 Native Clientthe Microsoft Visual C++ 2015 Update installation is requested. Follow the wizard steps and the program will be installed Click Install to install the program.
  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 Terms and conditions 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 theOnce the SQL 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 select Back and make your changes.
  6. If not already available on the system,  the Microsoft SQL Server 2012 Native Clientthe Microsoft Visual C++ 2015 Update installation is requested. Follow the wizard steps and the program will be installed Click Install to install the program.
  7. When the installation completes, you can either:
    • Go to the the Start Menu: select IDERA - SQL Safe Management Console.
    • Configure the Firewall.
    • Launch the SQL Safe Management Console.
    • Click Finish.

...

  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 Terms and conditions 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  Back and make your changes.
  8. When the installation completes, you can either:

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

...

  1. In the installation wizard, select IDERA DashboardSQL Safe Management Console, and SQL Safe Agent Components.
  2. Review the license agreement. To accept this license agreement, select the I accept the terms Terms and conditions 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 select Back and make your changes.
  8. If not already available on the system,  the Microsoft SQL Server 2012 Native Clientthe Microsoft Visual C++ 2015 Update installation is requested. Follow the wizard steps and  Click Install to install the program will be installed.
  9. When the installation completes, you can either:
    • Go to the 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 Dashboard 

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

Info

The URL used to access the IDERA Dashboard is constructed from the name of the machine on which the IDERA Dashboard was installed and the port specified for the IDERA Dashboard Web Application Service. For example, if the IDERA Dashboard was installed on a machine named MYSERVER and the Idera Dashboard Web Application Service used the default port of 9291, then the URL to access the IDERA Dashboard would be the following: http://MYSERVER:9291

Logging into the Web Application

 To  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 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).

...