Hitting Sql Server Stored Procedure Breakpoint from ASP.NET app

Hello,
I am not able to stop at a stored procedure breakpoint in SQL Server from an
ASP.NET application unless I specify a username and password in my connection
string instead of using integrated security = SSPI. I can't figure out how to
give the ASP.NET user the ability to debug stored procedures. I tried running
sp_sdidebug 'legacy_on' from my ASP.NET app so it would run undere the
ASP.NET user, but that didn't help. Still can only do it by specifying a
different user in DB connection string. Is it possible to give ASP.NET user
debugging rights in SQL Server?
Thanks

.

Relevant Pages

  • Re: OLEDB Session Error
    ... around - it just cleared the variable and boom - my connection string was set ... "Gayle" wrote: ... I am executing this stored procedure from an application written ... >> I assume that you are using ADO to connect to SQL Server? ...
    (microsoft.public.data.oledb)
  • Re: using VBA to insert records from access database to sql server
    ... I don't think you can specify a connection string *within* a query like ... My preferred solution to this kind of problem would be to use ODBC to link ... the Access MDB and the SQL Server table. ...
    (microsoft.public.access.modulesdaovba)
  • Re: ASP.net insists on using dbo. to call aspnet_* stored procedures
    ... The easiest way to get around this is to use the sp_changeobjectowner stored procedure which will ... SQL Server 2000 developer in same machine. ... connection string is setup to use the sql login assigned to the ... connectivity problem than a dbo problem. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Was Create Stored Procedure wizard droped from SQL Server 2005
    ... In SQL server 2005 management studio, you can use the "Specify Values for ... connect to an instance of SQL Server 2005 Database ... Right-click Stored Procedures, and then click New Stored Procedure. ... click Specify Values for Template Parameters. ...
    (microsoft.public.sqlserver.tools)
  • Re: Linked Server - Force Translate
    ... I had the same issue when using a connection string with same ... > see sp_addlinkedserver in Books Online for details. ... > You can also use OPENROWSET and specify a connection string with it. ... > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...
    (microsoft.public.data.oledb)