Connection Wizard cannot connect to server BPC 7.5

Hi All, I have a rather puzzling problem ... I can connect via the Web and Server manager diagnostics are all green, however I cannot connect via the connection manager (which affects Excel and Admin Consol.

The error message I get is:

This is exactly the error described in SAP Note 1584440, however I have applied the solution with no effect.

SAP note 1502823 suggests this is a client installation issue, however our clients are MS Office 2007 and 2010, and they did work on the previous installation.

Please note the user name given in the error message ... this is NOT the user attempting to log in.

Further info:

Multi-Server

App Server: Windows 2003 R2 64 bit

Database: SQL 2008 R2 64 bit

BPC is 7.5 SP06 patch 1

History:

This was a 100% working system, but rather slow, so it was decided to move the database portion to another server. In order to do this I uninstalled and reinstalled BPC (exact same version), just changing the database server.

Installation completed successfully

Server Diagnostics are 100% green

3 separate clients have been tried & all give exactly the same problem.

Additional info: The connection wizard is not giving the option to use "Windows user name or password", I have attempted setting SOX compatiblity on & off again (suggested in another thread) as well as cleaning out all history of passwords/usernames, etc. as per thread http://scn.sap.com/thread/1650279 I am not sure if this is a related issue or not.

I have uninstalled & reinstalled BPC Server 3 times now ...

Any help would be more than welcome ...

Regards,

Peter