Page History
...
| Info |
|---|
After importing your SQL Server instances, be sure to go the the Server Group Tags view to add the new servers to tag for better management. For more information about tags, see Manage server group tags. |
Acceptable .CSV format
You must use a properly-formatted .csv to successfully import a list of SQL Server instances. There is no limit to the number of rows included in the file, but note that if a row is incorrectly formatted, IDERA SQL Secure displays a message stating that the file is not in the proper format.
For a successful import of SQL Server instances, please use the following general rules and .csv file format.
- 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 Name | Authentication Type | User | Password | Use Same Credentials | Windows User | Windows User Password |
|---|---|---|---|---|---|---|
| Server Name | AuthType | User | Password | UseSameCredentials | WindowsUser | WindowsUserPassword |
| FINSVR | 0 | myhouse\william | Test123 | TRUE | , | , |
| SQLSVR1 | 0 | thathouse\jim | Num1DBA | FALSE | Tools | Test123 |
| SQLSVR2 | 1 | yourhouse\scott | Testabc1 | FALSE | Tools | Test123 |
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
| Info |
|---|
The first row in the previous table must be included in the .csv file as shown. |
Importing a .csv file
To import SQL Server instances:
...