In upgrading our Zenworks Asset Management 7.5 to ZCM 10, I wanted to use the Zenworks Migration Tool 10.2 for migrating the workstations. Problem starts when running the Migration Tool, I cannot connect to the original Standalone database. The message states

Connection Error:

Index #0
Message: Login failed for user ...
Line Number: 0
Source: .Net SqlClient Data Provider

I believe something along the lines of ODBC connection or Windows Authentication vs Mixed Mode authentication on the source server database.

Our source server is a Windows 2000 Advanced Server
SQL Express 2005
Database = ZAMStandalone

I can ping the server with name and IP address resolving no problem.

Any help would be appreciated.