Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2827
  • Last Modified:

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

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
0
bpfsr
Asked:
bpfsr
  • 3
  • 2
1 Solution
 
William ElliottSr Tech GuruCommented:
are you the administrator of server and the sql administrator?
0
 
bpfsrAuthor Commented:
I would guess so - its my computer - how do i check for sure?
0
 
William ElliottSr Tech GuruCommented:
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
0
 
bpfsrAuthor Commented:
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
0
 
William ElliottSr Tech GuruCommented:
did you ever get your problem resolved?
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now