Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Specifies the instance name for the connection string used to connect to the management data warehouse.
Applies to: SQL Server (SQL Server 2008 through current version).
You must disable the data collector before changing this data collector-wide configuration. This procedure fails if the data collector is enabled.
To view the current instance name, query the syscollector_config_store system view.
The following example illustrates how to configure the data collector to use a management data warehouse instance on a remote server. In this example the remote server is named RemoteSERVER and the database is installed on the default instance.
USE msdb; GO EXEC sp_syscollector_set_warehouse_instance_name N'RemoteSERVER'; -- the default instance is assumed on the remote server GO