The proc does execute however I am unable to step into debug at all. I'm a
domain admin on both boxes and the sql connection for the proc is using
Integrated Security
I'm not seeing anything of not in the event log on the SQL box, but I am
seeing the below audit failure
Does anyone have an idea of how to resolve this?
Thanks
Audit Failure
--------------------------------------------------------------------------------
The domain controller attempted to validate the credentials for an account.
Authentication Package: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0
Logon Account: sqlsvc
Source Workstation: IQSQLDEV01
Error Code: 0xc0000064
--------------------------------------------------------------------------------
Warning
--------------------------------------------------------------------------------
WARNING: Unable to determine if the Windows Firewall is blocking remote
debugging. There are no more endpoints available from the endpoint mapper.
--------------------------------------------------------------------------------
Exception
--------------------------------------------------------------------------------
T-SQL execution ended without debugging. You may not have sufficient
permissions to debug. Click help for more information.
--------------------------------------------------------------------------------