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[vbcol=seagreen]
>doesn't work
>HTH
>Thank you,
>Saleem@.sqlnt.com
>"Mary Lou" wrote:
decided[vbcol=seagreen]
the[vbcol=seagreen]
installation[vbcol=seagreen]
get a
>.
>