I've installed SQL Server 2008 R2 Express edition on my Win 7 notebook. Using since an Express edition this doesn't have SQL Server profiler enabled. Thus it's hard for me to debug my SQL Server 2005 applications.

I have a license for SQL Server 2005 (32 bit) and when I tried to install the client tools it gave a "known compatibility" error message. Is it possible to install SQL Server 2005 client tools (for 32 bit) only in the same machine?

Below is list of software on my machine

  • Windows 7
  • SQL Server 2008 R2 Express edition
  • Visual Studio 2010

Can any one advise.

thanks a zillion

  • So what was MS's solution to whatever known compatibility issue it was?
    – Tony Hopkinson
    Dec 28, 2012 at 3:21

1 Answer 1


I doubt you can use the SQL Server 2005 client tools for SQL Server 2008 R2. But if your main issue is the inability to use profiler, I suggest just running server-side traces instead. You don't get the fancy GUI, but you can still see all the same data.

Running a trace without profiler: SQL Server Performance Statistics Using a Server Side Trace

Note, one thing you won't be able to do with server-side tracing is to replay a trace.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.