Re: Windows Services Security

From: Ron (noone_at_nowhere.com)
Date: 02/18/05 

Date: Fri, 18 Feb 2005 06:59:16 -0000

Hi Arvind.

Are you debugging your SQL code on that database?

If so, you have to grant execute permission to the 'sp_sdidebug' stored
procedure.
Example

use master
grant execute on sp_sdidebug to public
go

Visual Studio help has some information about SQL debugging.

HTH

"Arvind P Rangan" <arvind99@hotmail.com> wrote in message
news:ORBk5yK#EHA.2156@TK2MSFTNGP10.phx.gbl...
> Hi all,
>
> We are writing a service which tries to access two database server on
> different network.
>
> while connecting to one of the database it give error saying 'EXECUTE
> permission denied on object 'sp_sdidebug', database 'master', owner
'dbo''.
>
> But if we are trying to connect to the same Database with any web or
windows
> application it does not raise any error and we are able to connect to that
> DB.
>
> We have also written the same service in VB6 which is working fine.
>
> Thanks for your help
> Arvind
>
>
>
>
>

Relevant Pages

  • Re: Windows Services Security
    ... Are you debugging your SQL code on that database? ... you have to grant execute permission to the 'sp_sdidebug' stored ... Visual Studio help has some information about SQL debugging. ...
    (microsoft.public.dotnet.framework.component_services)
  • Re: Changing Permissions for all Stored Procs in a SQL2005 DB
    ... already created the database role, if I do "GRANT EXECUTE TO MyNewRole", ... In SQL Server 2005 it is very easy to set the execute rights to all ...
    (microsoft.public.sqlserver.security)
  • Re: a bit tricky question
    ... Mike wrote: ... > it from database B under y schema. ... > How to work it out without grant execute to public? ...
    (comp.databases.oracle.server)
  • Re: SQL Accounts
    ... Below is a script that will grant execute permissions to the specified role ... on all user procedures in the current database. ... DECLARE GrantStatements CURSOR ... >> Assign the user db_datareader and db_datawriter database fixed roles. ...
    (microsoft.public.sqlserver.security)
  • Re: Starting OOP
    ... > It would be a good idea to create a database abstaction class. ... >>class PurchaseOrder ... >>...INSERT SQL CODE ... var $ponum; ...
    (php.general)