Setting the value of the Hide Instance option to Yes for the production SQL server instances

The non-clustered SQL server instances in the production environments must be designated as hidden to prevent advertisements by the SQL server browser service .

To set the value of Hide Instance to yes, run this T-SQL command on the IRC and the CM database:

EXEC master..xp_instance_regwrite
@rootkey = N'HKEY_LOCAL_MACHINE',
@key = N'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQLServer\SuperSocketNetLib',
@value_name = N'HideInstance',
@type = N'REG_DWORD',
@value = 1;