SQL Server – How to Turn Off Telemetry in Install Config File

configurationinstallationsql serversql-server-2017

I'm creating a SQL Server 2017 Image Completion config file, and the automatically generated one has a bunch of stuff about "telemetry". I clicked no to the prompts, but it still put several user accounts in the config file, yet no true/false option for the telemetry itself. Here are the user accounts it included in the config file:

; TelemetryUserNameConfigDescription

SQLTELSVCACCT="NT Service\SQLTELEMETRY"

; TelemetryStartupConfigDescription

SQLTELSVCSTARTUPTYPE="Automatic"

; ASTelemetryStartupConfigDescription

ASTELSVCSTARTUPTYPE="Automatic"

; ASTelemetryUserNameConfigDescription

ASTELSVCACCT="NT Service\SSASTELEMETRY"

; TelemetryUserNameConfigDescription

ISTELSVCACCT="NT Service\SSISTELEMETRY140"

; TelemetryStartupConfigDescription

ISTELSVCSTARTUPTYPE="Automatic"

I suppose I could change the startup type to manual, but I would rather just remove all this garbage. Any idea how to turn this off via config file?

Best Answer

as far as i know, the only way to disable telemetry is to change the registry keys later. There is no actual harm to having those accounts, I don't think.

Related Solutions

SQL Server – How to Turn Off Alerts

To answer your direct question, I'd probably go about that with a dedicated SQL Server Agent Job to toggling the alert enabled status with the duration of that time.

To disable that alert:

use msdb;
go

exec dbo.sp_update_alert @name = 'YourAlertName', @enabled = 0;
go

And then 4 hours later (either as a separately scheduled job, or with just a WAITFOR DELAY in the initial job that does the disabling):

use msdb;
go

exec dbo.sp_update_alert @name = 'YourAlertName', @enabled = 1;
go

That's the short answer. But the more thorough one would be a question... Why is your process during this time causing this error? Unfortunately I can't advise without digging quite a bit deeper into what that is or what it is doing, as I'm not familiar with Veeam. But the point I'm trying to get across is, instead of silencing an alert during this timespan, I'd be even more interested in finding out why that process is causing that error, in turn triggering the alert.

SQL Server 2012 Express – Fixing ‘Could Not Find Database Engine Startup Handle’ Error

A simple and complete solution to error ' Could not find database engine startup handle' in below link Reason for the error can be

1.The account which user selected on Server Configuration page window ( during installation) is somehow not able to bring SQL Server database engine services online. Either is lacks privilege or it is corrupted. During installation of database engine services SQL Server tries to bring online database services as a internal process but due to startup account either corrupt or not having appropriate privileges it fails to do so and ultimately installation fails.

2.Other reason is when installation fails first time due to some reason and user uninstall failed installation from add remove program, the un-installation leaves account in broken state so any further attempt to install flashes this error message

Solution can be.

Uninstall SQL server completely from Add remove program

Launch setup by right click on it and select run as administrator. After launching the setup and providing necessary details you would reach to Server Configuration page . When you reach this page please select startup account for Database Engine services as NT Authority\SYSTEM which is also called as Local System account.

Complete details in SQL Server Installation Error:Could not find database engine startup handle

Best Answer

Related Solutions

SQL Server – How to Turn Off Alerts

SQL Server 2012 Express – Fixing ‘Could Not Find Database Engine Startup Handle’ Error

Related Question