VA systems engineer
VA systems engineer

Reputation: 3189

Why does SQL Server Profiler crash when its run against a DB machine from a client machine?

I have:

On the Win 7 machine, I bring up SSMS and I connect OK to the DB that is on the Win Server 2012 machine. However, on SSMS, when I do Tools -> SQL Server Profiler, I get a dialog "Profile Application has stopped working". The event log shows the following which seems weird because I would expect Profiler.exe to be run on the remote Win Server 2012 DB machine

Why does SQL Server Profiler crash when its run against a DB machine from a client machine?

Faulting application name: Profiler.exe, version: 2017.140.17254.0, time stamp: 0x5ae98b94
Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
Exception code: 0xc0000005
Fault offset: 0x75bb48cb
Faulting process id: 0x4e0
Faulting application start time: 0x01d42da026f3a3d9
Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\Profiler.exe
Faulting module path: unknown
Report Id: 652f0139-9993-11e8-9f5b-327e82b70454

Upvotes: 0

Views: 616

Answers (1)

Fabio Pagano
Fabio Pagano

Reputation: 343

Try to run "SQL Server Management Studio" as administrator, then start the "SQL Server Profiler" from upper menu "Tools" / "SQL Server Profiler".

Upvotes: 0

Related Questions