Versions Compared

Key

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

...

  • Server Name. Name of the SQL Server you want to register.
  • Authorization Type. Type of SQL Server authentication used to connect to the audited SQL Server.
    • 0 = Windows authentication
    • 1 = SQL Server authentication
  • User.
    • If the authorization type selected is 0 (Windows authentication), use Windows credentials. 
    • If the authorization type selected is 1 (SQL Server authentication), use the default credentials of the SQL Server Agent.
  • Password. Password associated with the user account used previously.
  • Use Same Credentials.
    • TRUE = Use Windows credentials specified previously.
    • FALSE = Specify a different Windows account.
  • Windows User. Credentials used to gather information about the OS, AD objects.
    • If Use Same Credentials is TRUE (Use Windows credentials specified previously), type a comma (,) in this column. 
    • If Use Same Credentials is FALSE (Specify a different Windows account), specify a different Windows user account.
  • Windows User Password. 
    • If Use Same Credentials is TRUE (Use Windows credentials specified previously), type a comma (,) in this column. 
    • If Use Same Credentials is FALSE (Specify a different Windows account), specify the password for the different Windows user account.
Server NameAuthentication TypeUserPasswordUse Same CredentialsWindows UserWindows User Password
Server NameAuthTypeUserPasswordUseSameCredentialsWindowsUserWindowsUserPassword
FINSVR0myhouse\williamTest123TRUE,,
SQLSVR10thathouse\jimNum1DBAFALSEToolsTest123
SQLSVR21yourhouse\scottTestabc1FALSEToolsTest123

...