Do not get surprised if you cannot end a process via Task Manager

Problem:

I encountered a problem when I opened an SSRS Map Application in BID 20008  (9.0.30729.4462) on my Windows 8.1 laptop. The BIDS program hanged forever...The same problem happens to SSDT  as well, even after upgrading.

Solution:

Well, I solved the problem by restarting the machine.

Reason:

It is a kind of bug, see below

http://support.microsoft.com/kb/155075

Note:

The mapping between SQL Server and BIDS/SSDT is confusing...

SQL Server 2005 (90) uses BIDS - Visual Studio 8 (or VS 2005) Shell

SQL Server 2008 (100) uses BIDS - Visual Studio 9 (or VS 2008) Shell

SQL Server 2008R2 (100) also uses BIDS - Visual Studio 9 (or VS 2008) Shell

Note:  Although R2 is 10.50 in SQL Server, from the standpoint of BIDS, it still uses the same installation directory as 2008 at %Program Files%Microsoft SQL Server\100\DTS

SQL Server 2012 (110) uses SSDT - Visual Studio 10 (or VS 2010) Shell (but you need to take additional step to install it). In SQL Server 2012, SQL Server SSDT means two different things with one name: one for SQL Server, and the other is for Visual Studio.