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