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

SQL Server 2005 Setup - Components to Install are grayed out Expand / Collapse
Author
Message
Posted Thursday, March 5, 2009 3:20 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 3, 2014 6:36 PM
Points: 39, Visits: 138
I'm trying to install SQL 2005 on my laptop. I've done this before with the same discs, but this time when I get to area to select components, they are not available.

Can someone please help.

Thanks,

Jeff
Post #669753
Posted Thursday, March 5, 2009 3:26 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 1,893, Visits: 3,932
Hello

This is a little to less information. Did the system configuration check report any warnings or errors?

Which components are disabled?

Which OS? Which edition of SQL Server?

Greets
Flo



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #669756
Posted Thursday, March 5, 2009 3:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 3, 2014 6:36 PM
Points: 39, Visits: 138
Background Information
1. SQL Server 2005 Enterprise Edition
2. Laptop running Windows XP Profession Version 2002 Service Pack 2
3. 3.25 Gig of Memory
4. 50.7 Gig of Free Space

I had been running SQL 2005 instance on this laptop for many years. Something with the latest Windows Updates corrupted my SSIS installation. What I found on the internet was to resolve the issue to un-install SQL 2005 (big mistake). Now I'm trying to re-install and I'm haveing no luck.

Let me know what other information you need.

Thanks,

Jeff

Post #669764
Posted Thursday, March 5, 2009 3:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 3, 2014 6:36 PM
Points: 39, Visits: 138
Configuration Check reported two Warnings.

1. - SQL Server Edition Operating System Compatibility (Warning)
Messages
SQL Server Edition Operating System Compatibility

Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.


2. - COM Plus Catalog Requirement (Warning)
Messages
COM Plus Catalog Requirement

If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.
Post #669769
Posted Thursday, March 5, 2009 3:51 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 1,893, Visits: 3,932
Hello Jeff

It is not possible to install an Enterprise Edition on a XP operating system. You can only install an Express, Compact or Developer edition on a client OS.

The only things you can install on XP from an Enterprise CD are:
* Client Connectivity (MADC)
* SQL Server Management Studio

The Enterprise Edition requires an Enterprise or Data-Cener Server Edition as operating system.

See http://www.serverintellect.com/support/sqlserver/sql-enterprise-req.aspx or further information on Microsoft page.

Greets
Flo



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #669783
Posted Thursday, March 5, 2009 3:56 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 3, 2014 6:36 PM
Points: 39, Visits: 138
I'm at a loss. I swear I used the same disks to install my previous local instance.

Does SQL Express have a SSIS component?

I'm going to go have a drink now.

Thanks,
Post #669786
Posted Thursday, March 5, 2009 4:04 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 1,893, Visits: 3,932
Hello Jeff

No, sorry. SSIS are only part of Stadard and Enterprise and Developer Editions.

See comparsion at http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx .

If you only use the SQL Server (and all its components) only for non-productive work you should use Developer Edition. It contains all features of an Enterprise Edition but it runs on XP/Vista ;) . See http://www.microsoft.com/sqlserver/2008/en/us/developer.aspx .

The pricing is quiet fair http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx .

Greets
Flo



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #669791
Posted Thursday, March 5, 2009 4:14 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 3, 2014 6:36 PM
Points: 39, Visits: 138
How fair?

Thanks,

Post #669802
Posted Thursday, March 5, 2009 4:17 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 3, 2014 6:36 PM
Points: 39, Visits: 138
$50, that is amazing.

Post #669806
Posted Thursday, March 5, 2009 4:24 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, December 8, 2014 6:26 PM
Points: 942, Visits: 1,069
Aye BEST thing Microsoft did .. who said they are money hogging big corporate jerks?

:P.

It's just like enterprise edition just can't use it as production :)


---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.


How to ask for help .. Read Best Practices here.
Post #669812
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse