Return
-
Title
What file format is used for importing SQL Server instances into Foglight? -
Description
What format should be used to import new SQL Server instances for the DBSS cartridge?
-
Resolution
Regserv files can be imported using the SQL Server installer in the Foglight console. The Regserv file can also be created by exporting the list of registered servers in SQL Server Management Studio. To do that, click View > Registered Servers, and then, in the Registered Servers pane, right-click the Local Server Groups folder and select Tasks > Export.
Note that the authentication method defined when registering a server is not kept.
CSV files can be imported through the CLI installer process using the command line outside of the SQL Server installer wizard to add new SQL Server instances. This is detailed in KB 124120.