Cognos Error: UDA-SQL-0529

Symptom
QE-DEF-0285 The logon failed.QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.RQP-DEF-0068 Unabe to connect to at least one database during a multi-database attach to 1 database(s) in: testDataSourceConnectionUDA-SQL-0031 Unable to access the “testDataSourceConnection” database.UDA-SQL-0528 The XML parser returned the following message: “An exception occured! Tyep:RuntimeException, Message: The primary document entity could not be opened. Id=[XML filename and location]”.UDA-SQL-0529 XML “[XML filename and location]” is not a valid XML document.RSV-SRV-0042 Trace back:

Problem
When testing the XML datasource the following message appears QE-DEF-0285 The logon failed.

Cause
The XML source file is not found on the server.

Solution
Copy the XML file to the server or place the XML file in a shared folder