SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Error while running 2005 upgrade advisor


Error while running 2005 upgrade advisor

Author
Message
MANU-J.
MANU-J.
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14842 Visits: 8766
Hi,

When I am trying to run 2005 upgrade advisor wizard for my sql 2000(devloper edition) its failing at last step(Analyze SQL Server).

Below mentioned error message is getting logged under eevnt viewer:

EventType clr20r3, P1 bpacmd.exe, P2 2005.90.2047.0, P3 443f5935, P4 bpacmdx, P5 9.0.242.0, P6 443f5932, P7 7, P8 7a, P9 system.io.filenotfoundexception, P10 NIL.

I am not able to understand what it states and what is required to make its run successful.

When I try to upgrade the existing 2k instance directly using 2005 setup files its failing at verification step with error(upgrade advisor returned -1).

I have another instance of sql 2008 release code0 installed on same box too(and also with SQL Server 2008 upgrade advisor wizard).

Can this be a problem as both are there on one machine?

Please help.....

MJ
tucankur
tucankur
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 42
There is a folder called BPA and under the child folder called "binn" there is a file called bpnclient.dll. Create a new folder under the main BPN folder called the bpnclient and move this file into that folder from the binn folder and rerun your upgrade...it should work!
MANU-J.
MANU-J.
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14842 Visits: 8766
I had to uninstall and install the .NET framework again to make it work. Sorry, I got your suggestion too late.

Thanks again,
Manu
sqlish
sqlish
Mr or Mrs. 500
Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)

Group: General Forum Members
Points: 535 Visits: 261
Hi There i have the same issue when i run the upgrade advisor the sql server, i tried creating a new folder named BPNCLIENT and copied the .dll (BPAClient.dll), however i still have the same issue...

could you please help me out on this...

=======================================================================================

Visit my technical reference; you might find some of your issues already documented.
MANU-J.
MANU-J.
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14842 Visits: 8766
MANU (10/20/2008)
I had to uninstall and install the .NET framework again to make it work. Sorry, I got your suggestion too late.

Thanks again,
Manu


Follow the above advice if you tried every other option available.

MJ
sqlish
sqlish
Mr or Mrs. 500
Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)

Group: General Forum Members
Points: 535 Visits: 261
Hi Manu,


I tried the 'bpaclient' folder instead of 'bpnclient' and it worked. I thing it was a typo in your solution.

Now i ran the upgrade advisor succesfully, and fixed the pre upgrade issues, however during the actual upgrade i am getting the below error:

I am upgrading sql server 2000 std edition to sql server 2005 std edition.
"


TITLE: Microsoft SQL Server Setup
------------------------------

UpgradeAdvisor returned -1 .
Error message:

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=29552

------------------------------
BUTTONS:

OK
------------------------------


"

The link given in the error says i have choosen mixed authentication mode and asks me to set a strong password for 'sa'.

I tried setting up a strong password for 'sa' but no use.

then i changed the authentication mode of the sql server 2000 to windows authentication and ran the setup again, only to see the same error again...


Could you please help me on this quickly, i am in the middle of the upgrade change window.

Thanks in advance
Suleman

=======================================================================================

Visit my technical reference; you might find some of your issues already documented.
MANU-J.
MANU-J.
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14842 Visits: 8766
From googling:

Several simple solution steps:

1*. Go to Administrative Tools / Domain Security Policy :: Security Settings | Account Policies | Password Policy

2*. Ensure "Minimum password length" and "Password must meet complexity requirements" set to "Not Defined" state.

* Skip this steps if you don't have domain controller.

3. Go to Administrative Tools / Local Security Policy :: Security Settings | Account Policies | Password Policy

4. Turn "Minimum password length" to zero and "Password must meet complexity requirements" to "Disable"

5. Go to SQL Installation window and press "Retry".

6. After installation successfully done, turn changed security settings from steps 1-4 back.

7. Have fun.


MJ
MANU-J.
MANU-J.
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14842 Visits: 8766
Or

Make sure you follow restrictions mentioned at http://msdn.microsoft.com/en-us/library/ms161959(SQL.90).aspx

MJ
sqlish
sqlish
Mr or Mrs. 500
Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)

Group: General Forum Members
Points: 535 Visits: 261
I am not authorized to try the solution given abt the windows group policy...

however i tried the sql server strong password thing, and i still have the same error.

=======================================================================================

Visit my technical reference; you might find some of your issues already documented.
MANU-J.
MANU-J.
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14842 Visits: 8766
Have you logged in with admin privileges on this box?
If the machine is not a domain controller then you must be able to do the following changes:


3. Go to Administrative Tools / Local Security Policy :: Security Settings | Account Policies | Password Policy

4. Turn "Minimum password length" to zero and "Password must meet complexity requirements" to "Disable"

5. Go to SQL Installation window and press "Retry".

6. After installation successfully done, turn changed security settings from steps 1-4 back.

7. Have fun.

MJ
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search