Incorrect sa password when installing MSSQL 2000 service pack 3a
Posted on 2004-09-10
I have had a recurring problem with SQL 2000 where sql agent keeps getting stopped at 10:30 each night and interupting the running database maintenance plan.
I wondered whether the Slammer virus might be at work although my up to date Sophos scan doesn't detect it.
I decided it was time to install service pack 3a to protect against Slammer but when I install using SQL user/password verification with user sa and no password, I am informed that the user and/or password can not be verified. I can log into the existing sql database or use query analyser without any problem with the sa log in with no password.
To add to my problems, when I now try to install the service pack, I am informed that "A previous program installation created pending file operations. You must restart the computer before running setup"
I have rebooted the server several times (running Win 2000 server) without sucess and even tried deleting some temporary files in the windows temp directory.
Any suggestions on what I do to resolve both the sa password and previous program installation problems would be most welcome.