Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

After Installing Visual Studio 2017 I am unable to debug in SQL Server Management Studio (SSMS)

After Installing VS2017 I am unable to debug queries in SQL Server Management Studio 2012 (SSMS). I keep getting the error:

Unable to start program 'MSSQL:://YOUR_SERVER/YOUR_DATABASE/sys/=0'

A Visual Studio DLL, coloader80.dll, is not correctly installed. Please repair you Visual Studio installation via 'Add or Remove Programs' in Control Panel.

If the problem persis, you can manually register coloader80.dll from the command prompt with 'regsvr32 "%CommonProgramFiles%\Microsoft Shared\VS7Debug\coloader80.dll'

like image 876
Denis Avatar asked Mar 29 '17 13:03

Denis


People also ask

How do I get debug menu in SQL Server Management Studio?

To debugging SP, go to database->Programmability->Stored Procedures-> right click the procedure you want to debug->select Debug Procedure.

What version of SSMS works with SQL Server 2017?

The SQL Server Management Studio 17.2 version provides support to all features of SQL Server 2008 through SQL Server 2017, in addition to supporting the Azure SQL Database and Azure SQL Data Warehouse features.


1 Answers

From: Developer Community. To fix this issue, you can either:

Open a command prompt with administrator privileges and execute the following command:

reg add HKEY_CLASSES_ROOT\TypeLib{6A1A7D39-8449-4287-8EF0-CE256582C940}\8.0\0\win32 /t REG_SZ /d "C:\Program Files (x86)\Common Files\Microsoft Shared\VS7Debug\coloader80.tlb"

Alternatively you can execute:

regsvr32 "C:\Program Files (x86)\Common Files\Microsoft Shared\VS7Debug\coloader80.dll"

The correct registration will be included in future versions of Visual Studio.

like image 147
Denis Avatar answered Sep 21 '22 10:09

Denis