Configuring a primary database connection

To configure a primary database connection, use sp_configprimaryconn:

sp_configprimaryconn "conn_name", param, value

where conn_name is the connection name in the form ds.db, param is the name of the configuration parameter, and value is the value of the configuration parameter.