We're verifying legacy system in SQL Server 2000 and confirmed we can connect it from SQL Server Management Studio 2016 (Need to add TCP port though).
Now we'd like to connect SQL Server Profiler 2016 to 2000, since we'd like to capture running query for some critical reports, but it says :
Native Client 11.0 can't connect to SQL Server before 2000
I'm just wondering we can connect profiler by OLEDB or else, instead of native client.
Is there anyone know any better idea, please let us know about your solutions.
Thank you.