SQL Admin

From: Ronaldo (ronaldo_aquino@excite.com)
Date: 11/28/02


From: "Ronaldo" <ronaldo_aquino@excite.com>
Date: Wed, 27 Nov 2002 16:27:51 -0800


Give him/her access to the server's Services and
Applications, i.e. using MMC. This way the DBA can simply
stop/start SQL services without logging into the server.

>-----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!
>.
>



Relevant Pages

  • Re: Rights for a DBA
    ... You can do as Steve has said to give them start/stop etc permissions ... on the services of SQL, and also make sure that you have given them ... Server is not configured to run as Local System. ... > not give him Administrator rights to the Windows 2000 server itself. ...
    (microsoft.public.windows.server.security)
  • Re: Create a minimun rights account
    ... only a user with administrator rights can logon locally ... to the server. ... I still don't understand why a user would need to use the SQL ... > permission to do any other things on the SBS machine. ...
    (microsoft.public.windows.server.sbs)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)