Solved

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

Posted on 2012-03-31
4
532 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
ID: 37792880
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
ID: 37793119
0
 

Author Comment

by:Sheritlw
ID: 37793290
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
ID: 37793479
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

856 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