Installing MSDE 2000 Rel A

Hi all,
I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every
time without any indication of why. I had an earlier installation of MSDE
which I removed manually following the instructions in the Knowledge Base
article. I installed MSDE on a Windows 2000 Pro machine using the same
procedure without any problems.
The command line syntax I'm using is: setup sapwd="[mypassword]"
SECURITYMODE=SQL
Can anyone help?
Thanks.
When you manually uninstalled MSDE did you also remove the "MSSQLServer" key
under HKEY_LOCAL_MACHINE\Software\Microsoft ? That key and the "Microsoft
SQL Server" key needs to be removed. Also remove the entire directory tree
under c:\program files\Microsoft SQL Server. Also, reboot the machine after
doing the manual uninstall.
Jim
"Stephen Bishop" <Stephen Bishop@.discussions.microsoft.com> wrote in message
news:1E567705-A87F-4B8D-8DF5-202D934D5263@.microsoft.com...
> Hi all,
> I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every
> time without any indication of why. I had an earlier installation of MSDE
> which I removed manually following the instructions in the Knowledge Base
> article. I installed MSDE on a Windows 2000 Pro machine using the same
> procedure without any problems.
> The command line syntax I'm using is: setup sapwd="[mypassword]"
> SECURITYMODE=SQL
> Can anyone help?
> Thanks.
|||Hi Jim,
I did delete those keys from the registry with no luck.
In a separate post, I uploaded part of the install log what appears to point
to the problem . Searching for "return value 3" I found the following:
"Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 11:32:55: InstallFinalize. Return value 3."
According to a Knowledge Base article, the only solution to this involves
some advanced level tinkering with the registry, which I don't feel
comfortable undertaking. Is there any other way?
Thanks for your reply.
sb
"Jim Young" wrote:

> When you manually uninstalled MSDE did you also remove the "MSSQLServer" key
> under HKEY_LOCAL_MACHINE\Software\Microsoft ? That key and the "Microsoft
> SQL Server" key needs to be removed. Also remove the entire directory tree
> under c:\program files\Microsoft SQL Server. Also, reboot the machine after
> doing the manual uninstall.
> Jim
> "Stephen Bishop" <Stephen Bishop@.discussions.microsoft.com> wrote in message
> news:1E567705-A87F-4B8D-8DF5-202D934D5263@.microsoft.com...
>
>
sql

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]

Installed MSDE Rel A does not appear to work.

I just installed MSDE 2000 Rel A on a Win 2000 machine, after removing the old MSDE 2000 that came with MS Office. The new installation does not appear to work. I have a log file (with verbose dialog), but it says the installation completed successfully
at its end.
A custom ini file was used with a strong sa password and the DisableNetworkProtocols=0 to enable network access from a peer computer. Since I want to use Windows Authentication I omitted the SECURITYMODE=SQL.
As per the MSDE Readme file , I set the security policy for "Unsigned non-driver installation behavior" to "Silently succeed".
I disabled Norton Internet security (the firewall) and Antivirus before installing. After reboot, I set firewall rules to pass everything on ports that the MSDE wanted to communicate on. Disabling the firewall (after booting) does not allow it to work.
The Service Manager is active, but lists only the old server name "H" which is the name of the computer. The new instance is not shown. The services list is empty.
Q1) Why is the old server name "H" still there?
Q2) Any idea why this installation does work? Can anyone look at the log file (its about 2 MB in size) and tell what's wrong?
Mark Ferguson
hi Mark,
"Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> ha scritto nel
messaggio news:3E995A24-7B1B-4CA7-9472-90056074438F@.microsoft.com...
> I just installed MSDE 2000 Rel A on a Win 2000 machine, after removing the
old
>MSDE 2000 that came with MS Office. The new installation does not appear to
work. I
> have a log file (with verbose dialog), but it says the installation
completed successfully
>at its end.
>...........
just a question... you say
>The services list is empty
does it means you investigated the available services in the services
control panel and the installed MSDE instance is not present? or you mean
the instance is not present in the Service Manager combobox?
if the service is available in the services management panel, try typing the
instance name in the Service Manager combobox...
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
|||I understand your question, and it was helpful but did not solve the problem:
1) Control Panel>Administrative Tools>Services shows a list of services, some started, some not. In this case the MSSQL$<instance> is shown as *started*, so we know that the server is active.
2) The SQL Server Manager (SSM) that I was referring to, is started from the Startup subfolder during system boot. It appears as an icon at the right of the task bar: a CPU box with a green arrow in white circle. (In my case, the green arrow is missing).
The SSM is used to start and stop services associated with an instance of SQL Server. It contains two combo boxes, one for picking the instance, the second for picking the service to start and stop.
In the SSM instance combo box, the only instance name is "H" - the name of the old uninstalled MDSE 2000 from the MSOffice 2000 CDROM. I tried entering the new instance name in the combo box. It generated the error message "The network path was not found.
" The service combo box remained empty.
Mark Ferguson
"Andrea Montanari" wrote:

> hi Mark,
--snip--
> just a question... you say
> The services list is empty"
> does it means you investigated the available services in the services
> control panel and the installed MSDE instance is not present? or you mean
> the instance is not present in the Service Manager combobox?
> if the service is available in the services management panel, try typing the
> instance name in the Service Manager combobox...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
|||Mark,
In the Server Manager, did you type in the instance name as
<MACHINE_NAME>\<INSTANCE_NAME>? For example, if my machine is DANDELL and
the instance is MYINSTANCE, I would enter DANDELL\MYINSTANCE and press the
"Refresh Services" button. This name is difference than MSSQL$MYINSTANCE.
Dan
"Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> wrote in message
news:7D67CBC5-10EF-453D-8E77-9B2545BE6092@.microsoft.com...
>I understand your question, and it was helpful but did not solve the
>problem:
> 1) Control Panel>Administrative Tools>Services shows a list of services,
> some started, some not. In this case the MSSQL$<instance> is shown as
> *started*, so we know that the server is active.
> 2) The SQL Server Manager (SSM) that I was referring to, is started from
> the Startup subfolder during system boot. It appears as an icon at the
> right of the task bar: a CPU box with a green arrow in white circle. (In
> my case, the green arrow is missing). The SSM is used to start and stop
> services associated with an instance of SQL Server. It contains two combo
> boxes, one for picking the instance, the second for picking the service to
> start and stop.
> In the SSM instance combo box, the only instance name is "H" - the name of
> the old uninstalled MDSE 2000 from the MSOffice 2000 CDROM. I tried
> entering the new instance name in the combo box. It generated the error
> message "The network path was not found." The service combo box remained
> empty.
> --
> Mark Ferguson
>
> "Andrea Montanari" wrote:
> --snip--
>
|||Thanks Dan. Didn't work however. The instance name is ABC. I tried
- H\ABC - result was an eror mesage saying that the computer name format was invalid.
-\H\ABC - result was "The RPC server is unavailable". The RPC server was started, I started the RPC locator service and tried again with the same error.
-\\H\ABC - result was no error message but at the bottom of the Service Manager dialog, a field showed the message "Unknown - \\\\H\ABC - MSSQLServer". Note the 4 backslashes?
I should mention that the first try (H\ABC) created more firewall rules for the SQL server and the Service Manager.
What is the proper format for the computer name and instance? According to my reading, in the "Books Online", the proper format is "H\<instance>".
Why doesn't the Service Manager find this new instance in the same way that it found the original instance? (I assume the original instance-name was blank.)
Mark Ferguson
"PPC" wrote:

> Mark,
> In the Server Manager, did you type in the instance name as
> <MACHINE_NAME>\<INSTANCE_NAME>? For example, if my machine is DANDELL and
> the instance is MYINSTANCE, I would enter DANDELL\MYINSTANCE and press the
> "Refresh Services" button. This name is difference than MSSQL$MYINSTANCE.
> Dan
> "Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> wrote in message
> news:7D67CBC5-10EF-453D-8E77-9B2545BE6092@.microsoft.com...
>
>