Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 2

changes.mady.by.user Unknown User (6092aebacc7830006a5cfc58)

Saved on

Key

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

The Specify Connection Credentials window section of this wizard allows you to designate the credentials that SQL Secure uses will use 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.In this section you have to specify the following credentials:

ItemDescription
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
Agent credentials
  • Authentication 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 - These credentials are used to connect to the target server to gather Active Directory objects, file, and registry key permissions.

Select one of the following options:

  • Check the Use same Windows Authentication as above box
or specify the account SQL Secure should
  • to use the windows credentials specified above.
  • Specify a different Windows account that SQL Secure will use use to gather information about OS and AD objects.
Note
titleCase Sensitive accounts

Take into account that if

Info

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
titlePermissions and Privileges

You should keep in mind the following permissions for the accounts specified in this section:

  • The SQL Server login must belong to the sysadmin fixed role on the target instance
, and the
  • . 
  • The Windows account must have Windows Administrator privileges on the target instance to collect group membership information.
  • The account specified for gathering information about OS and AD objects must have admin access to the target server and at least login access to the SQL Secure Repository.

After you specify your connection credentials, click Next to go to Specify which SQL Server objects to audit. 

SQL Secure tells you who has access to what on your SQL Server databases. Learn more > >

...