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'
To debugging SP, go to database->Programmability->Stored Procedures-> right click the procedure you want to debug->select Debug Procedure.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With