Author Topic: Logon Failed from Framework Manager  (Read 33896 times)

Offline twlarsen

  • Community Leader
  • *****
  • Join Date: Sep 2006
  • Posts: 123
  • Forum Citizenship: +5/-0
Logon Failed from Framework Manager
« on: 02 Apr 2008 09:29:22 pm »
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

Offline Schleppel

  • Senior Member
  • ****
  • Join Date: May 2006
  • Posts: 59
  • Forum Citizenship: +3/-0
Re: Logon Failed from Framework Manager
« Reply #1 on: 03 Apr 2008 02:46:29 am »
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.

Offline twlarsen

  • Community Leader
  • *****
  • Join Date: Sep 2006
  • Posts: 123
  • Forum Citizenship: +5/-0
Re: Logon Failed from Framework Manager
« Reply #2 on: 03 Apr 2008 10:26:46 am »
Thanks,  we installed the SQL native client on my machine and I am able to connect!

Todd

Offline jayanthhyd

  • Senior Member
  • ****
  • Join Date: Aug 2010
  • Posts: 72
  • Forum Citizenship: +0/-1
Re: Logon Failed from Framework Manager
« Reply #3 on: 29 Mar 2011 05:38:15 am »
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

Offline Arsenal

  • Statesman
  • ******
  • Join Date: Feb 2007
  • Posts: 384
  • Forum Citizenship: +18/-1
Re: Logon Failed from Framework Manager
« Reply #4 on: 29 Mar 2011 11:01:50 am »
Did you try the solution posted which worked for twlarsen, i.e. install the native SQL client on your machine?

Offline dlafrance

  • Community Leader
  • *****
  • Join Date: Feb 2008
  • Posts: 77
  • Forum Citizenship: +2/-0
Re: Logon Failed from Framework Manager
« Reply #5 on: 25 Jul 2011 09:49:08 am »
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!

Offline davide

  • Associate
  • **
  • Join Date: Oct 2011
  • Posts: 1
  • Forum Citizenship: +0/-0
Re: Logon Failed from Framework Manager
« Reply #6 on: 04 Oct 2011 06:14:24 am »
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.

Offline Mary11

  • Full Member
  • ***
  • Join Date: Oct 2012
  • Posts: 8
  • Forum Citizenship: +0/-0
Re: Logon Failed from Framework Manager
« Reply #7 on: 29 Oct 2012 11:33:02 pm »
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.

Offline HalfBloodPrince

  • Community Leader
  • *****
  • Join Date: Nov 2011
  • Posts: 246
  • Forum Citizenship: +9/-1
Re: Logon Failed from Framework Manager
« Reply #8 on: 02 Nov 2012 12:04:24 am »
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.

Offline Mary11

  • Full Member
  • ***
  • Join Date: Oct 2012
  • Posts: 8
  • Forum Citizenship: +0/-0
Re: Logon Failed from Framework Manager
« Reply #9 on: 08 Nov 2012 01:21:07 pm »
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.

Offline HalfBloodPrince

  • Community Leader
  • *****
  • Join Date: Nov 2011
  • Posts: 246
  • Forum Citizenship: +9/-1
Re: Logon Failed from Framework Manager
« Reply #10 on: 08 Nov 2012 11:38:44 pm »
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.

 


       
Twittear