Re: SQL2k5 local rights to use

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I suggest you to create service accounts (for instance a normal user account in your domain) for your SQL Server services and set these service accounts to your SQL Server services using SQL Server Configuration Manager. This tool will add the service accounts to the built-in local Windows groups and those groups have sufficient rights on the system to run SQL Server services decently and perform this action using a local admin account.

To be a System Administrator for your SQL Server instance, you can add your domain account to the "sysadmin" Server Fixed Role. You can do this using SQL Server Management Studio. Open it up and then connect to your SQL Server instance and go to Security -> Logins nodes then create a Login for your Windows\Domain account then in the Create Login window go to Server Roles pane and make "sysadmin" checked and proceed. You must have admin rights on the SQL Server instane to perform this task.

--
Ekrem Önsoy



"cksiz" <cksiz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:826FF513-9B16-43E2-AA3E-B5A2A2C0F18A@xxxxxxxxxxxxxxxx
I have had sql2k5 installed on my machine for development purposes. However,
I am only a regular "user" on the machine (and as part of the domain).
Upon trying to configure and use Reporting Services, I get various errors.
Switching myself to local admin allows everything to work.

However, my company will not allow me to remain as a local admin on the
machine.
So question is: What rights do I need on the local machine to be the
database admin, to manage the entire database, and use all of the tools?

All the SQL2k5 services are starting as localservice (which again, works
fine if I am local admin, and as acceptable for a development machine)

I have found that I did not have NTFS permissions to some of the SQL
directories, but have fixed that by giving myself full control and
propogating down. Obviously I have missed something that is preventing me
from having full admin control over the SQL instance (and programs)

.

Relevant Pages

  • Re: Installation - What Account is needed?
    ... I understand you are asking about the required account to install a SQL Server Instance itself. ... there is no any problem with your Domain Admin account in case the questioned SQL Server server is a member of your domain. ...
    (microsoft.public.sqlserver.setup)
  • RE: Error installing (KB 921896)
    ... account on the computer? ... the SQL Server Instance is set to Mixed Authentication ... if the password provided is correct or check to see if the SQL Server ...
    (microsoft.public.windowsupdate)
  • sql server services
    ... all of the sql server services are running as 'Local System' account. ...
    (microsoft.public.sqlserver.security)
  • Re: Specifying a logon account for SQL Server 2005 services
    ... You enable that option when you want your SQL Server to benefit more than 4GB of RAM. ... You use your Local Policy to add your SQL Server service account to "Lock pages in memory" list before you enable AWE. ... When you assign a user for your SQL Server services it'll add the account you specify to the related groups so that that account would have necessary rights to run SQL Server services. ...
    (microsoft.public.sqlserver.security)
  • Re: Cant connect using mixed auth. mode and a windows accounts
    ... your SQL Server 2008 instance is installed on your Windows Server 2008. ... First of all, if you want to set your SQL Server Instance' s Authentication Mode to Mixed Mode, perform the following steps: ... If you are going to be using this SQL Server Instance as a server in your domain environment, then you better create a non-priviledged User Account which is going to be used only as your SQL Server service account. ...
    (microsoft.public.sqlserver.setup)