SQL Server 2005 Surface Area Configuration not showing Database Engine component

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL Server 2005 Surface Area Configuration...

SQL Server 2005 Surface Area Configuration not showing Database Engine component

Rate Topic

Display Mode

Topic Options

Author

Message

ftornoe-704611

Posted Friday, July 17, 2009 4:32 PM

Forum 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

GURSETHI

Posted Sunday, July 19, 2009 12:06 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, April 26, 2013 12:57 PM
Points: 92, Visits: 280

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

ftornoe-704611

Posted Tuesday, July 28, 2009 12:09 PM

Forum 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 »

Permissions