Solved

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

Posted on 2012-03-31
4
536 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

OfficeMate Freezes on login or does not load after login credentials are input.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
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…

749 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