UDA-SQL-0031 Unable to access the "testDataSourceConnection" databasename

UDA (Universal Data Acces) Errorcodes UDA-SQL
1

Symptom
When trying to connect to a reporting database the following errors occur
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 Unable to connect to at least one database during a multi-database attach to 1 database(s) in : testDataSourceConnection
UDA-SQL-0031 Unable to access the “testDataSourceConnection” databasename
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server][DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or
access denied. (SQLSTATE=08001, SQLERRORCODE=17)

Cause
The MSSQL instance not running on standard port 1433.

Environment
Windows 2003, Microsoft SQL Server 2000

Solution
Ask your SQL DBA for the correct port number. Then create the datasource connection. The port must be entered when the server name is defined. This must be in the form of ‘server name,port’. Be sure to use a comma to separate the server name and the port number. This port number should be the port number that the database instance is running on.

Steps:

  1. From Cognos Connection click ‘Tools’, ‘Directory’, ‘Data Sources’
  2. Select the ‘New Data Source’ icon
  3. Type a name in the ‘Name’ dialog box and click Next
  4. For the type select ‘OLE DB’ and click ‘Next’
  5. In the server name dialog box type the server name followed by a comma and then the port the database server is running on. This should be in the notation of ,
  6. Enter the required information as per the usual creation of a datasource.
  7. When available, click ‘Test’ to test the connectivity to the new datasource.
    Loading…
2

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.