Re: SQL Admin
From: Bruce Prang [MS] (bprang@online.microsoft.com)
Date: 11/23/02
- Next message: Mary Chipman: "Re: SQL Injection"
- Previous message: Eduardo Goto: "SQL Admin"
- In reply to: Eduardo Goto: "SQL Admin"
- Next in thread: Ronaldo: "SQL Admin"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Bruce Prang [MS]" <bprang@online.microsoft.com> Date: Fri, 22 Nov 2002 16:24:57 -0800
The problem is he doesn't have rights to start the service. Check out KB
288129, it shows how to grant others the rights to control services.
http://support.microsoft.com/default.aspx?scid=kb;en-us;288129
-- This posting is provided "AS IS" with no warranties, and confers no rights. "Eduardo Goto" <enoron@hotmail.com> wrote in message news:1111101c2926a$ccb1aca0$8df82ecf@TK2MSFTNGXA02... > > Put the programmer's login like SQL services owner in the > administrative tools. I guess that's the unique way. > > > > >-----Original Message----- > >I have an SQL 2000 programmer that needs to be able to > >restart SQL server often. > > > >The problem is, I cannot give him administrator rights, > >for instance to log directly on the 2000 server. > > > >Is there anyway to allow this without relinquishing > >administrator rights? > > > >Thanks! > >. > >
- Next message: Mary Chipman: "Re: SQL Injection"
- Previous message: Eduardo Goto: "SQL Admin"
- In reply to: Eduardo Goto: "SQL Admin"
- Next in thread: Ronaldo: "SQL Admin"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
