Installing MSDE

Hi,
I have been having difficulty installing MSDE 2000 Rel A. It starts the process and then gives a message stating that MicroSoft SQL Server Desktop Engine Setup failed. I ran the install program with a log file and found an entry that failed. (value 3).
Here is the entry from the log file
...
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (RPC0419,LocalSystem,87).
Action ended 15:29:52: InstallFinalize. Return value 3.
Any help would be greatly appreciated.
Glenn Bruckner
hi Glenn,
"Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
messaggio news:263C2E27-6082-4998-9541-7CCC824DB661@.microsoft.com...
> Hi,
> I have been having difficulty installing MSDE 2000 Rel A. It starts the
process and then
>gives a message stating that MicroSoft SQL Server Desktop Engine Setup
failed. I ran the
>install program with a log file and found an entry that failed. (value 3).
>
Please make sure that your File & Print services is started.
Go to Control Panel - Administrative Tools - Services then start 'Server'.
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
|||Andrea,
Thanks for the response. I looked at the services in the Administrative tools but I don't see anything for file and print sharing. I can enable it for the local hard disk if that is necessary. I will work on trying to start them and let you know what h
appens.
GB
"Andrea Montanari" wrote:

> hi Glenn,
> "Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
> messaggio news:263C2E27-6082-4998-9541-7CCC824DB661@.microsoft.com...
> process and then
> failed. I ran the
> Please make sure that your File & Print services is started.
> Go to Control Panel - Administrative Tools - Services then start 'Server'.
> --
> 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
>
|||hi Glenn,
"Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
messaggio news:E575AC6E-7CFD-48BF-BB0E-2AAB5E7AF5A7@.microsoft.com...
> Andrea,
> Thanks for the response. I looked at the services in the Administrative
tools but I don't
>see anything for file and print sharing. I can enable it for the local
hard disk if that is
>necessary. I will work on trying to start them and let you know what
happens.
look for a service named "Server"
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
|||Andrea,
There is no service listed as Server. The computer I am trying to load MSDE on is Win 2000 Pro machine. Is it possible to load it on Win2000 Pro? (I would also like to load on my XP Pro machine at home as well.)
I also have access to the SQL 2000 Enterprise Manager, should I use that instead?
Thanks again for your help.
GB
"Andrea Montanari" wrote:

> hi Glenn,
> "Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
> messaggio news:E575AC6E-7CFD-48BF-BB0E-2AAB5E7AF5A7@.microsoft.com...
> tools but I don't
> hard disk if that is
> happens.
> look for a service named "Server"
> --
> 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
>
|||hi Glenn,
"Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
messaggio news:365D7A40-1BBC-40F1-ADE6-8B10B46C8972@.microsoft.com...
> Andrea,
> There is no service listed as Server. The computer I am trying to load
MSDE
>on is Win 2000 Pro machine. Is it possible to load it on Win2000 Pro?
>(I would also like to load on my XP Pro machine at home as well.)
>
when installing Win2k, the Typical Settings will automatically set Client
for MS networks, File and Printer sharing and TCP/IP network protocols...
selecting Custom Settings, File and Printer sharing must be manually added..
if File and Printer sharing is not available, you have to add it
then, the "Server" service will be available =;-D

> I also have access to the SQL 2000 Enterprise Manager, should I use that
instead?
Enterprise Manager is to manage SQL Server installed instances... so only
once installed you could use it... by the way, using EM aginst MSDE
instances seems not to be very legal... you should rely on Web Data
Administrator (at MSDE download page) and/or third parties tools like that
listed in http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
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
|||Hi Glenn.
I read your and Andrea's comments on your problem.
I installed MSDE2000A on the a Win2K Pro machine with SP4 and all worked well, but only after some adjustments. But mine never failed its installation, so its hard to say why your did.
Please be sure that your MSDE installation is started from the command line with a parameter that sets an instance name. You may already have an unnamed instance installed. See the SQL Server 2000 Books Online for this and other help. Its a free download
able reference document for MSDE2000A. Install it and read the parts on installation and connection. There is also a multitude of MS KB articles on these topics. Its not possible to help more without knowing your system much better.
The File and Printer Sharing that Andrea was refering to is an aspect of your network (LAN) software. The LAN connection properties, will show 3 services: TCP/IP, File and Printer Sharing, and Client for MS Networks. Enable them all, although I'm not sure
why the latter two are needed at all but all I've read. That should at least get you going.
Lou Arnold
Ottawa, Canada
"Glenn Bruckner" wrote:

> Hi,
> I have been having difficulty installing MSDE 2000 Rel A. It starts the process and then gives a message stating that MicroSoft SQL Server Desktop Engine Setup failed. I ran the install program with a log file and found an entry that failed. (value 3
).
> Here is the entry from the log file
> ...
> Starting custom action InstallSQLAgentSecurity
> InstallSQLAgentSecurity failed (RPC0419,LocalSystem,87).
> Action ended 15:29:52: InstallFinalize. Return value 3.
> Any help would be greatly appreciated.
> Glenn Bruckner
|||Andrea,
I enabled file and print sharing and tried to install MSDE. It worked perfectly.
Thanks again for your help.
GB
"Andrea Montanari" wrote:

> hi Glenn,
> "Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
> messaggio news:365D7A40-1BBC-40F1-ADE6-8B10B46C8972@.microsoft.com...
> MSDE
> when installing Win2k, the Typical Settings will automatically set Client
> for MS networks, File and Printer sharing and TCP/IP network protocols...
> selecting Custom Settings, File and Printer sharing must be manually added..
> if File and Printer sharing is not available, you have to add it
> then, the "Server" service will be available =;-D
> instead?
> Enterprise Manager is to manage SQL Server installed instances... so only
> once installed you could use it... by the way, using EM aginst MSDE
> instances seems not to be very legal... you should rely on Web Data
> Administrator (at MSDE download page) and/or third parties tools like that
> listed in http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> --
> 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
>
|||Lou,
I had to enable File and print sharing for Microsoft Networks before I could install MSDE. Once I did that, it installed with out a problem.
Thanks for your assistance.
GB
"Lou Arnold" wrote:

> Hi Glenn.
> I read your and Andrea's comments on your problem.
> I installed MSDE2000A on the a Win2K Pro machine with SP4 and all worked well, but only after some adjustments. But mine never failed its installation, so its hard to say why your did.
> Please be sure that your MSDE installation is started from the command line with a parameter that sets an instance name. You may already have an unnamed instance installed. See the SQL Server 2000 Books Online for this and other help. Its a free downlo
adable reference document for MSDE2000A. Install it and read the parts on installation and connection. There is also a multitude of MS KB articles on these topics. Its not possible to help more without knowing your system much better.
> The File and Printer Sharing that Andrea was refering to is an aspect of your network (LAN) software. The LAN connection properties, will show 3 services: TCP/IP, File and Printer Sharing, and Client for MS Networks. Enable them all, although I'm not su
re why the latter two are needed at all but all I've read. That should at least get you going.[vbcol=seagreen]
> --
> Lou Arnold
> Ottawa, Canada
>
> "Glenn Bruckner" wrote:
3).[vbcol=seagreen]