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)
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?