MSDE 2000 does not run under Power User

Hi All,
I installed MSDE 2000 from my Office XP CD while logged in a
Administrator. I then applied SP 3 and HotPatch 815495. While logged
in as Administrator everything works fine.
However, when I log in as a Power User I have problems. MSDE seems to
load during the login process as I can see the icon in the taskbar.
But, when I try to load any program I get the MSDE 2000 installer
invoked. It goes through severl stages and I can see the progress bar
moving to the right. Once it gets all the way to the right it then
reverses itself and moves all the way back to the left. After the
installer dialogs are gone, showing no messages at all, the icon in
the taskbar is also gone.
How do I get MSDE 2000 to run correctly while logged in as a Power
User?
Thanks for any help,
Charles
hi Charles,
"Charles E Finkenbiner" <CharlesEF@.MailandNews.Com> ha scritto nel messaggio
news:d55b48cb.0409190449.732e1bb1@.posting.google.c om...
> Hi All,
> I installed MSDE 2000 from my Office XP CD while logged in a
> Administrator. I then applied SP 3 and HotPatch 815495. While logged
> in as Administrator everything works fine.
> However, when I log in as a Power User I have problems. MSDE seems to
> load during the login process as I can see the icon in the taskbar.
> But, when I try to load any program I get the MSDE 2000 installer
> invoked. It goes through severl stages and I can see the progress bar
> moving to the right. Once it gets all the way to the right it then
> reverses itself and moves all the way back to the left. After the
> installer dialogs are gone, showing no messages at all, the icon in
> the taskbar is also gone.
> How do I get MSDE 2000 to run correctly while logged in as a Power
> User?
I never used and installed the MSDE 2000 release that comes with Office XP,
but I'm quite sure it's the same package available for download from
Microsoft Web Site...
and MSDE has no installer if not the seutp.exe boostrap installer you can
usually find in the \MSDE folder of the Office CD, so no "repair" Windows
Intaller feature should be present ...
and I usually run MSDE when logged as power user or standard user.. with no
problem at all
the SQL Service is usually run in the contest of a local admin [or
LocalSystem, sometime :-( ]..
please verify MSDE is correctly running before executing your own
application(s) to verify it's not an MSDE problem...
open the control panel-> services ->MSSQLSSERVER and verify it's correctly
running...
execute oSQL.exe to connect or your preferred management application...
open with notepad the \Program Files\Microsoft SQL Server\MSSQL\Log\ERRORLOG
text file and search for errors, open the event viewer and search for SQL
Server related troubles...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
While logged in as a Power User services show MSSQLSERVER as started.
ERRORLOG shows errors binding to port 1433 but at the end it states
that SQLSERVER is listening on port 1433 and ready for connections.
The application event log show many MsiInstaller errors regarding
MSSQLSERVER. Registry keys missing, no permission to write to a file
in the Install directory, configuration failed.
I am just going to uninstall it and try over, again. I will post back
my results.
Thanks for your help,
Charles
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message news:<2r5mthF12sg5rU1@.uni-berlin.de>...
> hi Charles,
> "Charles E Finkenbiner" <CharlesEF@.MailandNews.Com> ha scritto nel messaggio
> news:d55b48cb.0409190449.732e1bb1@.posting.google.c om...
> I never used and installed the MSDE 2000 release that comes with Office XP,
> but I'm quite sure it's the same package available for download from
> Microsoft Web Site...
> and MSDE has no installer if not the seutp.exe boostrap installer you can
> usually find in the \MSDE folder of the Office CD, so no "repair" Windows
> Intaller feature should be present ...
> and I usually run MSDE when logged as power user or standard user.. with no
> problem at all
> the SQL Service is usually run in the contest of a local admin [or
> LocalSystem, sometime :-( ]..
> please verify MSDE is correctly running before executing your own
> application(s) to verify it's not an MSDE problem...
> open the control panel-> services ->MSSQLSSERVER and verify it's correctly
> running...
> execute oSQL.exe to connect or your preferred management application...
> open with notepad the \Program Files\Microsoft SQL Server\MSSQL\Log\ERRORLOG
> text file and search for errors, open the event viewer and search for SQL
> Server related troubles...
|||Hi,
OK, I give up. After trying many times I can not get SQL Desktop
Server installed to run under a Power User account. I have no trouble
running it as a member of the Administrator group. It has gotten to
the point that MsiInstaller locks up during the Power User
installation.
I have tried to install it while logged in as a Power User but the
installer states I do not have rights to install and exits.
Any other ideas you can supply?
Thanks for any help,
Charles
CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409200014.30c832e6@.posting.google. com>...[vbcol=seagreen]
> Hi Andrea,
> While logged in as a Power User services show MSSQLSERVER as started.
> ERRORLOG shows errors binding to port 1433 but at the end it states
> that SQLSERVER is listening on port 1433 and ready for connections.
> The application event log show many MsiInstaller errors regarding
> MSSQLSERVER. Registry keys missing, no permission to write to a file
> in the Install directory, configuration failed.
> I am just going to uninstall it and try over, again. I will post back
> my results.
>
> Thanks for your help,
> Charles
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message news:<2r5mthF12sg5rU1@.uni-berlin.de>...
|||Hi,
Ok, I have some more information to pass along.
As I said before, when I login as Administrator (or any user in the
Administrator group) I have no problems what so ever. When I login as
a Power User MSDE appears to load without problems and I can see the
SQLManager icon in the taskbar. But, when I load a certain program
the MSDE installer kicks in and locks up (I have to End Task) and the
SQLManager icon disappears from the taskbar.
After the End Task I can still run SQL queries and they still work.
So, it appears that MSDE is still working even though the icon
disappears. The MSDE installer kicks in every time I load a certain
program (that I know of, so far) then locks up.
Is there a way for me to disable the MSDE installer? Some entry in
the Registry, perhaps?
Thanks for any help,
Charles
CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409201329.f807f2b@.posting.google.c om>...[vbcol=seagreen]
> Hi,
> OK, I give up. After trying many times I can not get SQL Desktop
> Server installed to run under a Power User account. I have no trouble
> running it as a member of the Administrator group. It has gotten to
> the point that MsiInstaller locks up during the Power User
> installation.
> I have tried to install it while logged in as a Power User but the
> installer states I do not have rights to install and exits.
> Any other ideas you can supply?
>
> Thanks for any help,
> Charles
> CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409200014.30c832e6@.posting.google. com>...
|||Hi,
Is there a way for me to disable the MSDE installer? Some entry in
the Registry, perhaps?
Thanks for any help,
Charles
|||CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409221950.22e79cc4@.posting.google. com>...
> Hi,
> Is there a way for me to disable the MSDE installer? Some entry in
> the Registry, perhaps?
>
> Thanks for any help,
> Charles
Hi All,
I fixed my problem. I had to change permissions for the MSSQLSERVER
tree in the registry. Right or wrong, it worked for me. No more
stupid MSI installer.
Charles