Versions Compared

Old Version 17

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version Current

changes.mady.by.user Alejandra Rivera

Saved on

Key

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

SQL Safe is ONLY compatible with IDERA Dashboard version 4.6 and with limited support.

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

Info

The Virtual Database product is now integrated to with SQL Safe 8.4. SQL Safe installs VDB at all times. Backup. There is no option to install either product separately.

Note

From 8.5.2 version, you can install SQL Safe without the IDERA Dashboard on Windows 2003 Operating System.

Running the combined installer will display the following message: "The current Operating System is not supported by this product".

Review the following sections before your installation:

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 with a pre-requisite of KB2919355.
  • For Windows Server 2012 R2, install KB2919355 with a pre-requisite of KB2919442.

Installing SQL Safe Backup

  1. Log on with an administrator account to the computer on which where you want to install SQLSafe SQL Safe Backup.
  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.

...

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

  1. Run the SQL Safe Backup installer.
  2. Before you begin, the SQL Safe Backup 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 you would like to install.

  4. Click Next.

Anchor
fullsetup
fullsetup
Full Setup

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

The 

Anchor
sqlsafe
sqlsafe
SQL Safe Backup components:

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

The 

Anchor
dashboard
dashboard
IDERA Dashboard components:

  • IDERA Dashboard Repository Database
  • Dashboard Core Service
  • IDERA Dashboard Web Application Service 
  1. Review the license agreement. To accept it, 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 a 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, Windows Authentication is selected. If
  4. 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.

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

  6. 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 click save.
    Before you continue, Test Connections to make sure the SQL Server instance is connected. Then, click Next.
  7. Specify the Service Accounts under which the IDERA Dashboard, Account under which 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.

    and IDERA Dashboard services will run.
  8. Specify the account that SQL Safe Backup Management Service will use to connect to the SQL Safe Backup Repository Database.
    By default, the Windows Account specified in the previous step is selected. If you want to use 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 Server login credentials, and click click Next.

  9. 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
  10. 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.
  11. 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.
  12. Once SQL Safe is ready to install, click Install. 
  13. When the installation completes, click Finish.

...

  1. Once SQL Safe Backup is ready to install, review the selected settings, and click Install to install the program.
    If you want to edit your settings, select Back and apply your changes.
  2. When the SQL Safe Backup installation completes, you can either:
    • Go to the Start Menu and 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 you would like to install:

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 it, 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 Save.
    Before you continue, 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 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 to install the program.
    If you want to edit your settings, select Back and apply your changes.
  3. When the installation completes, you can either:

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 components Management Components, then follow these steps:

  1. In the installation wizard, select SQL Safe Backup.
  2. Review the license agreement. To accept it, select SQL Safe All components.the I accept the Terms and Conditions checkbox. Click Next.
  3. Determine if you are going to register the SQL Safe Backup with an existing IDERA Dashboard.
    By default, the option Yes is selected. SQL Safe Backup SQL Safe automatically detects if you have a local IDERA Dashboard installed in on 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 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."

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

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

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

Take into account that you should have the latest version of the IDERA Dashboard to install SQL Safe components on it.

...

  1. SQL Server Instance, Database Name, and Authentication you want to use for the SQL Safe Backup Repository.
    By default, Windows Authentication is selected. 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.
  2. Specify the Service Account under which the SQL Safe Backup and IDERA Dashboard will run.
  3. Specify the account that SQL Safe Backup Management Service will use to connect to the SQL Safe Backup Repository Database.
    By default, the Windows account specified in the previous step is selected. If you want to use Microsoft SQL Server Authentication, select this option and specify the respective SQL Server login credentials, and click Next.
  4. Once SQL Safe Backup is ready to install, review the selected settings and click Install to install the program.
    If you want to edit your settings, select Back and apply your changes.
  5. 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 it, 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.
  5. Specify the name of the server that hosts the SQL Safe Management Service.
  6. Once SQL Safe Backup is ready to install, review the selected settings, and click Install to install the program.
    If you want to edit your settings, select Back and apply your changes.
  7. 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 the SQL Safe Management Console and SQL Safe Agent Components.
  2. Review the license agreement. To accept it, 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 the SQL Safe Management Console and SQL Safe Agent Components are ready to install, review the selected settings, and click Install to install the program.
    If you want to edit your settings, select Back and apply your changes.
  6. 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 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 it, select the I accept the Terms and Conditions checkbox. Click Next.
  3. Specify the 

...

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.

...

  1. and  IDERA Dashboard. Specify a different path for each one. Click Next.
  2. Specify the SQL Server Instance, Database Name, and Authentication you want to use for the IDERA Dashboard Repository.
    By default, Windows Authentication is selected. 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.
  3. Specify the Service Account under which the SQL Safe Backup and IDERA Dashboard will run.
  4. Specify the name of the server that hosts the SQL Safe Management Service.
  5. Once the IDERA Dashboard and SQL Safe Agent Components are ready to install, review the selected settings and click Install to install the program.
    If you want to edit your settings, select Back and apply your changes.
  6. When the installation completes, you can either:

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

If you want to install the IDERA Dashboard, SQL Safe Management Console, and 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 it, 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 a 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, Windows Authentication is selected. 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.
  5. Specify the Service Account under which the SQL Safe Backup and IDERA Dashboard will run.
  6. Specify the name of the server that hosts the SQL Safe Management Service.
  7. Once the IDERA Dashboard, SQL Safe Management Console, and SQL Safe Agent Components are ready to install, review the selected settings, and click Install to install the program.
    If you want to edit your settings, select Back and apply your changes.
  8. When the 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.

Accessing SQL Safe Backup with IDERA Dashboard 

To access the IDERA Dashboard, type the following URL into your browser:http https://localhost:92909291 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 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 9290 9291, then the URL to access the IDERA Dashboard would be the following: http://MYSERVER:92909291

Logging into the Web Application

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

  • Type an account with permissions permission to access SQL Safe Backup (the account you provided at installation for example).
  • Select Select Log on using Windows credentialscredentials 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).
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 | 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 | 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 | 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...