Power User and MSDE do not get along!

[Charles E Finkenbiner]

Hi All,

I have installed MSDE SP3, while logged in as 'Administrator', on my
NTFS Win2000 Pro computer. I searched the install log and found no
'RETURN VALUE 3' entries.

The problem comes in when I am logged in as a 'Power User'. During the
login MSDE appears to load correctly (I can see icon in SysTray). But,
when I load 1 certain program (my ISP dialer) the MSDE installer kicks
in, then it rolls back. The installer tries 3 times before it quits.
Below is the text from the ''Application' Event Log'. After this the
icon in the SysTray disappears. I am only posting 1 set of error
messages since all of them are the same.

Error 1:
Event Type: Warning
Event Source: MsiInstaller
Event Category: None
Event ID: 1004
Date: 1/3/2005
Time: 3:04:53 PM
User: N/A
Computer: XXX
Description:
Detection of product '{E09B48B5-E141-427A-AB0C-D3605127224A}', feature
'SqlRun', component '{3AAB1C47-5774-45F2-B1BC-B6B567A57F6F}' failed. The
resource 'C:\Program Files\Microsoft SQL
Server\MSSQL\Install\instdist.sql' does not exist.

The file 'C:\Program Files\Microsoft SQL
Server\MSSQL\Install\instdist.sql' does exists and can be found in the
MSSQL directory. I noticed that the permission for this directory is
set to 'Administrators' only. This is the default setting, I never
changed it.

Error 2:
Event Type: Warning
Event Source: MsiInstaller
Event Category: None
Event ID: 1001
Date: 1/3/2005
Time: 3:04:53 PM
User: N/A
Computer: XXX
Description:
Detection of product '{E09B48B5-E141-427A-AB0C-D3605127224A}', feature
'SqlRun' failed during request for component
'{436D7A23-36BE-11D2-ACBB-0080C7FCBB84}'

I have no idea what this is telling me.

Error 3:
Event Type: Information
Event Source: MsiInstaller
Event Category: None
Event ID: 11729
Date: 1/3/2005
Time: 3:05:09 PM
User: N/A
Computer: XXX
Description:
Product: Microsoft SQL Server Desktop Engine -- Configuration failed.


How can I fix this problem? Any help is greatly appreciated.


Thanks,

Charles