Update the MSDE version that comes with office

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jan Doggen - 21 Jul 2008 20:51 GMT

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

Reply to this Message

Andrea Montanari - 21 Jul 2008 23:42 GMT

hi Jan,

> Hi
>
[quoted text clipped - 4 lines]
>
> 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..

Signature

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

Reply to this Message