Post reply

SQL Server 2005:ailed to execute registration stored procedure

  • February 25, 2008 at 7:22 am

    #182553

    I have a SQL Server 2005 db that serves as a backend to Office Communication system. This tool was unable to read from the backend db and the error it gave is: failed to execute registration stored procedure

    I set up a trace in profiler and see the following issue:

    the server principal (office communicator login) is not able to access msdb under the current security context.

    how can I resolve this?

  • February 25, 2008 at 8:21 am

    #781571

    Sounds like your communication server doesn't have rights to connect. Have you checked if this account has rights in SQL Server?

  • February 25, 2008 at 8:24 am

    #781575

    How can i check that?

    I am just baffled as the system was able to connect just fine to the db, but then over the weekend security patches were installed. The db has windows authentication in place. Why would I run into this issue now?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply