MSDE 2000a installation failure on XP Pro

Hi,
Everyone know why MSDE 2000a is refusing to load on a XP Pro wiht Office SBS installed on it. It seems to have MSDE already but the default instance isn't accessible so I tried to install under another instance name. I have set the SA password.
File and print sharing is installed and running (I think). I'm able to share out folders.
Any suggestions?
Jim
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
hi Jim,
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> ha scritto nel messaggio
news:eIKtRH8eEHA.3028@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Everyone know why MSDE 2000a is refusing to load on a XP Pro wiht Office
SBS installed on it. It seems to have MSDE already but the default instance
isn't accessible so I tried to install under another instance name. I have
set the SA password.
> File and print sharing is installed and running (I think). I'm able to
share out folders.
I'm not aware of such limitation... but, anyway, please add the /L*v
"c:\..\Log.txt" command line parameter in order to
inspect the resulting log file..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

MSDE 2000 on top of Office 2002

I have a company PC preloaded with:
- Win-2000 SP4
- Access/Excel 2002 (10.x) SP-2

I need to install MSDE, and I have the Office 2000 CD. The queostion is: would MSDE cause a regression in Access and Excel ?

I understand why MSDE is packaged together with Office. But I hope they do not use too many common resources (e.g. DLLs). Otherwise, isntalling MSDE 200 would throw Access/Excel back to the 2000 level.

Is MSDE really independent of the version of Office running on the same machine ?It should not affect your office installation at all because MSDE has nothing to do with office. All it is, is a data engine like SQL Server so it is like installing SQL Server 7.0 on the machine.

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

Msde 2000

Hi

I installed the MSDE that comes with Office 2000. When connecting to my mdf, I received an error saying that the header file is invalid. I understand that the MSDE shipped with Office 2000 uses the SQL 7 engine, therefore it does not recognize the my SQL 2000 database file format. Can someone tell me where can I get a copy of the correct version of MSDE that will work with my SQL 2000 mdf?

Thanks

SHKMSDE 2000 (http://www.microsoft.com/sql/msde/downloads/download.asp)|||Thank You

MSDE 1 => msde 2 => MSDE 2 SP3a

I'm able to successfully upgrade my MSDE 1 installation from Office 2k to
MSDE 2, using any of the versions 1 thru 3a. However, I can't figure out
the command-line parameters to upgrade MSDE 2 to a newer version of MSDE 2,
at least not retaining my Office Server Extensions database. Considering
that SP 4 for MSDE 2 will probably be out soon, what's the proper method to
upgrade MSDE 2 when it was used to upgrade MSDE 1?
Well, I figured out the easy way to do things. First, you install MSDE 2.
Then you install office server extensions using the /nd switch to avoid
installing an older version of MSDE. Had a lot of registry cleaning to do,
had to unregister ows.dll, and a few other problems to fix before I could
get a successful install of OSE. Works fine, though. I was even able to
apply the OSE SP3 patch.
"Ellen Langton" <elangton@.wctc.net> wrote in message
news:emnXe$XCFHA.3688@.TK2MSFTNGP14.phx.gbl...
> I'm able to successfully upgrade my MSDE 1 installation from Office 2k to
> MSDE 2, using any of the versions 1 thru 3a. However, I can't figure out
> the command-line parameters to upgrade MSDE 2 to a newer version of MSDE
2,
> at least not retaining my Office Server Extensions database. Considering
> that SP 4 for MSDE 2 will probably be out soon, what's the proper method
to
> upgrade MSDE 2 when it was used to upgrade MSDE 1?
>
|||Well, I figured out the easy way to do things. First, you install MSDE 2.
Then you install office server extensions using the /nd switch to avoid
installing an older version of MSDE. Had a lot of registry cleaning to do,
had to unregister ows.dll, and a few other problems to fix before I could
get a successful install of OSE. Works fine, though. I was even able to
apply the OSE SP3 patch.
"Ellen Langton" <elangton@.wctc.net> wrote in message
news:emnXe$XCFHA.3688@.TK2MSFTNGP14.phx.gbl...
> I'm able to successfully upgrade my MSDE 1 installation from Office 2k to
> MSDE 2, using any of the versions 1 thru 3a. However, I can't figure out
> the command-line parameters to upgrade MSDE 2 to a newer version of MSDE
2,
> at least not retaining my Office Server Extensions database. Considering
> that SP 4 for MSDE 2 will probably be out soon, what's the proper method
to
> upgrade MSDE 2 when it was used to upgrade MSDE 1?
>

MSDE

Hello
How do you use Enterprise Manager in MSDE. I got the
version of MSDE from Office XP Professional edition.
AsifEnterprise manager is not shipped with MSDE . The SQL Server 2000 Desktop
Engine does not include graphical management tools. You can manage instances
of the Desktop Engine from the SQL Server 2000 graphical tools if installed
with another edition of SQL Server.
Or use third party tools for MSDE
http://www.betav.com/Files/Content/Tools/tools.htm
--
-Vishal
"Asif" <asifjr@.hotmail.com> wrote in message
news:0ac801c35117$9dbfdb80$a601280a@.phx.gbl...
> Hello
> How do you use Enterprise Manager in MSDE. I got the
> version of MSDE from Office XP Professional edition.
> Asif