If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

creating a secod framework manager model

Started by nfldbunker, 27 May 2009 07:45:40 PM

Previous topic - Next topic

nfldbunker

hi

just wondering if anyone could tell  me how to create a seond model to a sql database on a seperate server than the one that cognos is installed on..I am trying the connection and it prompts me for a username and password. I tried several paaswords and did not work. Do i need another sa account on teh other sql server. I am fairly new to cognos .

thanks for all your help

bunker

blom0344

You do not need to have an sa account (no developer should have), but you do need to have rights to access the SQL server instance. so the account you are working on should be authorized to access the server (either directly or as part of a group) All of this assuming that you use windows authentication to the server..

nfldbunker

hi i do have access this server and play with the server in question. i have a network account that gives me full access to this server but the network account dont seem to work when trying to create this datasource in framework manager

blom0344

Did you specify the correct servername in the Cognos connection string?