Server address
Enter the IP address, the host name or a combination of the host name and instance name of the SQL Server database server. You can enter the server address or choose from the drop-down list. The list shows the database instances that ibaAnalyzer can reach. Only the registered SQL Server instances are automatically shown on the computer on which ibaAnalyzer is installed. To search for remote database servers on the network, use the <Discover network servers> entry at the end of the drop-down list.
For the server address, you can also specify a port. Separate the port from the server name with a comma. If no port is specified for the server address, the default port 1433 is used.
Example: To connect to port 1488 on server sqlserver.domain, use "sqlserver.domain,1488".
Authentication type
Select the appropriate authentication method here to obtain access to the database. Please consult with your DB administrator to find out which method is the right one and what the log-in information is.
-
Windows authentication: To connect to the SQL Server instance, the user account under which the SQL Server is running is used.
Note |
|
|---|---|
 |
For automated use with ibaDatCoordinator-DB license: When using the local system account, you must grant additional authorizations to the corresponding login NT AUTHORITY\SYSTEM in the SQL Server that are not set up by default. The rights to connect to the database as well as other rights are required to be able to execute the planned SQL statements, such as read rights for queries. Write rights are only required if you use output modules for commands (e.g. UPDATE, INSERT). Clarify with your DB administrator in advance whether the extension of rights is possible or whether a different login or authentication should be selected. |
-
SQL Server authentication: Authentication that is stored in the database. A username and password are required for this purpose.
-
Azure Active Directory - Universal with MFA: Multi-factor authentication, as configured on Azure.
-
Active Directory - Password or Integrated: The authentication methods can be used for members of a user group in the active directory, which has access to the database. A relationship of trust must be established between the user and their device and domain. If you select Active Directory - Password, you must enter username and password.
Username/Password
Enter here the required login data for the database. If uncertain, ask your DB administrator.
Depending on the authentication method selected, these fields are available or not available.
Database
Enter the database here. When you have entered the server address, authentication or username and password. The drop-down list shows all available databases for the connection and you can select one.