Home » 2018 » April

Monthly Archives: April 2018

SQL Server 2016 – SQL Server Telemetry \ CEIP Services

CEIP (Customer Experience Improvement Program) is somethings runs from ages and almost each vendor perform it to collect product usage data, issues faced and other information. Vendor uses this information for market expansion, bug fixing and new features.

But all this happen with user confirmation during or after installation. Microsoft is also doing it for it’s multiple products.

As data becomes more important, telemetry for software is potentially a data leakage and part of security and audit concerns. This becomes more concerns when we comes to database systems.

With SQL Server 2016, Microsoft is installing SQL Server Telemetry \ CEIP Services by default (most of the users are unware that they have installed CEIP). You cannot skip the installation of these services.

SQL Server 2016 Telemetry \ CEIP Services – You can see 3 services per instance separately for DB engine, SSAS & SSIS features installed.

SQLTELEMETRY$instancename

SSASTELEMETRY$instancename

SSISTELEMETRY130$instancename

How to disable SQL Server 2016 Telemetry \ CEIP Services?

NOTE : DO NOT REMOVE THESE SERVICES, AS THIS CAN IMPACT SQL SERVER SERVICE PACK INSTALLATION IN FUTURE.

  1. Stop and disable all SQL Server Telemetry available on your machine. No. of services can differ on basis of features or no. Of instances installed.

You can use PowerShell script to check SQL Telemetry services status.

Get-Service |? name -Like "SQLTELEMETRY*" | select -property name,starttype,status

Get-Service |? name -Like "SSASTELEMETRY*" | select -property name,starttype,status

Get-Service |? name -Like "SSISTELEMETRY*" | select -property name,starttype,status

  1. Disable CEIP registry keys to 0

Two parameters have to be set to 0:

  • CustomerFeedback
  • EnableErrorReporting
  1. The first registry key is HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\
  2. The second registry key is HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\Microsoft SQL Server\130\
  3. The other registry keys are per instance and per services(Engine, SSAS and SSRS):
    HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL**.<instance>\CPE\
  4. HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSAS**.<instance>\CPE\
  5. HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSRS**.<instance>\CPE\

Reference: Rohit Garg (http://mssqlfun.com/)

You can find and follow MSSQLFUN:-

http://www.facebook.com/mssqlfun

http://mssqlfun.com/feed

https://twitter.com/Rgarg86

Other Linked Profiles :-

http://social.msdn.microsoft.com/Profile/rohitgarg

http://www.sqlservercentral.com/blogs/mssqlfun/

http://www.toadworld.com/members/rohit-garg/blogs/default.aspx

http://beyondrelational.com/members/RohitGarg/default.asp

%d bloggers like this: