SQL Database Upgrade. Issue with DB password

Asked By JENNIFER ROTH 0 points N/A Posted on - 09/26/2011

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

• Status: Open
• Question Views: 724
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Rodney2001 0 points N/A #81567

SQL Database Upgrade. Issue with DB password

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.

About Rodney2001

Questions
0

Answers
5

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 10/18/2011
• Question Category: MySQL Server