IDERA SQL Secure requires that you register any SQL Server instances that you want to monitor before auditing begins. The Register a SQL Server option allows you to add instances to SQL Secure one at a time. For environments having many SQL Server instances, a quick time saver is to import a .csv file. The Import SQL Servers option lets you quickly upload a file containing the ServerName, AuthType (0 = Windows Authentication, 1 = SQL Server Authentication), User, Password, UseSameCredentials (0 = false, 1 = true), WindowsUser, and WindowsUserPassword data for the instances in your environment that you want to audit. Once imported, new SQL Server instances are registered directly in the repository with default settings. If the SQL Server instance already exists in the repository, then SQL Secure updates the login credentials for the server.
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. |
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 | 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
The first row in the previous table must be included in the .csv file as shown. |
To import SQL Server instances:
|