UDA-SQL-0532 Data Source is not accessible:"<datasourcename>"]

Symptom
QE-DEF-0285 Logon failure.
QE-DEF-0323 The DSN(ODBC)/serviceName is invalid. Either the DSN is missing or the host is inaccessible.
QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: testdatasourceconnection

Problem
This field is displayed on the search results webpage seen by customers, and effects search ranking and relevance.
QE-DEF-0285 Logon failure when testing a database connection

UDA-SQL-0031 unable to access the datasourceconnection database
UDA-SQL-0532 Data Source is not accessible:""]
ORA-12154: TNS: could not resolve service name

Cause
Insufficient permissions

Solution
Change the IBM Cognos 8 service so that it is not run under the local system account, but rather from a named account and restart the service. This facilitates things like the use of UNC paths to specify configuration settings, printing services, and other important features.The named account must be part of the administrators group or power users group for the local machine. The users group does not have sufficient rights to modify/start/stop services.