I recently installed shipping software from UPS and it installed MSDE
without asking me. I already have SQL Express installed for another
application and so I would prefer to remove MSDE and keep SQL Express.

There is no option that I know of to remove MSDE without uninstalling the
UPS software.

I was reading the system requirements for the software and it says
Windows XP MSDE
Windows Vista SQL Express
http://www.ups.com/content/ca/en/bussol/offering/worldship/order/requirements.ht...

My assumption is that MSDE doesn't work on Vista and that's why it uses SQL
Express on Vista. Can someone help me get rid of MSDE on XP and move the
database that it made over to my SQL Express instance? Do you think this
will cause a problem? Is it possible that Is there really are MSDE specific
queries that would prevent me from using SQL Express instead?

I noticed that when my pc boots up, the Service manager for MSDE (in the
tool bar) says the server is
mycomputername\SQLExpress

Hi Robbie,

I haven't seen that UPS application yet, however there must be a specific
Instance name for that MSDE installation and that UPS software must be using
this instance name to connect to its databases which is attached to this
MSDE instance.

So, if you uninstall the MSDE instance and attach your UPS database to your
SQL Server 2005 Express Edition instance, how is this UPS software
understand this instance name changing? I think you probably will experience
a connection problem here.

As I said before, I don't know this UPS software but there may be a
configuration file which contains some configurations about connection
string to the MSDE instance and you can change the settings accordingly? Is
so, there shouldn't be any problem unless you change your database's
Compatibility Level to 90 after migrating your MSDE database to your SQL
Server 2005 Express Edition instance.

--
Ekrem Önsoy

"Robbie" nospam.com> wrote in message
news:uGOnEVgDJHA.2060@TK2MSFTNGP05.phx.gbl...

hi Robbie,
Robbie wrote: