Menu
Installing SQL 2016 automatically turns on all of the "CEIP", or Customer Experience Improvement Program elements. These elements report back to Microsoft about various aspects of your installation experience as well as your feature usage. I want to turn it off, because it's all blocked by our firewalls anyway and I don't need the headache.
222
SQL Server. 22. The CEIP Service is the Customer Experience Improvement Program that sends telemetry data back to Microsoft. When you install Microsoft SQL Server, the CEIP Service is installed too. You can't disable it during installation: it shows up in your services list whether you want it or not.
CEIP stands for Customer Experience Improvement Program and is a Microsoft service used to collect information on how SQL Server is being used. Microsoft can then use the data collected to determine what areas of SQL Server need improvement.
Start the tool and open a new or existing project for either Analysis Services or Integration Services. From the Help menu, select Microsoft SQL Server Customer Feedback Options. To turn CEIP off, click No, I don't wish to participate. To turn CEIP on, click Yes, I am willing to participate.
The SQL Writer Service provides added functionality for backup and restore of SQL Server through the Volume Shadow Copy Service framework. The SQL Writer Service is installed automatically. It must be running when the Volume Shadow Copy Service (VSS) application requests a backup or restore.
Turns out, doing this seems pretty easy. Set the following registry keys:
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\CustomerFeedback=0 HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\EnableErrorReporting=0 HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSAS13.TESTINSTANCE\CPE\CustomerFeedback=0 HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSAS13.TESTINSTANCE\CPE\EnableErrorReporting=0 HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSRS13.TESTINSTANCE\CPE\CustomerFeedback=0 HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSRS13.TESTINSTANCE\CPE\EnableErrorReporting=0 HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL13.TESTINSTANCE\CPE\CustomerFeedback=0 HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL13.TESTINSTANCE\CPE\EnableErrorReporting=0 HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\Microsoft SQL Server\130\CustomerFeedback=0 HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\Microsoft SQL Server\130\EnableErrorReporting=0 If any of the keys don't exist, then that's OK, because you apparently didn't install that feature.
Disable the following services:
SQL Analysis Services CEIP SQL Server CEIP service SQL Server Integration Services CEIP service 13.0 If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With