The service did not respond to the start or control request in a timely fashion, you need administrator privileges to be able to start/stop this service

Posted on 2007-07-28
Last Modified: 2013-11-26
I am trying to teach myself SQL Server as part of an ongoing E-Commerce project. I am using on online tutorial that tells me as Step 1 to open the Surface Area Configuration and then open Surface Area Configuratgion for Features. However, when I try to do that I get a message that says "To configure the Surface Area, one of more services for the Database Engine or Analysis Services or Reporting Services must be running. (SQLSAC)"

I have searced for all sorts of solutions only to keep getting the same message. At one point it did come into question if I had correct administrative rights and I did try to grant privledges to myself only to get the message "An error has occured while trying to establish a connection to the server. When connecting to SQL Serever 2005, this failure may be caused by the fact that under default settings SQL server does not allow remote connections. (provider; SQL Network Interfaces, Error 26 - Error Locating Server - Instance Specified)

I feel now like I am going in circles! Any help much appreciated.

The service did not respond to the start or control request in a timely fashion, you need administrator privileges to be able to start/stop this service
Question by:bpfsr
    LVL 19

    Expert Comment

    are you the administrator of server and the sql administrator?

    Author Comment

    I would guess so - its my computer - how do i check for sure?
    LVL 19

    Expert Comment

    right click my computer
    click manage
    expand users and groups
    look under the administrators group
    does your login ID exist there?

    if not, can you add it? - if it does'nt exist or you r can't add it, then you aren't the admin

    if you can,. then,...
    we should verify in SQL

    open the sql server manager and connect
    open security
    open logins
    verify builtin\admins exists

    Author Comment

    I have "Local User and Groups" and in that I have "Users" and "Groups" - I don't have an "Administrators" Folder. However, when I check my logon name in the Users Folder my logon is there and it is listed as an administrator. I did the sql server management and builtin\admins does exist
    LVL 19

    Accepted Solution

    did you ever get your problem resolved?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now