Author Topic: How to tell how FM authenicates to the DB?  (Read 422 times)

Offline jcw3631

  • Full Member
  • ***
  • Join Date: Mar 2018
  • Posts: 6
  • Forum Citizenship: +0/-0
How to tell how FM authenicates to the DB?
« on: 31 Aug 2018 01:36:00 pm »
We can pull data and connect to all the DBs in FM but in the browser we cannot connect to any DB.  We get an error when we try to connect on the frontend.   We use Cognos 10.2.2 and our on a MS Server 2008 R2  and the DB is MS SQL Server 2017 

Please help

Offline khayman

  • Statesman
  • ******
  • Join Date: Jun 2009
  • Posts: 416
  • Forum Citizenship: +25/-3
Re: How to tell how FM authenicates to the DB?
« Reply #1 on: 31 Aug 2018 01:53:42 pm »
You mean you can't connect using Report Studio? or Cognos Connection?

but in the browser we cannot connect to any DB.  We get an error when we try to connect on the frontend.   

Offline jcw3631

  • Full Member
  • ***
  • Join Date: Mar 2018
  • Posts: 6
  • Forum Citizenship: +0/-0
Re: How to tell how FM authenicates to the DB?
« Reply #2 on: 31 Aug 2018 02:19:09 pm »
We can create the reports in Report Studio.  However when we try to validate a report it gives the error i posted.  Also, when trying to run reports get the same error in Report Studio.

In Cognos Connection we have checked the datasources connections and tried testing the connections and get the same OLE DB driver error.

Offline khayman

  • Statesman
  • ******
  • Join Date: Jun 2009
  • Posts: 416
  • Forum Citizenship: +25/-3
Re: How to tell how FM authenicates to the DB?
« Reply #3 on: 31 Aug 2018 02:35:34 pm »
it is possible that your FM (through cognos configuration) is using a different server from cognos connection where you get this error

Offline jcw3631

  • Full Member
  • ***
  • Join Date: Mar 2018
  • Posts: 6
  • Forum Citizenship: +0/-0
Re: How to tell how FM authenicates to the DB?
« Reply #4 on: 31 Aug 2018 02:50:45 pm »
They have just upgraded the SQL server from 2014 to 2017.  So what you are thinking is the name might of changed which is why we cannot connect to any of the DBs or run reports?  Do you think by chance permissions might of changed on the DB?

Offline khayman

  • Statesman
  • ******
  • Join Date: Jun 2009
  • Posts: 416
  • Forum Citizenship: +25/-3
Re: How to tell how FM authenicates to the DB?
« Reply #5 on: 31 Aug 2018 05:05:54 pm »
what i am thinking is your FM is accessing the db from server A (defined in cognos configuration). the db config in this server is ok.

then you open cognos connection from server B, thinking this is the server accessed by your FM.

this may or may not be the cause of the issue but i am suggesting first eliminating this possibility.

Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 268
  • Forum Citizenship: +32/-0
Re: How to tell how FM authenicates to the DB?
« Reply #6 on: 02 Sep 2018 07:03:28 pm »
The error message complains about the password being wrong.  Have you checked that?

Can you test and get results in FM?

Are you sure that FM is configured to use the cognos server which you're using for running the reports?


Offline Wolverine

  • Full Member
  • ***
  • Join Date: Mar 2018
  • Posts: 10
  • Forum Citizenship: +0/-0
Re: How to tell how FM authenicates to the DB?
« Reply #7 on: 04 Sep 2018 12:36:40 pm »
Additional information:  The environment in this case is a single server implementation. FM is launched locally from workstations, but is able to open the Models and test the database fields and entries. We are able to get valid test results from the data sources.

Through Cognos Connection, we are not able to run any of the stored (previously working) reports. Even in the 'Cognos Administration' tool, we are not able to test the 'Data Source' connection. We get the same error message.

Does anyone know how to validate the existing SQL driver in use?

Offline khayman

  • Statesman
  • ******
  • Join Date: Jun 2009
  • Posts: 416
  • Forum Citizenship: +25/-3
Re: How to tell how FM authenicates to the DB?
« Reply #8 on: 04 Sep 2018 12:58:10 pm »
are you sure that your FM is using the same server as your cognos connection?

Offline Wolverine

  • Full Member
  • ***
  • Join Date: Mar 2018
  • Posts: 10
  • Forum Citizenship: +0/-0
Re: How to tell how FM authenicates to the DB?
« Reply #9 on: 04 Sep 2018 01:45:45 pm »
Yes, there is only one Cognos 10.2.2 server. However, the Content Store (all data) is on a second server (MS SQL Server 2017).

Online sdf

  • Statesman
  • ******
  • Join Date: Feb 2014
  • Posts: 479
  • Forum Citizenship: +3/-0
Re: How to tell how FM authenicates to the DB?
« Reply #10 on: 04 Sep 2018 04:22:42 pm »
So can you focus on solving your database connection in cognos administration first.
I'm not sure if 2008 SQL uses the same database client as 2017. That's one thing check.


Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,471
  • Forum Citizenship: +632/-10
  • Cognos Software Muppet
Re: How to tell how FM authenicates to the DB?
« Reply #11 on: 05 Sep 2018 02:40:00 am »
They have just upgraded the SQL server from 2014 to 2017.  So what you are thinking is the name might of changed which is why we cannot connect to any of the DBs or run reports?  Do you think by chance permissions might of changed on the DB?

Hi,

You're posting in the Cognos 10 FM board, so I assume you're using Cognos 10? SQL Server 2017 is too new to be supported in Cognos 10 - C10 dropped out of official support last year, and is not being updated for platform/database conformance. To get support for SQL Server 2017 you'll need to upgrade to Cognos Analytics.

Cheers!

MF.
Meep!

 


       
Twittear