We help IT Professionals succeed at work.
Get Started

SQL 2005 SP2 Surface Area Configuration error

760 Views
Last Modified: 2012-05-06
Hi

Environment:
Windows 2003 Ent Editon SP2 x86

I have an issue with one of my SQL 2005 Ent Edition SP2 servers (member server) where I have an issue using Surface Area Configuration.

When I open an run SAC Features I get the following error:
To configure the surface area, one or more services for the Database Engine or Analysis Services or Reporting Services must be running. (SQLSAC)
Program Location:

   at Microsoft.SqlSac.MainPanel.FormFeatures..ctor(String machineName, Form callingForm)


I have checked all services and all are fine - I have even rebooted the server with no reported issues.

I can change the setting to a remote SQL server and it works fine???
If I try from a remote server, I get the same error as if I tried it locally on this particular server.

I have checked event logs etc and nothing is standing out - I have also checked the usual inet forums but no joy?
Any ideas?

Cheers
Bry



Comment
Watch Question
Senior Cloud Engineer
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE