Installing SQL Server 2005 Standard Edition on Win XP Home ?

My other machine is Win XP Home.
During installation, the following are greyed out:
1. SQL Server Database Services
2. Analysis Services
3. Reporting Services
4.Notification Services
5. Integration Services
This is the only option that is not greyed out:
6. Workstation components, books online & development tools
Is it correct that on Win XP Home I can not install SQL Server 2005
Standard Edition ?
> Is it correct that on Win XP Home I can not install SQL Server 2005
> Standard Edition ?
Correct. You can install Dev Ed and Express. See:
http://msdn2.microsoft.com/en-us/library/ms143506.aspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<fiefie.niles@.gmail.com> wrote in message
news:1179668660.544623.163840@.o5g2000hsb.googlegro ups.com...
> My other machine is Win XP Home.
> During installation, the following are greyed out:
> 1. SQL Server Database Services
> 2. Analysis Services
> 3. Reporting Services
> 4.Notification Services
> 5. Integration Services
> This is the only option that is not greyed out:
> 6. Workstation components, books online & development tools
> Is it correct that on Win XP Home I can not install SQL Server 2005
> Standard Edition ?
>

Installing SQL Server 2005 Standard Edition on Win XP Home ?

My other machine is Win XP Home.
During installation, the following are greyed out:
1. SQL Server Database Services
2. Analysis Services
3. Reporting Services
4.Notification Services
5. Integration Services
This is the only option that is not greyed out:
6. Workstation components, books online & development tools
Is it correct that on Win XP Home I can not install SQL Server 2005
Standard Edition ?> Is it correct that on Win XP Home I can not install SQL Server 2005
> Standard Edition ?
Correct. You can install Dev Ed and Express. See:
http://msdn2.microsoft.com/en-us/library/ms143506.aspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<fiefie.niles@.gmail.com> wrote in message
news:1179668660.544623.163840@.o5g2000hsb.googlegroups.com...
> My other machine is Win XP Home.
> During installation, the following are greyed out:
> 1. SQL Server Database Services
> 2. Analysis Services
> 3. Reporting Services
> 4.Notification Services
> 5. Integration Services
> This is the only option that is not greyed out:
> 6. Workstation components, books online & development tools
> Is it correct that on Win XP Home I can not install SQL Server 2005
> Standard Edition ?
>sql

Installing SQL Server 2005 Standard Edition on Win XP Home ?

My other machine is Win XP Home.
During installation, the following are greyed out:
1. SQL Server Database Services
2. Analysis Services
3. Reporting Services
4.Notification Services
5. Integration Services
This is the only option that is not greyed out:
6. Workstation components, books online & development tools
Is it correct that on Win XP Home I can not install SQL Server 2005
Standard Edition ?> Is it correct that on Win XP Home I can not install SQL Server 2005
> Standard Edition ?
Correct. You can install Dev Ed and Express. See:
http://msdn2.microsoft.com/en-us/library/ms143506.aspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<fiefie.niles@.gmail.com> wrote in message
news:1179668660.544623.163840@.o5g2000hsb.googlegroups.com...
> My other machine is Win XP Home.
> During installation, the following are greyed out:
> 1. SQL Server Database Services
> 2. Analysis Services
> 3. Reporting Services
> 4.Notification Services
> 5. Integration Services
> This is the only option that is not greyed out:
> 6. Workstation components, books online & development tools
> Is it correct that on Win XP Home I can not install SQL Server 2005
> Standard Edition ?
>

Installing SQL server 2000 on xp machine

Is it possible to install sql server enterprise edition on an xp machine (home or professional)? I tried both (w/sp2) and it said it can only be run as a client.You can install Personal, Developer, and MSDE only.|||You can install Personal, Developer, and MSDE only.
You can install ent on a client but you wont get the rdbms only the tools.
this is so you wont have to buy another copy of the media to administer your sql servers.
you will install the client process on your xp pc and then register your production servers with your client tools.

as rdjabarov said so cryptically. you can however if you want to practice with a rdbms locally, you can load the professional edition or the developer edition. and sql cute (MSDE)
i preferr the dev. edition because it is much cheaper.

I prefer the developer edition because it's cheaper (http://www.microsoft.com/sql/howtobuy/development.asp)

Installing SQL Express - XP Home

Hi,

We're creating an installer package for SQL Express 2005 and I'm using the built-in setup project in VS 2005 to create my MSI.

Everything appears to be working well, excpet that on Windows XP Home the SQL Express package is exiting with an error code 70002. I've googled for several days now and simply can't find any help on the 70002 exit code. Can anyone help ?

The command line arguments (I've split them onto seperate lines for clarity) we're passing to "sqlexpr32.exe" are : -

/qn

INSTANCENAME=OurInstance

SAPWD="OurPassword"

ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity

SQLBROWSERAUTOSTART=1

SQLACCOUNT="NT AUTHORITY\SYSTEM"

SQLBROWSERACCOUNT="NT AUTHORITY\SYSTEM"

AGTACCOUNT="NT AUTHORITY\SYSTEM"

ASACCOUNT="NT AUTHORITY\SYSTEM"

RSACCOUNT="NT AUTHORITY\SYSTEM"

SECURITYMODE=SQL

DISABLENETWORKPROTOCOLS=0

SQLAUTOSTART=1

Are you getting an error in the logs? Can you search your log folder for the text string "value 3" and post the 10 or so lines above it? This should give a more helpful message.

Thanks,
Sam Lester (MSFT)

installing sql 2005 standard on vista home premium

I have not been able to get iis to be seen correctly. I have turned on every service with IIS7 available and still get warning IIS in not running. I have changed computer name to all caps and I am running on admin account. I see IIS7 when I run localhost. What is wrong here. When I go on to install system I get stuck at detecting installed IIS. As I move forward with install owc, DB services,Notification, Intagrated, and workstation components all fail. I cant move onto sp2 because nothing is installed. I have worked on this for months off and on and now I have to have it running for deadline. Any help would be appreciated. I also have VS2005 and office 2007 on this system. I have worked on this the past two days solid and I have to have it now.

Jeff

when the install fails, what do you see in the files under the log folder under setup bootstrap?|||

Thanks Meher,

I had to uninstall all of the office components and then I was able to get past OWC11. Then I still failed with all the others. I then installed sp2. I then went back and did a mimimal install and it worked. Then I went back and reran sp2. Then I went back and did a complete reinstall and reran sp2. I now have DB on vista. On troublesome problem still is IIS7 I enabled everything I could restarted it and still system did not see it. Different forum and different issue I suspect.

Again Thanks for the williness to help.

Jeff

It would be nice put out updated install directions for sql 2005 standard(different flavors) on VISTA(different flavors). Maybe they did but hours of searching did not produce them.