COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: nfldbunker on 22 Sep 2010 07:22:25 PM

Title: local install of framework manager
Post by: nfldbunker on 22 Sep 2010 07:22:25 PM
hi

just wondering how a local install of  framework manager works. is there any instruction as to set this up on a local machine and work with the current cognos environment.install locally it still requires username/password and wondering how this works without accessing the current cognos environment

regards

bunker
Title: Re: local install of framework manager
Post by: blom0344 on 23 Sep 2010 05:44:07 AM
FM has its own configuration tool. We basically only change the Gateway and Dispatcher URI to match the proper Cognos instance. With single signon enabled on the server this is all it takes
Title: Re: local install of framework manager
Post by: nfldbunker on 23 Sep 2010 05:52:22 AM
Hi

What if we do not have single signon. Should i replicate all the cognos configuration settings locally on the framework install to match what the server settings are

regards

bunker


Title: Re: local install of framework manager
Post by: nfldbunker on 23 Sep 2010 08:36:52 AM
hI

using these settings worked and the user was able to log onto the system. One issue they are having now when they open framework manager log onto the system and create a new package , create a new datasource is greyed out.

bunker
Title: Re: local install of framework manager
Post by: cognostechie on 23 Sep 2010 12:10:46 PM
The Data Source gets created in the Content Store. Does your FM have connection to the Content Store?
Title: Re: local install of framework manager
Post by: nfldbunker on 23 Sep 2010 01:07:10 PM
Hi

I have datasource connected and created in the content store through the admin section. The errror i am not receiving from the local install of framework manager is RQP-DEF-0120 Database connection is dropped
.
If i log onto the server and use this instance of FW manager it works fine but on the local machine i am getting this error


regards

bunker 
Title: Re: local install of framework manager
Post by: cognostechie on 23 Sep 2010 03:36:19 PM
You probably need the Content Manager installed on the local machine and configure that to connect to the Content Store. 
Title: Re: local install of framework manager
Post by: blom0344 on 24 Sep 2010 02:45:03 AM
nfldbunker,

Which database are you working with? What security did you set up? Once you create a datasource in Cognos administration it should be available for a local FM instance..
Title: Re: local install of framework manager
Post by: nfldbunker on 25 Sep 2010 12:32:17 PM
hi

i did not create the database in sql but was created by another user. that is why i am wondering if it could be some sort of security on the database. i created the datasource in cognos but when i try and access in framework manager locally i get the error but if the user who created the database tries in a local install of framework manager it works fine

bunker
Title: Re: local install of framework manager
Post by: blom0344 on 25 Sep 2010 01:15:40 PM
That seems likely..
You need to check how the datasource is setup. We typically use a single login that is reused for every database. Every datasource connection then has a sign-on that stores the specific account with the proper password. This enables acces to the database by SQL server authentication. Without the sign-on autentication may be performed through windows authentication. It is then quite well possible that this acces is denied.

To summarize, this is more a database/DBa issue then a Cognos one..