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?
[gripe]
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.
[/gripe]
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
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?
[gripe]
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.
[/gripe]
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