troubleshooting Question

SQL 2005 SP2 Surface Area Configuration error

Avatar of bryan oakley-wiggins
bryan oakley-wigginsFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL Server 2005DatabasesMicrosoft SQL Server
6 Comments1 Solution762 ViewsLast Modified:
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



ASKER CERTIFIED SOLUTION
bryan oakley-wiggins
Senior Cloud Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros