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

Sample .csv file:

Server Name,AuthType,User,Password,UseSameCredentials,WindowsUser,WindowsUserPassword
FINSVR1,0,myhouse\william,Test123,TRUE,,
SQLSVR1,0,thathouse\jim,Num1DBA,FALSE,Tools,Test123
SQLSVR2,1,yourhouse\scott,Testabc1,FALSE,Tools,Test123

...

1. In the Security Summary view, click Import SQL Servers at the top of the Summary tab. Alternatively, you can go to File menu and select Import SQL Servers.
   OR
   In the Manage SQL Secure view, click Import SQL Servers at the top of the Repository Status window. Alternatively, you can go to File menu and select Import SQL Servers.
   The Import SQL Servers window opens.
2. Locate the file you want to import. Note that the file must be in the .csv format.
3. Click Open, and then click OK. SQL Secure validates the file format and displays the message, "Any registered servers found in the import file will have their credentials updated based on those specified in the file."
4. Click OK.