On opening SQL Management Studio throws - Exception has been thrown by the target of an invocation

_{Monday, April 30, 2018 10:09 AM}

Hi All,

Find same exception while opening MS SQL Management Studio and Visual Studio, For more info, Please find the Screenshot below



-- From Krish Kannaa

_{Monday, April 30, 2018 10:17 AM}

Which is your SSMS version?

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh

My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page

_{Monday, April 30, 2018 10:18 AM}

This problem occurs when the "FIPS-compliant algorithms" policy is enabled on a system. For more details: https://support.microsoft.com/en-in/kb/811833 

Here, fipsalgorithmpolicy registry subkey was set to 1 (Enabled).

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\FipsAlgorithmPolicy]
"Enabled"=dword:00000001

I disabled FIPS setting “Enabled” DWORD value to Zero.

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\FipsAlgorithmPolicy]
"Enabled"=dword:00000000

Then the problem was resolved. I was able to create projects in Visual Studio 2015 IDE.

_{Monday, April 30, 2018 10:19 AM}

Hi Visakh,

It is 2014 version.

-- From Krish Kannaa

_{Monday, April 30, 2018 10:26 AM | 1 vote}

It is a most common issue, Check the following link which has more detailed description on the issue

Sql Exception thrown target invocation

Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (kokkisajee) or Facebook (sajeetharan)

_{Monday, April 30, 2018 10:46 AM}

Hi Sajeetharan,

 PATH environment variable has only 908 characters.

-- From Krish Kannaa

_{Monday, April 30, 2018 12:08 PM}

The message is generic, so it could be about anything. Since you have SSMS 2014, you could try downloading and install SSMS 17.6, the latest version. You find it here:
https://msdn.microsoft.com/en-US/library/mt238290.aspx