Options Unavaiable with SQL Server Express 2005 SP3

I'm running the SP3 update on a SQL Server 2005 DB (SQLServer2005SP3-KB955706-x86-ENU.exe).  I've reached the Feature Selection page of the Wizard.  (See image.)  I'm unable to check 5 of the boxes: BKUPEXEC, BKUPEXEC Database Services, MSSQLSERVER, MSSQLSERVER Database Services, and Client Components.  My inability to check two of these five boxes: MSSQLSERVER and MSSQLSERVER Database Services is worrying me.  Are these boxes disabled because I'm running SP3 on an Express instance of SQL Server?  Or, is the SP3 installation broken.  Permissions are not an issue.  (Or at least they shouldn't be.)  I logged on as a Domain Admin.  (Hence, I'm in the sysadmins server role.)
jdanaAsked:
Who is Participating?
 
deadlyDevCommented:
I would assume that this is because these features are already installed, these check boxes will probably be available if the machine in question had only certain components installed before.
0
 
jdanaAuthor Commented:
Deadlydev,

That makes sense.  So how can I tell what SP has been installed with SQL Server?  I've attached an image of the Server Properties.  Is it hidden in the 9.00.1399.06 value?  Somewhere else?
Server-Properties.jpg
0
 
deadlyDevCommented:
Check out:
http://support.microsoft.com/kb/321185

In short...

RTM      2005.90.1399
SQL Server 2005 Service Pack 1      2005.90.2047
SQL Server 2005 Service Pack 2      2005.90.3042
SQL Server 2005 Service Pack 3      2005.90.4035

In other words you dont have any service packs installed...
0
 
deadlyDevCommented:
Were you happy with this answer? Can this question be closed?
0
 
jdanaAuthor Commented:
Sorry for the slow response.  I was very happy with the answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.