By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,359 Members | 1,543 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,359 IT Pros & Developers. It's quick & easy.

Move from SBS2003 MSDE to MS SQL 2005 Express

P: n/a
I have SBS2003-SP1 (with MSDE) installed. I have read several "How-To's" on
upgrading MSDE to 2K5Express, but none have directly answered the
SBS2003/MSDE install scenario: is MSDE a "module" of Sharepoint/SBS-
Monitoring, or is it an MSI install, brought in with the OS install?

The How-To's state that if you can see it in Add/Remove programs, then it
is an MSI install and 2K5Express will see it and upgrade it and the
databases as appropriate. If it's not in Add/Remove, then it was installed
as a module. In SBS2003, it is listed in Add/Remove as "Microsoft SQL
Server Desktop Engine (SBSMonitoring)" and "... (Sharepoint)".

After the install of 2K5Express, because they are *still* in the Add/Remove
panel, did 2K5Express update everything necessary, or am I still needing to
execute the detach/re-attach steps and then figure out where the MSDE
engine is and how to delete it? Run an OS component reconfiguration setup?

I wish experts in a subject matter would delve a bit deeper and offer
advice on a wider range of situations in their How-To's than what appears
to be simply parroting MS's own white papers and KB articles.

When I run the Management Studio Express, I am able to connect to three
choices: server/SBSMONITORING, server/SHAREPOINT, and server/SQLEXPRESS.
The first two show one version number (8.0.2039), while the last shows a
different version number (9.0.2047). Is there anything I need to concern
myself with this?
Remove INVALID from e-mail address.

Brian Smither
Smither Consulting
Aug 7 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.