This site uses cookies to deliver our services. By using this site, you acknowledge that you have read and understand our Cookie and Privacy policy. Your use of Kontext website is subject to this policy. Allow Cookies and Dismiss

SQL Server Denali_Exception has been thrown by the target of an invocation Solution

2375 views 3 comments last modified about 7 years ago Raymond Tang Fahao

Issue

After I installed Visual Studio 2011 Developer Preview, the error “Exception has been thrown by the target of an invocation” will be thrown when I try to lunch SQL Server Management Studio.

Microsoft Connect site has a relevant issue: http://connect.microsoft.com/SQLServer/feedback/details/668421/denali-exception-has-been-thrown-by-the-target-of-an-invocation-during-setup.

Solution

According to the article in Connect, the issue hasn’t been resolved yet. There is a temporary resolution: using “Run as administer” option when you lunch SSMS.

It is working for me:

image

Related pages

Querying Teradata and SQL Server - Tutorial 1: The SELECT Statement

31024 views   7 comments last modified about 4 years ago

SELECT is one of the most commonly used statements. In this tutorial, I will cover the following items: Two of the principal query clauses—FROM and SELECT Data Types Built-in functions CASE expressions and variations like ISNULL and COALESCE. * The functio...

View detail

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

3223 views   2 comments last modified about 4 years ago

Tutorial –1 For Teradata developers, if you have no SQL Server installed, please go to the following link to download the SQL Server 2014 Expression Edition. ...

View detail

Querying Teradata and SQL Server - Tutorial 0: Preparation

2904 views   0 comments last modified about 4 years ago

In this serial, I will compare Teradata SQL with T-SQL with samples provided. This is mainly prepared for SQL Server DBAs, Developers and other users to help them quickly master the common used SQLs in Teradata platform. Similar to T-SQL, Teradata SQL implements most part of the ANSI SQL with ext...

View detail

SQL Server中的联合主键、聚集索引、非聚集索引

658 views   0 comments last modified about 9 years ago

我们都知道在一个表中当需要2列以上才能确定记录的唯一性的时候,就需要用到联合主键,当建立联合主键以后,在查询数据的时候性能就会有很大的提升,不过并不是对联合主键的任何列单独查询的时候性能都会提升,但我们依然可以通过对联合主键中的首列除外的其他列建立非聚集索引来提高性能。关于索引,可以参考我的这篇文章:http://hi.baidu.com/1987raymond/blog/item/a0f7b11062e1330a213f2e26.html

View detail

sql 分页存储过程

257 views   0 comments last modified about 10 years ago

个人感觉这个存储过程写得比较的好:转载自:http://www.cnblogs.com/eme/archive/2006/12/19/597275.html

View detail

SQLite Abort due to constraint violation

492 views   0 comments last modified about 10 years ago

今天自己使用SQlite数据库的时候创建了一个表 大致是:Create TABLE [Logs](
[LogID] int PRIMARY KEY NOT NULL
,[LogTitle] varchar(100)
,[LogContent] text
,[LogType] int NOT NULL DEFAULT 0
,[LogAddTime] datetime
);

View detail

Add comment

Please login first to add comments.  Log in New user?  Register

Comments (3)

RP re: SQL Server Denali_Exception has been thrown by the target of an invocation Solution

Rodr*** about 7 years ago

Hi there, gald i could help
here's my email stationsolutions@gmail.com
Anything more i can help you , feel free to ask ;)

Best regards

Rodrigo Pinto, SharePoint MVP
www.sharepointpt.org

R re: SQL Server Denali_Exception has been thrown by the target of an invocation Solution

Ra*** about 7 years ago

Hi Rodrigo,
Thanks a lot for your comment.
RP re: SQL Server Denali_Exception has been thrown by the target of an invocation Solution

Rodr*** about 7 years ago

Hi there, try this

"This happens after installing SQL Server 2012 (Code named "Denali CTP3") or later, running SSMS successfully, then (later) install VS11 Dev Preview, and then run SSMS.

Dev11 Preview improperly recognize SQL Server Denali SSMS as a version 11 application and it updates the current user’s setting in SSMS registry key during the setup. This issue occurs only when Dev11 Preview is installed after the installation of SSMS.

SQL Server 2012 SSMS has a built-in security and resiliency feature for any corrupted configuration in HKCU registry key. The corrupted registry keys can be simply deleted then SSMS automatically reconstructs it with correct values during the next startup procedure.

• Start regedit.exe

• Go to HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio

• Delete 11.0_Config

• Restart ssms.exe
"
from connect.microsoft.com/...

Hope it helps

Rodrigo Pinto, SharePoint MVP
www.sharepointpt.org