The Specify Connection Credentials window allows you to designate the credentials that SQL Secure uses to access the SQL Server instance you are adding. You can specify either SQL Server login or Windows account credentials.
You can later change which connection credentials SQL Secure uses. When you change credentials, SQL Secure identifies other audited SQL Server instances that use the same account and then lets you change their connection credentials as well.
| Item | Description |
|---|---|
| SQL Server credentials to connect to audited SQL Server | Select SQL Server Agent credentials to use the default credentials of your SQL Server Agent or click Windows Authentication and enter the credentials in the fields provided. |
| Windows Credentials to gather Operating System and Active Directory objects | Check the Use same Windows Authentication as above box or specify the account SQL Secure should use to gather information about OS and AD objects. |
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.
The SQL Server login must belong to the sysadmin fixed role on the target instance, and the Windows account must have Windows Administrator privileges on the target instance to collect group membership information.