New Instance Install

I installed another instance of SQL Server onto my
machine. I currently have a personal edition and decided
to install a second instance. It failed at MDAC
installation. When I look at the setup log, it says the
installation failed.
My dilema is that I cannot start the previous installation
I had before. When I activate Enterprise Manager, I get a
Snap-in failed to initialize : Microsoft Enterprise
Manager. I tried everything I know to start SQL - but
cannot. Can someone help please?
Mary.Mary,
Try re-installing MDAC 2.7 SP1 and try it again. Let me know if it still
doesn't work
HTH
Thank you,
Saleem@.sqlnt.com
"Mary Lou" wrote:
> I installed another instance of SQL Server onto my
> machine. I currently have a personal edition and decided
> to install a second instance. It failed at MDAC
> installation. When I look at the setup log, it says the
> installation failed.
> My dilema is that I cannot start the previous installation
> I had before. When I activate Enterprise Manager, I get a
> Snap-in failed to initialize : Microsoft Enterprise
> Manager. I tried everything I know to start SQL - but
> cannot. Can someone help please?
> Mary.
>|||Saleem,
I just got back today and tried your suggestion. Saleem,
it worked like a champ. I want to thank you for your
expert advise. Have a good one.
Mary.
>--Original Message--
>Mary,
>Try re-installing MDAC 2.7 SP1 and try it again. Let me
know if it still
>doesn't work
>HTH
>Thank you,
>Saleem@.sqlnt.com
>"Mary Lou" wrote:
>> I installed another instance of SQL Server onto my
>> machine. I currently have a personal edition and
decided
>> to install a second instance. It failed at MDAC
>> installation. When I look at the setup log, it says
the
>> installation failed.
>> My dilema is that I cannot start the previous
installation
>> I had before. When I activate Enterprise Manager, I
get a
>> Snap-in failed to initialize : Microsoft Enterprise
>> Manager. I tried everything I know to start SQL - but
>> cannot. Can someone help please?
>> Mary.
>.
>