disabled component to install

Question

disabled component to install

arazsaie

Grasshopper

Points: 19
More actions
February 18, 2008 at 9:14 am

#179213

Hello everybody,
I have question ablout the installing SQL Server 2005 in the windows XP profesional, I always install sql server on my machine with the Windows XP professional edition as usual without any problem but now
I have a strange problem, first on the System configuration stepeverything is OK except “SQL Server Edition Operating System Compatibility (Warning) “ ,with this message :
- 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.
Meanwhile the main problem is in the “ Component to install ” window as I don’t see these serises of component checkbox enable! Except the “Worlstation component, books online and development tool “, like this:
sql server database services -->disable
anlysis services -->disable
reporting services -->disable
notification services -->disable
integration services -->disable
Worlstation component, books online and development tool -->enable
And after that I make sure about the serious problem and then I decide to continuing installation with clicking on the enable check box and then I have an instance of SQL Server on my machine but it isn’t compelete .
I tried to solving my problem with unistalling the SQL Server and reinstalling the this software again but this problem still exist, and then I decide to change my window and reinstalling this again , I do that but
It is not work out!!
Therfor if it possible for you please help me to solving my problem, thank you very much

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply

thecosmictrickster@gmail.com SSChampion Points: 10386 More actions · Answer 1

If you have an Enterprise Edition CD then it won't install the database engine etc. You need Standard, Workgroup or Developer Edition (see Books Online: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/09bcf20b-0a40-4131-907f-b61479d5e4d8.htm)

Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

aju-649877 Grasshopper Points: 19 More actions · Answer 2

Thank you Scott, That was a very precise TO-THE-POINT help. Needless to say that it worked for me.

kiran4tech SSC Rookie Points: 25 More actions · Answer 3

Hi I am trying to install SQL server 2005 on Windows XP Home Edition but it is not allowing me to select the components to Install on my Laptop. Can anyone please guide me to install SQL Server.

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 4

Which version of SQL Server 2005 are you trying to install?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

kiran4tech SSC Rookie Points: 25 More actions · Answer 5

I am trying to install sql server 2005 Enterprise edition

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 6

kiran4tech (9/1/2008)
I am trying to install sql server 2005 Enterprise edition

That would require that the machine you are installing it on be running WINDOWS SERVER. It's not gonna work. If you want to install the equivalent of the Enterprise Edition on your laptop and your laptop does not have WINDOWS SERVER running, then you need to break down and buy the Developer's Edition which is the same as the Enterprise Edition with different licensing.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

kiran4tech SSC Rookie Points: 25 More actions · Answer 7

kiran4tech

SSC Rookie

Points: 25

September 2, 2008 at 12:35 am

#865848

Thanks for the information Jeff

-Kiran

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 8

kiran4tech (9/2/2008)
Thanks for the information Jeff
-Kiran

You bet... thank you for the feedback.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ItzMe Ten Centuries Points: 1233 More actions · Answer 9

Can we Install SQL Server 2005 Enterprise Edition on Windows XP Professional Service Pack 2?.............I am trying the same but the "Components to Install Page is not highlighted".............Please Help!!!!!!!!!!

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 10

Absolutely not... if you want to install on some version of Windows for a desktop, you need to buy the Developers Edition... it costs less than a good book on the subject. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

lindaotero SSC Rookie Points: 25 More actions · Answer 11

Hi I have Windows XP professional version 2002 SP2

and when tryig to install sql 2005 "Standard" edition, all the options are gray ...(disable)... the oly one I can install is workstation components, books online and development tools...

please help me... I do not understand!!! windows XP should be compatible with sql 2005 standard edition......

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 12

lindaotero (10/27/2008)
Hi I have Windows XP professional version 2002 SP2
and when tryig to install sql 2005 "Standard" edition, all the options are gray ...(disable)... the oly one I can install is workstation components, books online and development tools...
please help me... I do not understand!!! windows XP should be compatible with sql 2005 standard edition......

But... it's not. You cannot install SQL Server Standard Edition on the Desktop Edition of Windows XP. It must be a Windows Server. Only the Express and Developer Editions can be installed on a desktop version of Windows.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

lindaotero SSC Rookie Points: 25 More actions · Answer 13

in here:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/09bcf20b-0a40-4131-907f-b61479d5e4d8.htm

I can see standard edition is compatible with the XP professional SP2

so again... I do not understand!

Lowell SSC Guru Points: 323518 More actions · Answer 14

compatiblility in that case means it won't fail on install...it'll install the tools no problem.

but as you've noticed it will not install everything. That is by design.

People are a bit confused i guess, because in SQL 2000, if you installed Enterprise or Standard on a NON-Server operating system, it automatically dummied itself down to a Development version instead of Enterprise or Standard.

SQL 2005 does not do that...repeating what Jeff said a couple of times already, if you want to have the db engine on a non-server operating system, whether xp or vista, you must install SQL 2005 Express or SQL 2005 Developer versions.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!