Update the MSDE version that comes with office

Hi

The MSDE that came with Office 2003 and that was installed with instance
MICROSOFTSMLBIZ still is the RTM version on my wife's machine. I want to
install SP4. The installer says I need to enter a strong pw with the SAPWD
switch.

However, I'm afraid that might break Office.

What is the best course to sail?

Thanks in advance
Jan


========================================================================================
http://www.jandoggen.org http://www.beautyofpeople.com
http://www.puddingclub.nl

hi Jan,
Jan Doggen wrote:
> Hi
>
> The MSDE that came with Office 2003 and that was installed with
> instance MICROSOFTSMLBIZ still is the RTM version on my wife's
> machine. I want to install SP4. The installer says I need to enter a
> strong pw with the SAPWD switch.
>
> However, I'm afraid that might break Office.

it should not break Office, as Office only provides an eventual "glue"
betwen applications using data and the related database engine.. more, each
and every "application" built on top of SQL Server\MSDE should be aware of
the "authentication requirements" of such a database engine.. thus you
should be prompted with dialog requiring you to connect via a trusted
connection, or provide explicit credentials in the form of a "user id" and
related password.. I do hope none of the apps installed on that pc is built
providing credentials of "sa + blank".. you should eventually investigate in
this area if you are afraid of upgrading that instance..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply