Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem while starting SQL 2005 profiler Expand / Collapse
Author
Message
Posted Monday, January 19, 2009 11:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 29, 2012 10:00 AM
Points: 28, Visits: 126
We are working on Win Xp ver 2 and SQL server 2005 SP2(9.0.3068). On some desktop machines, Sql Profiler is not working.

We have found that if we remove MS-Office 2000/2003 installation from those problem desktops, SQL Profiler starts working. But if MS-Office is installed again, the Profiler stops working giving error " SQL tracing tool has encountered a problem and need to be closed....". I have attached the error screen shot from one of the desktop also for reference.

We have even formatted the machine and tried a fresh installation but no success. Without installing MS Office 2000 or 2003 , profiler works.



  Post Attachments 
Profiler not working.JPG (14 views, 32.16 KB)
Post #639668
Posted Monday, January 19, 2009 11:25 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:42 PM
Points: 10,193, Visits: 13,120
Never seen this happen and I have office installed on all my PC's that I run Profiler from. Are there any errors in the event logs?



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #639672
Posted Tuesday, January 20, 2009 12:57 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:52 PM
Points: 530, Visits: 1,134
Hi,

Please check in the event viewer what is the error. I think you can find out what actually might be the reason.

Thanks
Chandra Mohan N


Thanks
Chandra Mohan
Post #639700
Posted Tuesday, January 20, 2009 2:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 29, 2012 10:00 AM
Points: 28, Visits: 126
On checking evenviewer on one of problem desktop following error is shown in application log:-

EventView is showing errro : Faulting application profiler90.exe, version 2005.90.1399.0, stamp 434f613c, faulting module kernel32.dll, version 5.1.2600.5512, stamp 4802a12c, debug? 0, fault address 0x00012aeb.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Post #639733
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse