Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Issue debugging CLR procs through stuido 2008 running on w..

  
   Database Help (Home) -> Programming RSS
Next:  Trouble with KB 970315  
Author Message
carvic

External


Since: Dec 23, 2009
Posts: 1



(Msg. 1) Posted: Wed Dec 23, 2009 8:35 am
Post subject: Issue debugging CLR procs through stuido 2008 running on windows s
Archived from groups: microsoft>public>sqlserver>programming (more info?)
I am unable to debug from our dev server to our database server. I receive a
warning then an exception (indicated below).

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.
--------------------------------------------------------------------------------

 >> Stay informed about: Issue debugging CLR procs through stuido 2008 running on w.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Debugging Tools for SQL Server 2000 Stored Procs - Hi All, I need a development tool for writing stored procs in SQL Server 2000. I'd like to be able to set breakpoints and watchs and step through code. Any suggestions would be greatly appreciated. Thanks, Steve

Procedure debugging behaving different that SSMS when runn.. - DECLARE @VehicleIDs AS VARCHAR(8000) SET @VehicleIDs = NULL r.VehicleID is an INT s.Value is a VARCHAR(8000) s.IDX is an INT dbo.Split(...) is a table valued UDF. In this case it doesn't return any rows. SELECT TOP 1 * FROM tblTripsActual a..

Using Stored Procs like Tables - Hi, If you have a Stored Procedure that returns a table, is it possible to use it in the same way as you can use a normal table. I mean so you can sort on it and filter on it etc without editing the stored procedure or adding parameters? Is there a way t...

getting stored procs to communicate with databases on othe.. - Ok, I've looked in my reference books and can't find this. I'm currently using code I've written on a database which communicates with tables within that database. Now, we're splitting databases. We'll have one for code, and another one for reporting....

Fastload, context connection and CLR stored procs - I have an app that: 1. creates a temp table 2. uses fastload interface to insert rows into table 3. calls stored proc to process rows Everything is done on the same connection. If the stored proc is a CLR stored proc, the temp table is visible but ..
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]