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...
>
>