Logon Failed from Framework Manager

[twlarsen]

We have just installed Cognos 8.3 MR1.

From Framework Manager (And also from Cognos Connection) I can create and test successfully a new data source connection.  Then when I try to select the new data source from framework manager I get the following error.

QE-DEF-0285 The logon failed.
QE-DEF-0322 The connection string is invalid.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
Testing2

UDA-SQL-0031 Unable to access the "Testing2" database.
UDA-SQL-0534 Invalid connection string.
UDA-SQL-0206 The OLEDB driver returned the following value: HRESULT= -2147221164".

We are accessing a SQL 2005 db and using the native client access but OLEDB returns the same error...

Any thoughts?

-Todd

[Ty Clabbers]

When you test a datasource from Cognos Connection you use the setings from your Cognos server, when you work with Framework you use the settings on your local machine (it is client based software). I work with an Oracle database and I need an oracle client install in my pc with a tnsnames file similar with the one on the Cognos server.

[twlarsen]

Thanks,  we installed the SQL native client on my machine and I am able to connect!

Todd

[jayanthhyd]

QE-DEF-0285 The logon failed.
QE-DEF-0322 The connection string is invalid.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
test company

UDA-SQL-0031 Unable to access the "test company" database.
UDA-SQL-0534 Invalid connection string.
UDA-SQL-0206 The OLEDB driver returned the following value: HRESULT= -2147221164".



I am also having same problem please help me...
its urgent email me :jayanth1255@gmail.com

[Arsenal]

Did you try the solution posted which worked for twlarsen, i.e. install the native SQL client on your machine?

[dlafrance]

Thanks,  we installed the SQL native client on my machine and I am able to connect!

Todd

Thank you, this solution was what i needed when reinstalling transformer and FM on a new server!

[davide]

I had the same issue, but using a DB2 database, and the same solution worked for me - thanks!

I actually already had the DB2 client installed, but did not realise it was needed here. I had to configure a directory entry for the remote DB2 database, on the local DB2 client, and Framework Manager was then able to access the data source successfully.

[Mary11]

Hi All,

One of my user is facing an issue while connecting data source of SQL(OLE DB) type through C10 Framework manager.
when he try to select the data source from framework manager he gets the following error.

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:
Testing2
UDA-SQL-0031 Unable to access the "Testing2" database.
UDA-SQL-0532 Data Source is not accessible:"<datasourcename>"]
UDA-SQL-0564

The Data source test connection succeeded for an Cognos administrator when he does testing from Cognos configuration Page.
The user is able to connect the data source from SQL Management studio but not from FM.

Kindly suggest how to proceed as it is very urgent .
I will be very grateful for your replies.
Thanks.

[HalfBloodPrince]

Try this
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 <server name>,<port number>
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.

[Mary11]

HI HBPrince,

Ur comment was very useful.. in my server name dialog box i have given in this format:
server name/instance, port number.
Could you tell me the difference between named instance and default instance.
Why instance plays a role over here.
Onsite folks can able to connect without port number wereas offshore folks unable to connect without port number.
Whats the reason behind it.
Could you explain me pls.

[HalfBloodPrince]

in the default instance, it does not require a client to specify the name of the instance to make a connection. The client only has to know the server name.

A named instance is identified by the network name of the computer plus the instance name that you specify during installation. The client must specify both the server name and the instance name when connecting.