June 24, 2010 at 2:31 pm
Does anyone have a link to show how to turn on SQL 2008 Debugging for developers?
It's weird, I'm working on a database that resides in domain2 while I'm logged in from domain1, and I'm getting error messages telling me I can't debug. But if I log into domain2 on computer1 (which is one domain2), I can debug. If I log into domain2 on computer2 (which is on domain2), I can debug. But if I log into domain1 and use ssms to debug something on domain2, I get error messages.
Eventually, I was assigned sysadmin rights, and that allowed me to debug. But I'm wondering if there is a lower role that I can be assigned but yet still debug? And also, somehow allow me to debug even though I'm logged in going across domains.
I received error messages like:
'The EXECUTE permssion was denied on the object 'sp_enable_sql_debug', database 'mssqlsystemresource', schema 'sys' (Microsoft SQL Server, Error 229)'
'EXECUTE permission was denied on object 'sp_enable_sql_debug', database 'master'. (Microsoft SQL Server, Error: 300)'
'Unable to start T-SQL Debugging. Could not connect to computer 'xxx.xxx.com'. Logon failure: unknown user name or bad password.'
We got past all these error messages, but it required that 1) I was assigned sysadmin, and 2) I could only debug from within the same domain.
note: I posted a couple of questions earlier about a) renaming temp tables and b) dynamically creating temp tables. Those were odd (but required) questions for a very complex programming issue. Basically, I'm trying to run a dynamic data system and manage my own entities and data within my own tables. I have a workaround so that I don't need either questions answered, but I'm not exactly thrilled with my workaround. It will work, but it's not the way I would normally approach it. But it does work.
July 13, 2010 at 5:57 am
Hi,
There is a permission restriction for debugging TSQL in sql server
1) sql login must be a Windows user account
2) And secondly that account must be sysadmin role on the sql server.
check this,
http://msdn.microsoft.com/en-us/library/w1bhybwz.aspx
Thanks,
Amit kulkarni
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply