February 11, 2008 at 4:29 am
😀 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.
( -:unsure:- 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 8:14 am
The bare minimum rights you are going to need is access to the Microsoft SQL Server/MSSQL.1 folder. In this folder contains the SQL Server, SQL Server Agent, etc... executables.
Once you have rights you should be able to start the services.
February 11, 2008 at 8:23 am
These rights i have : e bare minimum rights you are going to need is access to the Microsoft SQL Server/MSSQL.1 folder. In this folder contains the SQL Server, SQL Server Agent, etc... executables.
But i cannot start the service: SQL Server service in windows ,or is there another place ( maybe Enterprise Manager ) where i can start thisService. ?? (Access Denied )
soo ..! ??
February 11, 2008 at 8:49 am
If you do not have the rights to the binaries in the Binn directory you need to talk with your Network admin to give you permissions to that directory tier.
IF you open Studio Manager and click on the SQL Server, then right-click and connect do you get an access denied message as well?
February 12, 2008 at 2:47 am
Having rights to access the SQL binaries makes no difference to you being able to start/stop the SQL services. You need the following rights on the SQL Services, which are often controlled by GPOs: Read, Write, Start/Stop/Pause.
If you do not have local admin rights on the box, you will not be able to see the SQL processes in Task Manager. Period. There is no workaround.
You may find http://www.codeplex.com/SQLServerFineBuild helpful. I published this to help give a 1-click install and configuration of SQL Server 2005. The section on GPO setup should clarify some things, even though some items do not apply to SQL Server 2000.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 12, 2008 at 2:56 am
i get SQL Server 'properties' so that's OK..!!
February 12, 2008 at 3:57 am
Get the phone number of the Managing Director (or the Network Admin) person, and when you need to stop/start services at 2am, just direct the support call to that number. The problem will be solved fairly quickly.:D
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply