Sql Server Error and usage reporting does not work

Dirk Hondong 871 Reputation points
2020-12-01T09:12:12.69+00:00

Hi there,

I have setup 3 new servers with Windows Server 2019
All have SQL Server 2019 Ent Ed installed with CU 8.
On all 3 servers I get the same error when I want to start the SQL Server 2019 Error and Usage Reporting module to deactive the CEIP components.

So, here are the information form the Applicaion log
Faulting application name: SqlWtsn.exe, version: 15.0.2000.5, time stamp: 0x5d8a80af
Faulting module name: KERNELBASE.dll, version: 6.2.17763.1518, time stamp: 0xff301d3c
Exception code: 0xe0434f4d
Fault offset: 0x00000000000396c9
Faulting process id: 0x%9
Faulting application start time: 0x%10
Faulting application path: %11
Faulting module path: %12
Report Id: %13
Faulting package full name: %14
Faulting package-relative application ID: %15

  • System
    • Provider
    [ Name] Application Error
    • EventID 1000
    [ Qualifiers] 0 Level 2 Task 100 Keywords 0x80000000000000
    • TimeCreated
    [ SystemTime] 2020-12-01T09:01:09.835630000Z EventRecordID 4141 Channel Application Computer NameChanged Security
  • EventData SqlWtsn.exe
    15.0.2000.5
    5d8a80af
    KERNELBASE.dll
    6.2.17763.1518
    ff301d3c
    e0434f4d
    00000000000396c9

Does anyone experienced the same behaviour?
Workaround for me is to disable CEIP programmatically (it's faster anyway).

Best regards

SQL Server | Other
{count} votes

Accepted answer
  1. Dirk Hondong 871 Reputation points
    2020-12-01T10:50:39.33+00:00

    Ok, that is weird.

    Now the tool works.
    What I did was the following:
    Just renamed the file SqlWtsn.exe.config to SqlWtsn.exe.config.OLD

    It is located in
    C:\Program Files\Microsoft SQL Server\150\Shared

    Afterwards I could run the tool properly.

    5 people found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. tibor_karaszi@hotmail.com 4,316 Reputation points
    2020-12-01T13:00:38.53+00:00

    I've also noticed this this util doesn't work anymore, but I never got around to report it... Thanks for the catch/reminder!

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.