MSDE reinstall.

I had MSDE installed on my machine, but I had problems making it work. I installed the Visual Studio 2005Beta2, and it apparently installed MSDE 2005. I deinstalled MSDE 2000, then tried to make MSDE 2005 work. After lots of hair pulling I finally found the instance name, reset the authenitcation method, and reset the SA password. Then I found out all my sql tools don't work with it. No enterprise manager or query analyzer. So off MSCE 2005 came from my machine. I reinstalled MSCE 2000, but I cannot login. I am not sure if I don't have the proper instance name, or password for the sa account. I have not really found any good into on setting up the msce 2000 software. I think it found the old username/password info because whtn I started it, it did not ask me for any of that information.
How can I reload/set the admin password? I would like to get it going so I can start playing with visual studio 2005. I sure hope it knows how to play with MSDE 2000 properly.

Jr.CoderCleaning up really old threads; I assume you got this resolved one way or another long since?

MSDE reinstall.

I had MSDE installed on my machine, but I had problems making it work. I installed the Visual Studio 2005Beta2, and it apparently installed MSDE 2005. I deinstalled MSDE 2000, then tried to make MSDE 2005 work. After lots of hair pulling I finally found the instance name, reset the authenitcation method, and reset the SA password. Then I found out all my sql tools don't work with it. No enterprise manager or query analyzer. So off MSCE 2005 came from my machine. I reinstalled MSCE 2000, but I cannot login. I am not sure if I don't have the proper instance name, or password for the sa account. I have not really found any good into on setting up the msce 2000 software. I think it found the old username/password info because whtn I started it, it did not ask me for any of that information.
How can I reload/set the admin password? I would like to get it going so I can start playing with visual studio 2005. I sure hope it knows how to play with MSDE 2000 properly.

Jr.CoderCleaning up really old threads; I assume you got this resolved one way or another long since?

MSDE Event ID 208/17055 (Newbie)

Hello,
We get these events logged every night, apparently when
the SQLAGENT tries to do it's backup. I'm afraid I
didn't configure MSDE on this particular server, and I
don't have any Enterprise Mgr functions on the desktop,
so I'm slightly at a loss as to how to go about resolving
this issue, being that I'm a noob when it comes to SQL.
Any advise, help or pointers would be great.
A pint goes to the first correct answer!
Andy Griggs.
Hello,
If you have another computer with Entreprise manager, you can donnect to the
msde by the network..
Marc Allard
"Andy Griggs" <andrew.griggs@.agile-it.net> a crit dans le message de
news:20dd701c459ec$940620c0$a101280a@.phx.gbl...
> Hello,
> We get these events logged every night, apparently when
> the SQLAGENT tries to do it's backup. I'm afraid I
> didn't configure MSDE on this particular server, and I
> don't have any Enterprise Mgr functions on the desktop,
> so I'm slightly at a loss as to how to go about resolving
> this issue, being that I'm a noob when it comes to SQL.
> Any advise, help or pointers would be great.
> A pint goes to the first correct answer!
> Andy Griggs.