Symptoms
Consider the following scenario:
-
You create a simple ASP.NET web application project in Visual Studio 2012.
-
You create a new dataset, point in to any SQL instance of Microsoft SQL Server 2012 or SQL Server 2014 and use any table.
-
You create a new RDLC report and bind it with a dataset.
-
From the Properties icon on the Report Viewer 2012, you select the newly create report.
-
You click Select Data Source and from the Data Source Instance drop-down list, select the dataset bounded in step 2.
In this scenario, Visual Studio 2012 crashes immediately.
Note The issue also occurs in Microsoft SQL Server 2014.Cause
The issue occurs because, code changes moves a copy of DTEUtil to the ReportViewer.WebDesign assembly that is compiled with references to an old version of the VisualStudio.Shell. This results in a failure when you call GetGlobalService function.
Resolution
This issue is resolved in Microsoft SQL Server 2012 Service Pack 2 (SP 2).
Service pack information for SQL Server 2012
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2012. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2755533 How to obtain the latest service pack for SQL Server 2012 The issue was first fixed in the following cumulative update of SQL Server.
Cumulative Update 1 for SQL Server 2014 /en-us/help/2931693
Cumulative Update 9 for SQL Server 2012 SP1 /en-us/help/2931078
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.