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.