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?