|
|
Posted by Danny on 07/01/05 15:46
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@hotmail.com> wrote in message
news:1120213266.725195.169400@g43g2000cwa.googlegroups.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$machinename its the same in Enterprise Manager
> \\machinename$InstanceName. 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
>
Navigation:
[Reply to this message]
|