• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 554
  • Last Modified:

Setting up to sql server and asp.net 2008 for debugging

Hi,

I need to debug a stored procedure from my asp.net IDE.  
My SQL Server 2005 is on my VPS.  
From my asp.net 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 asp.net and my database?

Thanks,
0
Sheritlw
Asked:
Sheritlw
  • 2
1 Solution
 
TempDBACommented:
Check out the following link:-
You have to use integrated security to be true.

http://stackoverflow.com/questions/5642474/setting-up-connection-string-in-asp-net-to-sql-server
0
 
Manoj PatilSr. Software EngineerCommented:
0
 
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/asp.net 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 asp.net 2005 to allow debugging?
0
 
Manoj PatilSr. Software EngineerCommented:
0
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.

Join & Write a Comment

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now