Solved

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

Posted on 2012-03-31
4
524 Views
Last Modified: 2012-04-01
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
Comment
Question by:Sheritlw
  • 2
4 Comments
 
LVL 25

Expert Comment

by:TempDBA
Comment Utility
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
 
LVL 19

Expert Comment

by:Manoj Patil
Comment Utility
0
 

Author Comment

by:Sheritlw
Comment Utility
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
 
LVL 19

Accepted Solution

by:
Manoj Patil earned 500 total points
Comment Utility
0

Featured Post

Wish Marketing would stop bothering you?

Is your marketing department constantly asking for new email signature updates? Are they requesting a different design for every department? Do they need yet another banner added? Don’t let it get you down! There is an easy way to manage all of these requests...

Join & Write a Comment

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now