I have a SQL 2014 dev instance running on a windows 2012 R2 OS
I have upgraded a 2012 version to 2014, and one of the developers has noticed the debug button in MMS isn't working.
When clicking you get the following error:
Failed to start debugger
------------------------------
ADDITIONAL INFORMATION:
Data is Null. This method or property cannot be called on Null values. (System.Data)
Click okay then you get :
Unable to start a program 'MSSQL;;//INSTANCE/DBNAME/sys/=0
I have looked all over google with no solution. The SQL service account is running under a domain account which is in the sysadmin role, so not a permissions thing there. Also management studio is running local to the instance so its not a remote connection issue. There is nothing in event viewer or SQL logs to indicate a problem.
I would appreciate any help or advise on this please.
Full error info:
===================================
Failed to start debugger
===================================
Data is Null. This method or property cannot be called on Null values. (System.Data)
------------------------------
Program Location:
at System.Data.SqlTypes.SqlBinary.get_Value()
at Microsoft.SqlServer.Management.UI.VSIntegration.DebugSession.DebugCallbacks.OnSqlInitializeDebuggingEvent(ISqlInitializeDebuggingEvent sqlInitializeDebuggingEvent)
at Microsoft.SqlServer.Management.UI.VSIntegration.DebugSession.DebugCallbacks.Microsoft.VisualStudio.Debugger.Interop.IDebugEventCallback2.Event(IDebugEngine2 debugEngine, IDebugProcess2 debugProcess, IDebugProgram2 debugProgram, IDebugThread2 debugThread, IDebugEvent2 debugEvent, Guid& riidEvent, UInt32 attribute)