Page History

...

• 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
  • 2 = Azure AD authentication
  • 3 = Amazon AD authentication (RDS for SQl SQL Server )
• 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.

  • If the authorization type selected is 2 (Azure AD authentication) , use Azure AD credentials.

  • If the authorization type selected is 3 (Amazon AD authentication) , use Amazon AD credentials.

• Password. Password associated with the user account used previously.
• Use Same Credentials.
  
  • TRUE = Use Windows/Azure AD/Amazon AD 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/Azure AD/Amazon AD credentials specified previously) , type a comma (,) in this column.
  • If Use Same Credentials is FALSE (Specify a different Windows/Azure AD/Amazon AD account) , specify a different Windows user account.
• Windows User Password.
  • If Use Same Credentials is TRUE (Use Windows/ Azure AD/ Amazon AD credentials specified previously) , type a comma (,) in this column.
  • If Use Same Credentials is FALSE (Specify a different Windows/ Azure AD/ Amazon AD account) , specify the password for the different Windows user account.
• Port Number. Port number on which the SQL Server instance, Azure SQL DB, or Amazon RDS for SQL Server is running. The default number is 1433.
• Server Type. Type the number of instances that is getting added.
  • 0 = On-premise
  • 1 = SQL Server on Azure VM
  • 2 = Azure SQL Database
  • 3 = Amazon RDS for SQL Server
  • 4 = SQL Server on Amazon EC2

...

Sample .csv file:

Server Name,AuthType,User,Password,UseSameCredentials,WindowsUser,WindowsUserPassword

FINSVR1,0,myhouse\william,Test123,TRUE,,,,, 1433, 0

SQLSVR1,0,thathouse\jim,Num1DBA,FALSE,Tools,Test123,1433,0

accidera1acidr1.accoliteindiausercntry.com\MSSQLSEVER1MSSQLSERVER1,2,temp@xyz.com, abc@1234,TRUE,,, 1433, 1

sqlsecureacc.database.windows.net, 2, test@accolitelabstest@clientlabs.com, abc@1234,TRUE,,, 1433, 2

IDERAIDR-SQL2008R2.CSZUD3HACSPL.US-EAST-1.RDS.AMAZONAWS.COM,3,accolitelabsclientlabs\administrator1,control*44,FALSE,,,1433,3

ec2ec3-5253-0-8286-183.computecomputeIDR-1.amazonaws.com ,0,simpsonssimpclient\administrator,control*44,TRUE,",",",",1433,4

...