Is it possible to install SQL Sever 2005 Developer on Vista Home Premium?

During the install, I receive this message:

"Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online."

So, I went to the following and did everything documented about installing IIS 7.0.

http://msdn2.microsoft.com/en-us/library/aa964620.aspx

After installing IIS and verifying that it is serving pages just fine, when I try to install again, I still get the quoted error message above.

I am beginning to think that I cannot install SQL Server Developer on Vista Home Premium.

Does anyone know?

Thanks

Here's a link that should help: http://support.microsoft.com/kb/920201

I was experiencing the same problem. In my case, I did not have Windows Authentication selected when I installed IIS. When I added it, the warning went away.

|||Thanks. I'll try it with Windows Authentication selected.

Is it possible to have reporting services without IIS?

Is it possible to have SQL Express and Reporting Services on XP Home and use
reports locally (like Access)?
ThxOn Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
> Is it possible to have SQL Express and Reporting Services on XP Home and use
> reports locally (like Access)?
> Thx
As far as I know, there is not. That said, I'm not sure how SSRS would
react if you somehow tried to tie it to Apache or some other web
server. Sorry that I could not offer further insight.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks, Enrique
I guess same applies to Advanced Services
MS, please make this available on XP Home too.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>
> As far as I know, there is not. That said, I'm not sure how SSRS would
> react if you somehow tried to tie it to Apache or some other web
> server. Sorry that I could not offer further insight.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||For development purposes you can install sql2005 dev edition (costs $50 or
comes free with VS2005) and you get all the features.
"AlexS" wrote:
> Is it possible to have SQL Express and Reporting Services on XP Home and use
> reports locally (like Access)?
> Thx
>
>|||I asked about WinXP Home and SQL Express Advanced / Reporting, which is
available now from MS site for download.
Thanks for a tip - I will check dev edition.
"Jimbo" <Jimbo@.discussions.microsoft.com> wrote in message
news:9F612C59-BEC7-4854-BF02-C51F8DBFCFD4@.microsoft.com...
> For development purposes you can install sql2005 dev edition (costs $50 or
> comes free with VS2005) and you get all the features.
>
>
> "AlexS" wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>>
>|||On Jun 7, 12:54 pm, "AlexS" <salexru200...@.SPAMrogers.comPLEASE>
wrote:
> Thanks, Enrique
> I guess same applies to Advanced Services
> MS, please make this available on XP Home too.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> > On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
> >> Is it possible to have SQL Express and Reporting Services on XP Home and
> >> use
> >> reports locally (like Access)?
> >> Thx
> > As far as I know, there is not. That said, I'm not sure how SSRS would
> > react if you somehow tried to tie it to Apache or some other web
> > server. Sorry that I could not offer further insight.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. SSAS I'm not sure about. Let me know if I can be of
further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||It would not work. RS is a asp.net application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>
> As far as I know, there is not. That said, I'm not sure how SSRS would
> react if you somehow tried to tie it to Apache or some other web
> server. Sorry that I could not offer further insight.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Is IIS always required for replication?

I would like to take advantage of either Merge or RDA replication over HTTP, but would like to avoid setting up IIS.

Is IIS always required to support connectivity for SQL Server Mobile replication back to a desktop SQL Server database?

Thanks, Tim

Yes IIS is very much required for Merge or RDA with SQL Server. However, setting up IIS is not a big thing as we have a "Configure Web Synchronization" wizard that is very helpful for you in this regard.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Hi

And how setting up a replication bettween a Windows Mobile 5 Pocket PC and a Windows XP Home Edition PC when IIS can't be install on Home Edition ?

?

Thanks for help
Jo?l

|||

1) What is your backend database?

2) Can I know what is the problem in moving to Win XP Professional Edition?

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||1) To replace synchronisation between Access/PocketAccess (not more supported with WM5), we use know a MSDE database (on PC) with a SQL Server CE 2.0 database (on PocketPC). The replication work fine on Windows XP Pro, but on Windows XP Home there is no IIS to do the replication.

2) Our customer have Windows XP Home Edition. I'm ok with you that's not very "professional", but we can't tell to our customer : "Hey guys, you must move your forty PC to Windows XP Pro, because our software don't run on XP Home". They will say us "bye bye".

And they have already some old PocketPC (before WM5) with this application installed and it works with XP Home ... that's a big problem for us.

Thanks for helping us

|||I have heard that we can synchronize using ActiveSync is it correct or not, because on Online Book I read we can synchronize using IIS. I need to synchronize my database on Pocket PC to my Desktop PC without using IIS (if we have the cradle why we need access to internet from Pocket PC).

And if synchronized only can work with IIS than use the old way try to send each data by client server application. Its a silly things, but thats the only way if we can only synchronize using IIS.

Is IIS always required for replication?

I would like to take advantage of either Merge or RDA replication over HTTP, but would like to avoid setting up IIS.

Is IIS always required to support connectivity for SQL Server Mobile replication back to a desktop SQL Server database?

Thanks, Tim

Yes IIS is very much required for Merge or RDA with SQL Server. However, setting up IIS is not a big thing as we have a "Configure Web Synchronization" wizard that is very helpful for you in this regard.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Hi

And how setting up a replication bettween a Windows Mobile 5 Pocket PC and a Windows XP Home Edition PC when IIS can't be install on Home Edition ?

?

Thanks for help
Jo?l|||

1) What is your backend database?

2) Can I know what is the problem in moving to Win XP Professional Edition?

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||1) To replace synchronisation between Access/PocketAccess (not more supported with WM5), we use know a MSDE database (on PC) with a SQL Server CE 2.0 database (on PocketPC). The replication work fine on Windows XP Pro, but on Windows XP Home there is no IIS to do the replication.

2) Our customer have Windows XP Home Edition. I'm ok with you that's not very "professional", but we can't tell to our customer : "Hey guys, you must move your forty PC to Windows XP Pro, because our software don't run on XP Home". They will say us "bye bye".

And they have already some old PocketPC (before WM5) with this application installed and it works with XP Home ... that's a big problem for us.

Thanks for helping us|||I have heard that we can synchronize using ActiveSync is it correct or not, because on Online Book I read we can synchronize using IIS. I need to synchronize my database on Pocket PC to my Desktop PC without using IIS (if we have the cradle why we need access to internet from Pocket PC).

And if synchronized only can work with IIS than use the old way try to send each data by client server application. Its a silly things, but thats the only way if we can only synchronize using IIS.

Is FOR XML EXPLICIT still an accepted technique?

I have inherited (someone else built it) an ASP IIS site attached to a SQL
Server 2000 database. It is quite a large web site job and I don't want to
rewrite it in .NET. I don't have the time to do that and I am not familiar
with .NET. Our company still uses VB6 for our products.
The remote site allows the user to select recordsets which currently can be
emailed as HTML or TEXT and also downloaded in an Excel (XLS) file. My job
is to create XML from the recordset, transmit it to the client browser
(which is part of a VB program) and have the client program load it into the
local SQL Server database.
I am new at using XML and have done considerable reading (my head hurts).
Some of the books are a couple years old. The recordsets are composed of
header records from the main table and child records (one to many) from 3
other tables.
I am leaning toward using FOR XML EXPLICIT in conjunction with ADODB stream
sent to the Response object. I have gotten a simple FOR XML AUTO program to
work properly and send the stream back to the browser, but now I need to
shape the more complicated XML properly.
I just want to make sure that the FOR XML EXPLICIT will not become "legacy"
code in the next few years. I have looked at using XML Views briefly, but do
not like the setup required on the SQL server to use them. It will be a
hosted remote server that houses the IIS ASP code and the SQL database.
So before I spend weeks writing and debugging the process, I want to make
sure I haven't missed some spectacular new, reliable and "easy" method of
accomplishing the same thing.
Also I plan on using the Transact/SQL OPENXML function to write the
resulting XML to the database at the client site.
There is one other problem. Using the ADODB stream sent to the Response
object results in the XML remaining "hidden" (such that a blank page appears
in the browser) which is fine...except I don't know how to access it. I
have experience using XML data islands (in HTML pages) to populate SQL
Server and also opening XML files on disk and writting to SQL Server.
Thanks for your help in advance...
For XML Explicit is definitely supported in the next release of SQL Server.
There is also a For XML Path option in the next release that would be easier
for you to use but anything you do in Explicit mode should work for the
foreseeable future. OpenXML is also fully supported in SQL Server 2005.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"John Kotuby" <jkotuby@.snet.net> wrote in message
news:e5SLwHbaEHA.3684@.TK2MSFTNGP09.phx.gbl...
>I have inherited (someone else built it) an ASP IIS site attached to a SQL
> Server 2000 database. It is quite a large web site job and I don't want to
> rewrite it in .NET. I don't have the time to do that and I am not familiar
> with .NET. Our company still uses VB6 for our products.
> The remote site allows the user to select recordsets which currently can
> be
> emailed as HTML or TEXT and also downloaded in an Excel (XLS) file. My job
> is to create XML from the recordset, transmit it to the client browser
> (which is part of a VB program) and have the client program load it into
> the
> local SQL Server database.
> I am new at using XML and have done considerable reading (my head hurts).
> Some of the books are a couple years old. The recordsets are composed of
> header records from the main table and child records (one to many) from 3
> other tables.
> I am leaning toward using FOR XML EXPLICIT in conjunction with ADODB
> stream
> sent to the Response object. I have gotten a simple FOR XML AUTO program
> to
> work properly and send the stream back to the browser, but now I need to
> shape the more complicated XML properly.
> I just want to make sure that the FOR XML EXPLICIT will not become
> "legacy"
> code in the next few years. I have looked at using XML Views briefly, but
> do
> not like the setup required on the SQL server to use them. It will be a
> hosted remote server that houses the IIS ASP code and the SQL database.
> So before I spend weeks writing and debugging the process, I want to make
> sure I haven't missed some spectacular new, reliable and "easy" method of
> accomplishing the same thing.
> Also I plan on using the Transact/SQL OPENXML function to write the
> resulting XML to the database at the client site.
> There is one other problem. Using the ADODB stream sent to the Response
> object results in the XML remaining "hidden" (such that a blank page
> appears
> in the browser) which is fine...except I don't know how to access it. I
> have experience using XML data islands (in HTML pages) to populate SQL
> Server and also opening XML files on disk and writting to SQL Server.
> Thanks for your help in advance...
>