Post reply

Operator not starting in SQL 2000

  • May 10, 2007 at 7:19 am

    #172365

    When I am trying to setup a new Operator on a SQL 2000 box and when I try to test a new Operator I receive the following error.

    Microsoft SQL-DMO(ODBC SQLState: 42000)

    Error 22003: OpenService() returned error 5, 'Access is denied'.

    Has anyone seen this error before?  I have setup numerous operators and have not had this issue.  My research on the web has not led me to any solid leads to a fix either.

    Thanks

    Kevin

  • November 13, 2007 at 8:16 am

    #750705

    I'm now with the same problem.

    any solution?

  • November 13, 2007 at 11:19 pm

    #750950

    Is the new operator a windows account user. OS error corresponds to permissionproblem either accessing the winows files or registry keys.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • November 14, 2007 at 1:24 am

    #750979

    The user is domain admin, local admin, and has a login defined as sysadmin in sql

    I checked local domain pol, but still the same problem apears

Viewing 4 posts - 1 through 4 (of 4 total)

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