Reputation: 3189
I have:
SQL Server 2014
(default instance )is on a Win Server 2012
machine.SQL Server Management Studio
(v17.7) is on a Win 7
machine.Win 7
machine as a domain admin.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
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