Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2005 Surface Area Configuration not showing Database Engine component Expand / Collapse
Author
Message
Posted Friday, July 17, 2009 4:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 28, 2012 9:12 AM
Points: 9, Visits: 98
After installing and working with SQL server 2005 for some time I finally go to where I need to use database mail. Realizing it was not configured I found documentation to set it up. However when I got to the part where one used the Surface Area configuration only the Analysis Services component appears. The Database Engine component does not. Can anyone tell me what I need to do to make that component appear?

thanks
Post #755191
Posted Sunday, July 19, 2009 12:06 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 4:47 AM
Points: 93, Visits: 310
Hi,

This is pretty much strange. I would like you to check setup files to see if it was succesfully installed (means components).

Please also let us know if there is any other editon of SQL runing on this machine like SQL 2000 or 2005.

Regrads
GURSETHI
Post #755368
Posted Tuesday, July 28, 2009 12:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 28, 2012 9:12 AM
Points: 9, Visits: 98
This was an in-place upgrade of SQL Server 2000 to 2005. I have since attempted to change the compatibility level of the database to 90 and it is not an option. As was stated it appears that the installation/upgrade did not go as planned.
Post #760997
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse