Post reply

I am the DBO and I still get this error message -> Login is not the DBO of database master so cannot run SQLMAINT.EXE.

  • June 14, 2004 at 11:21 am

    #152183

    My backup log files are filled with this entry....

    Login '' is not the DBO of database 'xxxx' so cannot run SQLMAINT.EXE.

    -I have made myself the DBO of the databases in question.

    -I created the maintenance plans under the same ID that is the DBO.

    -All of the related jobs are owned by the same ID that is the DBO.

    I still get this error message.  What am I missing?

     

     

     

  • June 14, 2004 at 12:34 pm

    #510332

    sqlmaint.exe is run by the login running the services of SQLSERVERAGENT. Check the Windows Services and see who is running it.

  • June 14, 2004 at 2:08 pm

    #510342

    The login running the service is the same ID that is the dbo, owns the jobs, and is the sysadmin of the system.  Anything else I could check?

  • June 14, 2004 at 5:02 pm

    #510360

    Actually look at the Agent properties itself in EM. On the last tab there is a connection item. By default it is Windows Auth make sure is still that way.

  • June 15, 2004 at 7:58 am

    #510455

    I checked the agent properties and it is the same profile (mine) that is set to start up the service.  This is the same ID that owns the jobs, is the sysadmin and dbo in the sql server.  Now, I did notice that the actual SQL Server is set to start up under a different ID (one of our system IDs).  Could this be the culprit?

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

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