SQL cache dependency polling failed for SQL database 'MyDatabase' because of permission problem.

Last post 07-04-2008 1:07 PM by anthonypj. 1 replies.

Sort Posts:

  • SQL cache dependency polling failed for SQL database 'MyDatabase' because of permission problem.

    07-04-2008, 9:57 AM
    • Loading...
    • anthonypj
    • Joined on 05-11-2007, 11:31 AM
    • Posts 274

    I hope soemone can help me with thte following driving me crasy ...

    I have sql cache dependency working fine on local machine when i move app up to development server and try and run via virtual dir I recieve the above error.

    Remote access to database is granted to via guest user role , which has select , connect, update and insert permissions

    How can i set approaite permissions to allow polling of database 

    many thanks

    ps app runs fine when run via visual studio  

     

  • Re: SQL cache dependency polling failed for SQL database 'MyDatabase' because of permission problem.

    07-04-2008, 1:07 PM
    • Loading...
    • anthonypj
    • Joined on 05-11-2007, 11:31 AM
    • Posts 274

    for those how may be interested i managed to resolve this by giving the guest user role execute permissions under Server Management Studio , althought slighty worried about settign this permission as not sure  what else setting this permission will allow

     

     

     

Page 1 of 1 (2 items)
Microsoft Communities
Page view counter