MSDE and SQL2000 on Win2k3

[gdavid9@hotmail.com]

Hi all,

I have MSDE installed on an HP server as some of the utilities required
a database. I have also subsequently installed SQL 2000 onto this
server which is a windows 2003 box. I know it complains at the start
of the installation but I was under the impression that it would still
work ok, especially with SP3 applied.

I have tried to apply SP3 but it tells me that it is not a SQL2000
instance ad setup will exit?

Also I have noticed that in the directory structure it has used the
dollar sign i.e. mssql$machinena me its the same in Enterprise Manager
\\machinename$I nstanceName. Whats that all about? Its not like that on
any other server!

My plan is to uninstall sql 2k, uninstall HP apps and MSDE and
reinstall SQL 2k. Can anyone explain the above though?

Thanks

Gary

[Danny]

Re: MSDE and SQL2000 on Win2k3

Gary,
MSDE is an instance of SQL Server. Since it was the first thing installed,
it is taking up the default instance. I assume when you installed SQL
Server 2000 it installed as a named instance. Both can run on the server at
the same time but it's a little more difficult to manage. Your probably
dealing with HPs volume manager. In my opinion the ability to expand
partitions isn't worth the odd SQL install if this is a database server.

<gdavid9@hotmai l.com> wrote in message
news:1120213266 .725195.169400@ g43g2000cwa.goo glegroups.com.. .[color=blue]
> Hi all,
>
> I have MSDE installed on an HP server as some of the utilities required
> a database. I have also subsequently installed SQL 2000 onto this
> server which is a windows 2003 box. I know it complains at the start
> of the installation but I was under the impression that it would still
> work ok, especially with SP3 applied.
>
> I have tried to apply SP3 but it tells me that it is not a SQL2000
> instance ad setup will exit?
>
> Also I have noticed that in the directory structure it has used the
> dollar sign i.e. mssql$machinena me its the same in Enterprise Manager
> \\machinename$I nstanceName. Whats that all about? Its not like that on
> any other server!
>
> My plan is to uninstall sql 2k, uninstall HP apps and MSDE and
> reinstall SQL 2k. Can anyone explain the above though?
>
> Thanks
>
> Gary
>[/color]

[gdavid9@hotmail.com]

Re: MSDE and SQL2000 on Win2k3

Hi Danny.

Thanks for the info, I think your right. I have zapped all the HP
stuff and removed all MSDE and SQL and reinstalled SQL and been able to
install sp3.

I can probably still use the Hp tools but point them to SQL.

and yes it is a database server!

Gary