Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version Current

changes.mady.by.user Alejandra Barrientos

Saved on

Key

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

...

Info

After importing your SQL Server instances, be sure to go to the the Server Group Tags view to add the new servers to the tag for better management. For more information about tags, see Manage server group tags.

...

  • 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 instance 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

...

Server NameAuthentication TypeUserPasswordUse Same CredentialsWindows UserWindows User PasswordPort numberServer Type
Server NameAuthTypeUserPasswordUseSameCredentialsWindowsUserWindowsUserPasswordPortNumberServerType

FINSVR

0

myhouse\william

Test123

TRUE

,

,

1433

0

SQLSVR1

0

thathouse\jim

Num1DBA

FALSE

Tools

Test123

1433

0

accidera1

acidr1.

accoliteindia

usercntry.com\MSSQLSERVER1  

2

temp@xyz.com

abc@1234

TRUE

,

,

1433

1

sqlsecureacc.database.windows.net

2

test@accolitelabs

test@clientlabs.com  

abc@1234

TRUE

,

,

1433

2

IDERA

IDR-SQL2008R2

.CSZUD3HACSPL

.US-EAST-1.RDS.AMAZONAWS.COM

3

accolitelabs

clientlabs\administrator1

control*123

FALSE

,

,

1433

3

ec2

ec3-

52

53-0-

82

86-183.

compute

computeIDR-1.amazonaws.com

0

simpsons

simpclient\administrator

control*159

TRUE

,

,

1433

4

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


Info

The first row in the previous table must be included in the .csv file as shown.

...