Tuesday, April 24, 2012

Mixed Mode authentication but did not provide a strong password.

Upgrade SQL Server 2000 to SQL Server 2005

Today I was upgrading a SQL Server 2000 instance to 2005 and was getting the following error during the install.

You selected Mixed Mode authentication, but did not provide a strong password.


Even after changing the password for SA and using a strong password we kept getting this error. After a couple of attempts it became apparent that the problem was not with the password.

Then came across the following link that explained the problem and the work around.
http://blogs.msdn.com/b/sqlserverfaq/archive/2009/07/15/upgrade-advisor-returns-error-while-upgrading-an-instance-of-sql-server-2000-to-sql-server-2005.aspx

In short the solution is to copy the BPAClient.dll file from the following location 'C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin' to 'C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA'

After that the upgrade went without any hiccups. Once again thank you to Google.

If you do not find the file under the 'Program Files' folder then search under 'Program Files (x86)' folder.

No comments:

Post a Comment