Go Back   ø-Windows XP UsersGroup-ø > Hardware and Software > Embedding Xp
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Tags: , , , , , , , ,

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-13-2008, 01:47 AM
Vern
 
Posts: n/a
Default SP2 install refuses to install SP1 Database (doesn't recognize SQLserver 2005)

Hi All:

I am trying to install the 'free trial' XPE on my XP Pro system with
Microsoft SQL Server 2005 (SQLEXPRESS) already installed and running
[confirmed with SQL Server 2005 Surface Area Configuration tool]. When
the installer (Disk 2) for the SP1 database attempts to do the install,
after checking database status, it comes up with the message:

"The Microsoft Data Engine (MSDE) or SQL Server, version 2000 or later,
is required to be installed and running before you install or modify
this product."

This is not a very auspicious beginning to my using XPE in our products.
Am I going to have to download and install the MSDE as well, or
de-install SQL Server 2005, to get this installer to work?

Vern
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 01-13-2008, 01:47 AM
KM
 
Posts: n/a
Default Re: SP2 install refuses to install SP1 Database (doesn't recognize SQL server 2005)

Vern,

Please read this XPe Team blog page: http://blogs.msdn.com/embedded/archi...26/679111.aspx

--
=========
Regards,
KM


"Vern" <vern@bossofme.com> wrote in message news:%23yvPX0YQIHA.484@TK2MSFTNGP06.phx.gbl...
> Hi All:
>
> I am trying to install the 'free trial' XPE on my XP Pro system with Microsoft SQL Server 2005 (SQLEXPRESS) already installed and
> running [confirmed with SQL Server 2005 Surface Area Configuration tool]. When the installer (Disk 2) for the SP1 database
> attempts to do the install, after checking database status, it comes up with the message:
>
> "The Microsoft Data Engine (MSDE) or SQL Server, version 2000 or later, is required to be installed and running before you install
> or modify this product."
>
> This is not a very auspicious beginning to my using XPE in our products. Am I going to have to download and install the MSDE as
> well, or de-install SQL Server 2005, to get this installer to work?
>
> Vern



Reply With Quote
  #3 (permalink)  
Old 01-13-2008, 01:47 AM
Sean Liming \(MVP\)
 
Posts: n/a
Default Re: SP2 install refuses to install SP1 Database (doesn't recognize SQL server 2005)


Some additional SQL Express + XPe information can be found here:
http://www.seanliming.com/Docs/XPe%2...ta%20notes.pdf

--
Regards,

Sean Liming
www.sjjmicro.com / www.seanliming.com
Book Author - XP Embedded Advanced, XP Embedded Supplemental Toolkit
"KM" <konstmor@nospam_yahoo.com> wrote in message
news:eVZDgabQIHA.3916@TK2MSFTNGP02.phx.gbl...
> Vern,
>
> Please read this XPe Team blog page:
> http://blogs.msdn.com/embedded/archi...26/679111.aspx
>
> --
> =========
> Regards,
> KM
>
>
> "Vern" <vern@bossofme.com> wrote in message
> news:%23yvPX0YQIHA.484@TK2MSFTNGP06.phx.gbl...
>> Hi All:
>>
>> I am trying to install the 'free trial' XPE on my XP Pro system with
>> Microsoft SQL Server 2005 (SQLEXPRESS) already installed and running
>> [confirmed with SQL Server 2005 Surface Area Configuration tool]. When
>> the installer (Disk 2) for the SP1 database attempts to do the install,
>> after checking database status, it comes up with the message:
>>
>> "The Microsoft Data Engine (MSDE) or SQL Server, version 2000 or later,
>> is required to be installed and running before you install or modify this
>> product."
>>
>> This is not a very auspicious beginning to my using XPE in our products.
>> Am I going to have to download and install the MSDE as well, or
>> de-install SQL Server 2005, to get this installer to work?
>>
>> Vern

>
>


Reply With Quote
  #4 (permalink)  
Old 01-13-2008, 01:47 AM
Vern
 
Posts: n/a
Default Re: SP2 install refuses to install SP1 Database (doesn't recognizeSQL server 2005)

KM wrote:
> Vern,
>
> Please read this XPe Team blog page: http://blogs.msdn.com/embedded/archi...26/679111.aspx
>

Thanks, KM. That is what I needed to know.

Vern
Reply With Quote
  #5 (permalink)  
Old 01-13-2008, 01:47 AM
Vern
 
Posts: n/a
Default no joy (yet)

KM wrote:
> Vern,
>
> Please read this XPe Team blog page: http://blogs.msdn.com/embedded/archi...26/679111.aspx
>


In the blog, they simply recommend installing the MSDE alongside the
existing SQL Server.

When I go to do this, I get the message
"A SQL Server or MSDE is already installed on this computer."

Do these guys ever actually TRY the solutions they post to the web?

I tried going into Disk 1 and running setup in the
Windows Embedded\Installer\DISK1\SQLMSDE
directory. This fails with error message:
"The instance name specified is invalid"

The alternative, supposedly, is to change the name of the server during
INSTALLATION of the server which, I suppose, requires that I de-install
it first.

Surely there must be a registry hack that will change the server name.
Can anyone suggest either:
A. The registry hack to change the name of the SQL Server
B. The email of one of these XPE guys so I can ream them out for not
fixing this issue in the install phase in 2006, when it was reported.

Perhaps I am being a bit testy here, but for goodness sakes I am wasting
a lot of time just installing the tool here which they propose to charge
me $1000 dollars for it eventually. What is this saying about XPE itself?

Vern
Reply With Quote
  #6 (permalink)  
Old 01-13-2008, 01:47 AM
Sean Liming \(MVP\)
 
Posts: n/a
Default Re: no joy (yet)


You only want to install SQL Server, not MSDE. When you install SQL Server,
there is an option to set an instance name of MSSQLSERVER.

--
Regards,

Sean Liming
www.sjjmicro.com / www.seanliming.com
Book Author - XP Embedded Advanced, XP Embedded Supplemental Toolkit
"Vern" <vern@bossofme.com> wrote in message
news:uITQ5cdQIHA.5692@TK2MSFTNGP04.phx.gbl...
> KM wrote:
>> Vern,
>>
>> Please read this XPe Team blog page:
>> http://blogs.msdn.com/embedded/archi...26/679111.aspx
>>

>
> In the blog, they simply recommend installing the MSDE alongside the
> existing SQL Server.
>
> When I go to do this, I get the message
> "A SQL Server or MSDE is already installed on this computer."
>
> Do these guys ever actually TRY the solutions they post to the web?
>
> I tried going into Disk 1 and running setup in the
> Windows Embedded\Installer\DISK1\SQLMSDE
> directory. This fails with error message:
> "The instance name specified is invalid"
>
> The alternative, supposedly, is to change the name of the server during
> INSTALLATION of the server which, I suppose, requires that I de-install it
> first.
>
> Surely there must be a registry hack that will change the server name. Can
> anyone suggest either:
> A. The registry hack to change the name of the SQL Server
> B. The email of one of these XPE guys so I can ream them out for not
> fixing this issue in the install phase in 2006, when it was reported.
>
> Perhaps I am being a bit testy here, but for goodness sakes I am wasting a
> lot of time just installing the tool here which they propose to charge me
> $1000 dollars for it eventually. What is this saying about XPE itself?
>
> Vern


Reply With Quote
  #7 (permalink)  
Old 01-13-2008, 01:47 AM
Vern
 
Posts: n/a
Default Re: no joy (yet)

Hi Sean:

You and your link (prior message) were right on the money for a
work-around. I appreciate your help with this.

My one reservation in all of this is that the embedded guys are
oblivious to the impact this kind of experience has on people who are
evaluating their solution.

Thanks

Vern



Sean Liming (MVP) wrote:
>
> You only want to install SQL Server, not MSDE. When you install SQL
> Server, there is an option to set an instance name of MSSQLSERVER.
>

Reply With Quote
  #8 (permalink)  
Old 01-13-2008, 01:47 AM
Sean Liming \(MVP\)
 
Posts: n/a
Default Re: no joy (yet)


XPe has been around awhile. There have been many updates, but no real
re-work of the installation. The XPe team is aware of this. Now that newer
technologies like SQL Express are out and the team is getting bigger, there
might be some new changes in the future. Check into the XPe Blog site to see
new developments as they post them.

--
Regards,

Sean Liming
www.sjjmicro.com / www.seanliming.com
Book Author - XP Embedded Advanced, XP Embedded Supplemental Toolkit
"Vern" <vern@bossofme.com> wrote in message
news:uOvpfQpQIHA.2268@TK2MSFTNGP02.phx.gbl...
> Hi Sean:
>
> You and your link (prior message) were right on the money for a
> work-around. I appreciate your help with this.
>
> My one reservation in all of this is that the embedded guys are oblivious
> to the impact this kind of experience has on people who are evaluating
> their solution.
>
> Thanks
>
> Vern
>
>
>
> Sean Liming (MVP) wrote:
>>
>> You only want to install SQL Server, not MSDE. When you install SQL
>> Server, there is an option to set an instance name of MSSQLSERVER.
>>


Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




Contact Us -|- ø-Windows XP UsersGroup-ø -|- Archive -|- Top -|-Rules/Disclaimer-|-Help/Support -|-Advertise
© Camley Interactive (camley.info) 2008 - all logos and images are copywrite their respective owners.
Proud member of the Camley Interactive Network
All times are GMT. The time now is 03:13 AM.



Design By: Miner Skinz.com
Powered by vBulletin® Version 3.6.7

Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.