SQL Database Upgrade. Issue with DB password

Asked By 0 points N/A Posted on -
qa-featured

I am looking for somebody to help me on an urgent basis.

I have a SQL 2000 Enterprise edition installed on Windows 2003. Recently I was advised by the vendor to upgrade the version of SQL to 2005, in order to install the new application running on SQL.

However, when I try to upgrade, it asks for the database password, which I cannot locate anywhere. I searched different SITES, and got the procedure to change the DB password, and I tried to change the same on the backup machine. The password was duly changed, but now the application is NOT running. I cannot take this risk on my live machine.

Please help me as to how I should approach? I want to first experiment on my backup machine.

Regards,

JR

SHARE
Answered By 0 points N/A #81567

SQL Database Upgrade. Issue with DB password

qa-featured

The problem should be with the changing of the password because apparently after changing you did not do the same to the SQL server, so that the information on the Windows network is the same as the one on the SQL server. This is the reason your program is not running. The information is mismatching so it cannot run.

Anytime you change a password you should update it in the following places/locations to enable matching.

1) On the server,

2) Change the user's ID, for MODTBAD,

3) Change it on the sa password on the client. When and after you ensure this, your system runs smoothly without hanging or stopping.

Windows network is the same as the one in the SQL server

Related Questions