Link to home
Start Free TrialLog in
Avatar of john8217
john8217

asked on

MSDE for AdminDB pop-up keeps coming up.

    I installed some software on my Windows XP Pro PC and now, every day, I keep getting a MSDE for AdminDB pop-up. Initially, I though I'd have to configure that software to get rid of this pop-up, but it's dawning on me that this is a fairly common pop-up that occurs even when you install other software (and thus, this might be a Windows issue, not a software-specific issue).
     I've included an atachment which has screen shots and goes into some more detail.
pop-up.doc
Avatar of spamster
spamster
Flag of United States of America image

I would try downloading and installing MSDE update - hopefully it will repair installation and allow you to change your SA password.
http://www.microsoft.com/downloads/details.aspx?familyid=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=en
(Download sql2kdesksp3.exe)

Avatar of john8217
john8217

ASKER

    But I don't even use SQL Server on this PC. Should I still download this?
Avatar of Qlemo
YOU do not use it, DiskKeeper does. It seems to use the MSDE for administration purpose.

    I'm kind of in the dark about this. I installed this program but I still keep getting those pop-ups. I guess I need to do something else, (I'm assuming I now need to change that password) but I'm not sure what, or how to go about doing it.
     Maybe, instead, I could just uninstall MSDE for AdminDB. Or would that be a really bad thing to do?
You can try changing the SA password. (It may break DiskKeeper, if so we could go from there...)

http://support.microsoft.com/kb/322336

Open a command prompt (Start > Run > cmd)
type:   osql -U sa
It will prompt you with
Password:
Press Enter again. Since the password is blank you should see
1>
If you get a login failed message, let us know what it says.

Then type the following commands, replacing "complexpwd" with your new password.

sp_password @old = null, @new = 'complexpwd',  @loginame ='sa'  <press enter>
    go    <press enter>
I'll open a command prompt and type osql -U sa.
Then I'll hit Enter, but on the next line, instead of saying 1>, it's completely blank.
Furthermore, I'll try to type something, but nothing is coming out (its as if my keyboard isn't connected).
Furthermore, after a few seconds, the command prompt will close.
ASKER CERTIFIED SOLUTION
Avatar of john8217
john8217

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial