SP2 install refuses to install SP1 Database (doesn't recognize SQLserver 2005)

[Vern]

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

 

[KM]

Vern,

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

 

[Sean Liming \(MVP\)]

Some additional SQL Express + XPe information can be found here:
http://www.seanliming.com/Docs/XPe on Vista notes.pdf

--
Regards,

Sean Liming
www.sjjmicro.com / www.seanliming.com
Book Author - XP Embedded Advanced, XP Embedded Supplemental Toolkit

Vern,

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

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

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

 

[Vern]

Vern,

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

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

Vern

 

[Vern]

Vern,

Please read this XPe Team blog page: http://blogs.msdn.com/embedded/archive/2006/07/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

 

[Sean Liming \(MVP\)]

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]

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\)]

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