In my current work position I've been given a desktop with SQL2014 tools installed including SQL Profiler. For some time we are still however supporting production SQL2000 machines and when using Profiler against these the following error is received:
Client unable to establish connection
SQL Server Native Client 11.0 does not support connections to SQL
Server 2000 or earlier versions.
What is a simple way to fix this issue?
Best Answer
You have to install management tools from sql server 2005/2008 or 2008R2 to manage sql server 2000.
Profiler from sql server 2014 wont work. There were problems from 2014 using profiler to 2005 - this is fixed in 2014 CU2.