Link to home
Start Free TrialLog in
Avatar of bryan oakley-wiggins
bryan oakley-wigginsFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL 2005 SP2 Surface Area Configuration error

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



Avatar of reb73
reb73
Flag of Ireland image

Do you have the SQL Browser service running?
Avatar of bryan oakley-wiggins

ASKER

Hi reb73

Thanks for getting back on this.
I do not have this service running (I did start and try the SAC) but still didn't work.
Also, on some of my other SQL server that SAC does work on with no issues,  the sql browser service is disabled.


Is there any SAC validation commands I can run on this server - Or how exactly does SAC interact with the SQL application/OS?

Cheers
Bry
"Is there any SAC validation commands I can run on this server - Or how exactly does SAC interact with the SQL application/OS?"

I'm not sure if SAC can be manipulated by SMO library as I believe it works on a registry level (could be wrong here)..

There could be something wrong with the installation or your user credentials.. Can you check out the links in the thread below (provided in post by Deepak Thangarajan MVP) and see if they help in resolution  -

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/ad081aca-1603-4c2c-a642-4d96ce923064/


hi reb73

Apologies for delay in getting back to your response, only a handful of projects kept me busy :-)
Anyhow, I ran the SCC and could see no errors (attached) -
I also dumped out registry from a like-for-like test server and compared both files - No issue.
I then checkd all file versions etc and again no issues.

I am truly puzzled...
Is there a way to re-install the SAC component as it were?

Cheers
Bry


System Configuration Check

- WMI Service Requirement (Success)
      Messages
      * WMI Service Requirement
      
      * Check Passed
      

- MSXML Requirement (Success)
      Messages
      * MSXML Requirement
      
      * Check Passed
      

- Operating System Minimum Level Requirement (Success)
      Messages
      * Operating System Minimum Level Requirement
      
      * Check Passed
      

- Operating System Service Pack Level Requirement. (Success)
      Messages
      * Operating System Service Pack Level Requirement.
      
      * Check Passed
      

- SQL Server Edition Operating System Compatibility (Success)
      Messages
      * SQL Server Edition Operating System Compatibility
      
      * Check Passed
      

- Minimum Hardware Requirement (Success)
      Messages
      * Minimum Hardware Requirement
      
      * Check Passed
      

- IIS Feature Requirement (Warning)
      Messages
      * IIS Feature Requirement
      
      * Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features.  Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
      

- Pending Reboot Requirement (Success)
      Messages
      * Pending Reboot Requirement
      
      * Check Passed
      

- Performance Monitor Counter Requirement (Success)
      Messages
      * Performance Monitor Counter Requirement
      
      * Check Passed
      

- Default Installation Path Permission Requirement (Success)
      Messages
      * Default Installation Path Permission Requirement
      
      * Check Passed
      

- Internet Explorer Requirement (Success)
      Messages
      * Internet Explorer Requirement
      
      * Check Passed
      

- COM Plus Catalog Requirement (Success)
      Messages
      * COM Plus Catalog Requirement
      
      * Check Passed
      

- ASP.Net Version Registration Requirement (Success)
      Messages
      * ASP.Net Version Registration Requirement
      
      * Check Passed
      

- Minimum MDAC Version Requirement (Success)
      Messages
      * Minimum MDAC Version Requirement
      
      * Check Passed
      

- Edition Change Check (Warning)
      Messages
      * Edition Change Check
      
      * To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.
I have also tried importing SAC settings from a working server but it does not take the settings:

c:\program files\microsoft sql server\90\shared\>sac in FILE

I have tested DCOM and WMI and all seems normal...
IS there any SSMS queries that I could run to replicate what SQLSAC would be doing to enumerate the data from the registry?

Cheers
Bry
ASKER CERTIFIED SOLUTION
Avatar of bryan oakley-wiggins
bryan oakley-wiggins
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial