Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2012-03-31
4
Medium Priority
?
550 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 total points
ID: 37793479
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This article explains how to install and use the NTBackup utility that comes with Windows Server.
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 show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

609 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