Home Dashboard Directory Help
Search

SQL2014 Profiler fails to connect to SQL 2005 by RichardMunn


Status: 

Active


24
0
Sign in
to vote
Type: Bug
ID: 864021
Opened: 4/30/2014 3:20:46 AM
Access Restriction: Public
0
Workaround(s)
view
5
User(s) can reproduce this bug

Description

Connection to a SQL2005 instance from SSMS 2014 is OK, but when I hit up the Tools>SQLServer Profiler option to start Profiler, an error is returned and Profiler won't connect.

Error text:
"SQL Server Profiler cannot perform this action on database servers earlier than SQL 2005. Please use SQL Server 2005 or later."

Instance I'm trying to connect to is build 9.0.5292.

SSMS 2014 details:
Microsoft SQL Server Management Studio                        12.0.2000.8
Microsoft Analysis Services Client Tools                        12.0.2000.8
Microsoft Data Access Components (MDAC)                        6.1.7601.17514
Microsoft MSXML                        3.0 6.0
Microsoft Internet Explorer                        8.0.7601.17514
Microsoft .NET Framework                        4.0.30319.18063
Operating System                        6.1.7601

SQL Profiler details:
SQL Server Profiler                        12.0.2000.8
Microsoft .NET Framework                        4.0.30319.18063
Operating System                        6.1.7601
Details
Sign in to post a comment.
Posted by Ryan McCauley on 5/8/2014 at 8:08 AM
I've verified that this occurs with both a SQL 2005 SP4 server (9.0.5000) and SP1 + hotfix (9.0.2050). I'm have the same version on SSMS/Profiler (12.0.2000.8), but with the following component versions (if it matters):

SSMS:
MDAC: 6.3.9600.16384
IE: 9.11.9600.17031
.NET Framework: 4.0.30319.34014
OS: 6.3.9600 (Windows Server 2012 R2)

Profiler:
.NET Framework: 4.0.30319.34014
OS: 6.3.9600 (Windows Server 2012 R2)
Sign in to post a workaround.