Re: Windows Services Security

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

  • Next message: K-Dub: "Nested Calls within COM+ components and SetComplete" 
    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
    >
    >
    >
    >
    >

  • Next message: K-Dub: "Nested Calls within COM+ components and SetComplete"

    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.languages.vb)
    • 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)