Post reply

Local admin or struggling' for enough DBA rights ?

  • February 11, 2008 at 5:25 am

    #70798

    An everyday struggling for 'DBA' rights on the SQL server 2000 with the Windows-administrator drives me nuts.

    1) Now i cannot STOP/START the SQL Server Service.

    which rights does i need to fullfill this task.

    ( -- i think: rights on the SQl Server Service and SQL Server agent ( dependency )

    2 ) NOR i can see ALL the processes

    i just can see MY own processes.

    which right do i need for this .. ( i think Local admin rights ? )

    Ruud

  • February 11, 2008 at 10:00 pm

    #777207

    We need either a local or a domain account to start SQL Server.

    We need either a local or a domain account to start SQL Server agent.

    Where did you view processes? It seems we need sa privilege to view all processes in EM. But it is not true in QA.

  • February 12, 2008 at 1:23 am

    #777227

    what do you mean with : But it is not true in QA. ??

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

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