[solved]User id and pwd for Connection

[BIsrik]

Hi,

Ã,  I have installed crn on my personal pc. I configured it fine and the cognos connection also opens. I then deployed the cognos standard package and also configured the database gosalses and goretailers. But when i run the report it prompts me for the database userid and pwd. How to stop these. The report needs to run without prompting for a database connection userid and pwd.

Srik

[MFGF]

My guess would be that you have not set up the database connections in ReportNet with the password included in the signon.  Go to Tools/Directory, onto the Data Sources tab, click on the link for the gosales database, and within that you should see the gosales connection.  Press the set properties button on the right and go to the connection tab.  Next to the connection string, press the edit button (pencil) to edit the connection, and make sure the password checkbox is checked.  Press press OK to both dialogs, then click on the link for the gosales connection.  You should now see the gosales signon - press the set properties button on the right, go to the signon tab, and edit the signon to make sure you have the correct userid and password defined.

Repeat this process for goretailers, and hopefully that should fix your problem.

Regards,

MF.

[BIsrik]

Since i have installed it on my pc i have not set any access rights..The default security everyone is present. In this scenario what i need to update in the signon.

Srik

[MFGF]

Hi Srik,

When I'm referring to signon, I'm not talking about ReportNet access rights, I'm talking about the database userid and password, which needs to be set up for each database connection.  I assume you set up the sample databases in SQL Server - if so, the signon required is whatever userid and password is valid for the database in SQL Server.

Regards,

MF.

[BIsrik]

Thanks, there was no database signon present in both the connections. Created them and it worked. Before i update the topic, i wanna know by saying single signon access, these what people do. Sorry, i don't have any idea towards administration.

Srik

[MFGF]

Hi Srik,

'single signon access' really refers to the fact that users of ReportNet sign on once as they connect, and from there the system is configured to give them access to all related information (including databases, PPES cubes etc) without prompting them for a signon again.  So yes, this does form part of the single signon access setup.

Best regards,

MF.

[BIsrik]

To have this single signon access what i need to do. I heard some terms like LDAP.. ??? No idea what it is. Currently the installation is only on my PC. If i want to make it a server for CRN and give access rights to each user what i need to install or configure..

I have no idea about this administration part and i am learning now. reading the manuals also. Give me some guidelines to do this..

Srik

[cognosfreelancer]

you have several options. The easiest would be to setup LAE (File) based security using Cognos Access Manager from series 7 software and have ReportNet use it. In this case you can enable OS Signon for specific users from within Cognos Access Manager administration.

In series 7 you can also use the default LDAP server that comes bundled.

If you do not want to use Series 7 security within ReportNet then you can use either the generic LDAP provider or providers such as Active Directory. It is harder to configure the generic drivers for single signon but even the Active Ditrectory is quite tricky to configure for SSO.

In all cases you need to enable 'Integrated windows authentication' from the IIS web server.

This note assumes you are using Microsoft technologies all the way through.

Refer to my earlier postings on this subject in other areas of the forum for more advanced info.

HTH

NKT

[BIsrik]

thnks, Will check it on more..

Srik