SQL Server 2008 R2

Question

Hi All

I ve tried each and every step as indicated to setup remote debugging in sql server.it does not give any error but it just executes query instead of stepping into the code and i am unable to jump to any breakpoint.

Have tried same on visual studio 2008 Professional edition but when debugged from there it gives error query cancelled by the user.client is windows XP.On another Windows 7 it gives error that insufficient permission for remote debugging.have followed each step in terms of firewall

and program exceptions.Please some one guide me ive been trying it for last 10 days and i need it urgently.

Answer 1

Hello,

As i am not sure to have understood your question, please, could you give more explanations ? ( as english is not my mother tongue, i have often problems to understand anglish ).

-  when you are writing "to setup remote debugging in sql server", what is the application you are using to execute statements ? SQL Server Management Studio ?

- what is the edition of your SQL Server (Express,Web,Standard,Entreprise,..) ? Useful as some editions are not not providing whole features

I found that link but i don't think it will help you because you know it surely :

http://msdn.microsoft.com/en-us/library/2ys11ead(VS.90).aspx

For debugging in SQL Server Management Studio, i found this link :

http://technet.microsoft.com/en-us/library/cc646024.aspx

We are waiting for your feedback to try to help you more efficiently.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 2

Hi

i am executing statements from Management studio client only buddy.it just executes instead of stepping through.have already followed the document.

I am using sql server 2008 R2 standard edition on windows server 2008 r2 enterprise both 64 bit and clients are windows7 and windows XP.

Have tried same on visual studio 2008 Professional edition but when debugged from there it gives error query cancelled by the user.client is windows XP.On another Windows 7 it gives error that insufficient permission for remote debugging.

Answer 3

Please somebody help i need it urgently.

Answer 4

Hello,

Not sure this link could help you, but i give it you :

http://www.mssqltips.com/sqlservertip/1695/sql-server-2008-tsql-debugger-is-back-in-ssms/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=2012430

I am going on to search other potential useful links

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 5

Hello,

Have you found a solution to your problem ? If yes, please, could you share it ( it would be useful  for other people facing the same problem ) ?

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 6

no dear,

please help me out as i have already tried everything and there is very less useful material for troubleshooting.

Regards

Rahul

Answer 7

Hello,

Please, could you provide the full error messages you got ? It is the minimum to to try to help you

Have you tried to have a look at the Windows logs ( System and Application ) on both computers (client and server ) ?

For the moment, i have found only one link which could be related to your problem. Big problem : it is written in romanian and except if you have studied latin or a language coming from latin ( italian,french ), i am not sure it will help you.I give the link anyway :

http://blogs.msdn.com/b/sqlro/archive/2012/05/04/migrare-baza-de-date-catre-o-versiune-de-sql-server-anterioara.aspx

more generally

http://blogs.msdn.com/search/searchresults.aspx?q=%22T-SQL+debugging%22

Insufficient permissions for remote debugging ==> it is usually a problem with the WMI/DCOM problems ( All programs ==> management tools ==> components services )

I am sorry , i am writing from a XP SP3 Pro ( french ) .It is on the level of Configuration DCOM that you have to work

See also http://blogs.msdn.com/b/sqlclr/archive/2006/07/07/659332.aspx

We are waiting for your feedback to try to help you more efficiently

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 8

My dear i have done this also have already given permission on msdtc and com to everyone and anonymous user(MAXIMUM POSSIBLE PRIVILEGE)problem i am facing is that sql queries and procedures just executes instead of debugging and i am unable to step through into code and insert any breakpoint.When logged in to machine locally debugging works fine.Please it has been more than 15-20 days..Please Somebody help.

Answer 9

Hello,

Thanks for your kind answer. I give 2 last links :

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/f006b9f3-5eff-47ca-99ea-f545944f0a5e

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/0fe8299a-ddc9-448b-91b2-d889882db4a1

more generally :

http://social.msdn.microsoft.com/Search/en-US/sqlserver?query=Debug%20T-SQL&rq=meta:Search.MSForums.GroupID(1794d07f-9d4e-4dc0-8c1c-8bfe9d5e0bce)+site:microsoft.com&rn=All+SQL+Server+Forums

and i move your thread towards the SQL Server Tools Forum

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 10

Hello,

I hope you will find a quick and full answer to your problem in this forum which, according to me ) is a more appropriate one.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 11

Hi Normad,

Have done everything possible and i am fed up of this now.,nothing works.Please help me out.

Have seen some other thread.if required i can give detailed description of my scenario.

Regards

Rahul

Answer 12

Did you get any success?

Answer 13

no linda.

Please tell me a way though visual studio 2008 in case if it is not possible with sql server 200R2  as of now.

Answer 14

Hello Trehan11,

You mentioned it does works when you work local, Is there a chance that when you connect from your client, you are using a different user, than the one you use when you access locally? if that is the case your client user might lack of enough privileges

See the below link that specifies the privileges a user should have to properly use debugging.

http://msdn.microsoft.com/en-us/library/ms164014%28v=sql.90%29.aspx

Please let us know if that helps.

Answer 15

Hi Alexander,

The user im using locally to connect is domain user and same with remotely on my client.the code just executes without debugging.One thing i want to know from you guys is that is remote debugging is supported in sql server 2008 R2 standard edition?If yes please help me out if no please suggest me away to debug remote sql stored procedures through Visual studio

Regards

Rahul Trehan

Answer 16

Hi All,

Please help have tried everything but in vain for last 4 months ive been trying.Please help me out.

Regards

Rahul Trehan

Answer 17

Guys any update regarding this??