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