Setting up to sql server and 2008 for debugging


I need to debug a stored procedure from my IDE.  
My SQL Server 2005 is on my VPS.  
From my IDE I can view my database and in my web config file I connect to it using a username and password.  No problems.
However, now when I need to debug a stored procedure, I receive a message that I must use Windows Authentication.  
How do I assign these rights on my desktop and my database?

Who is Participating?
Manoj PatilConnect With a Mentor Sr. Software EngineerCommented:
Check out the following link:-
You have to use integrated security to be true.
Manoj PatilSr. Software EngineerCommented:
SheritlwAuthor Commented:
Maybe my question wasn't clear, but my connection string is fine. I use an IP address within my connection string to access my remote sql server 2005.  I have full access to the remote Windows 2008 r2 server.

I need to know how to configure my sql server/ to allow debugging in my IDE.  When I try to allow it within my IDE, I get the following error...

"You must enable app debugging on a connection that uses Windows authentication and that connection must have sysadmin rights to the server"

How do I set up my remote sql server 2005 and/or my 2005 to allow debugging?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.