The practical application of this would be if there are a lot of servers to customize, or a lot of servers from which to collect information. Once the information is saved to the file, copy it to another server and import the settings. Here is an example of using the command line utility to save the database engine settings on a computer: More details for the command line version of the of the Surface Area Configuration tool can be found in the SQL Server books online documentation. Import or export the Windows Services settings.ĭisplay the help text for the SAC command. Import or export the Network Protocols settings. Import or export the Full-Text Search Service settings. Import or export the SQL Server Browser Service settings.

Import or export SQL Server Agent settings. Import or export Notification Services settings. Import or export Integration Services settings. Import or export Reporting Services settings. Import or export Analysis Services settings.

Import or export Database Engine settings. For the default instance, the instance name is MSSQLServer. If this option is not specified, sac connects to all SQL Server instances. Specifies the SQL Server instance to run sac against. If -P is specified at the end of the command without a value, sac uses a null password. If this argument is not specified, sac prompts for a password. If not specified, sac uses Windows authentication to connect to the database engine. Specifies the SQL Server Authentication login to use for the connection to the database engine. If this argument is not specified, sac connects to the local computer. The full path of the file used when importing or exporting the surface area settings. Import the surface area settings from a file and configure the instance, specified by instance_name, using those settings.Įxport the surface area configuration settings from an instance to the file specified by filename.

Wireshark command line commands