Page History
...
- Select the type of server you want to audit. Available options include:
- On-Premise SQL Server
- SQL Server on Azure Virtual Machine
- Azure SQL Database
- SQL Server on Amazon EC2
- Amazon RDS for SQL Server
- Type the name of the instance you would like to audit. IDERA SQL Secure supports multi-part server fully qualified domain names entered in the following format: name.server.secure.database.net
or click the ellipsis button
to access a list of monitored SQL Servers in your domain, browse to locate your respective instance, then click OK to add it. This feature is not available when working with Azure and Amazon VMs or databases. - Specify the port number, the default port number (1433) or set the port number you configured on the Instance you are registering.
- SQL Secure includes two registration options to secure connectivity between client and server, available for all server types:
- Encrypt connection: Need the same certificate to be installed on the client and server machines. For more information click
.Newtab2 alias here url https://docs.microsoft.com/en-us/sql/relational-databases/native-client/features/using-encryption-without-validation?view=sql-server-2017&viewFallbackFrom=sql-server-2017.
| Info |
|---|
To certificate is created on the server machine once Encrypt Connection option is selected on SQL Server, you can export and import the certificate to the client machine. |
- Trust Server Certificate: When user selects this option do not need any certificate to continue with the registration.
- Click Next to go to the following section and Specify your connection credentials.
...