SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2005 Setup - Components to Install are grayed out


SQL Server 2005 Setup - Components to Install are grayed out

Author
Message
jpalmer-755805
jpalmer-755805
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 171
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
Florian Reischl
Florian Reischl
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3525 Visits: 3934
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
jpalmer-755805
jpalmer-755805
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 171
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
jpalmer-755805
jpalmer-755805
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 171
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.
Florian Reischl
Florian Reischl
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3525 Visits: 3934
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
jpalmer-755805
jpalmer-755805
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 171
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,
Florian Reischl
Florian Reischl
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3525 Visits: 3934
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 Wink . 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
jpalmer-755805
jpalmer-755805
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 171
How fair?

Thanks,
jpalmer-755805
jpalmer-755805
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 171
$50, that is amazing.
Mohit K. Gupta
Mohit K. Gupta
UDP Broadcaster
UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)

Group: General Forum Members
Points: 1434 Visits: 1089
Aye BEST thing Microsoft did .. who said they are money hogging big corporate jerks?

Tongue.

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

---

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. Smooooth


How to ask for help .. Read Best Practices here.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search