Page History
The Specify Connection Credentials section of this wizard allows you to designate the credentials that IDERA SQL Secure will use to access the instance containing the SQL Server instance or Azure SQL databases you are adding. When adding whether the a SQL Server instance is running private network or public cloud such as Azure VM, Azure SQL Databases, Amazon EC2 or Amazon RDS. You have to specify credentials according the type of server you want to register:
On-Premise SQL Server
, you can specify either SQL Server login or Windows account credentials. When adding an Azure SQL database, specify either the SQL Server login or Azure Active Directory credentials.
In this section For On-Premise SQL Server servers, you have to specify the following credentials:
...
| Item | Description |
|---|---|
| SQL Server credentials to connect to audited SQL Server |
...
Choose one of the following options:
|
...
| Windows Credentials to gather Operating System and Active Directory objects |
...
| - These credentials are used to connect to the target server to gather Active Directory objects, file, and registry key permissions. | Choose one of the following options:
|
...
...
...
| Azure |
...
On the SQL Server credentials to connect to audited SQL Server, choose one of the following options:
- Select Windows Authentication and enter the credentials in the fields provided.
- Click SQL Server Authentication to use the default credentials of your SQL Server Agent.
...
| Active Directory |
...
| credentials |
...
| to gather Active Directory objects |
...
Choose |
The accounts need Administrator access to the target server.
SQL Server on Amazon EC2
For SQL Servers on Azure Virtual machines, you have to specify the following credentials:
...
one of the following options: |
- Select Windows Authentication and enter the credentials in the fields provided.
- Click SQL Server Authentication to use the default credentials of your SQL Server Agent.
The AWS Directory Service for Microsoft Active Directory to gather Operating System and Active Directory objects section, asks for credentials to connect the target server to gather Active Directory objects and key permissions.
The accounts need Administrator access to the target server.
Azure SQL Database
On the SQL Server credentials to connect to audited SQL Server section, choose one of the following options:
- Select Azure Active Directory and enter the credentials in the fields provided.
- Click SQL Server Authentication to use the default credentials of your SQL Server Agent.
Amazon RDS for SQL Server
On the SQL Server credentials to connect to audited SQL Server section, choose one of the following options:
- Select AWS Directory Service for Micrsoft Active Directory and enter the credentials in the fields provided.
- Click SQL Server Authentication to use the default credentials of your SQL Server Agent.
...
|
| Note | ||
|---|---|---|
| ||
Take into account that if the login configuration for the SQL Server you want to audit is case-sensitive, you must enter your login credentials in the case-sensitive format. |
| Note | ||
|---|---|---|
| ||
You should keep in mind the following permissions for the accounts specified in this section:
|
After you specify your connection credentials, click Next to go to Add server group tags.
| Scroll pdf ignore |
|---|
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |