Database Help.....

[Puli5]

Hi,

I have 100 reports... while scheduling the reports, some of the reports are successful and some of the reports are failure. The failure reports are showing Unable to connect login parameters.. is there any possible for without given user name and pasword of the Database for schedule the report....i will give only Database name. i dont want to give the username and password for all reports..... where can i change these modifications in my report....


Thanks
Raj...

 

[Turkbear]

Hi,
If the database requires a login, then you must supply it when the report is run....
For scheduled reports the database info must be saved in the CMC - the password is not in clear text so no security issues are involved..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Puli5]

Hi Turkbear,

I want single signon without using user id and password of Database... I dont want to give userid and password in my CMC. i want to give only Database name. is there any possible in CMC without give userid and password for schuduling reports.. in my Database i have user id and password...here i am using Business object XI, in that help its only for Windows AD, but i am using Enterprise. i want setup on Enterprise...

Thanks
Raj...

 

[Turkbear]

Hi,
Not that I know of, however
if your database supports Windows authentication through its connection ( I think SqlServer's driver allows this) , you may be able to run the jobserver service under an account that has rights to the database and it may work.






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[bleuys]

Hi Turkbear,

you're right. If the jobserver service runs under such account it's possible.