Re: Unable to run SQR without trusted connection:

[Sarat <sjyotsna@YAHOO.COM>]

Hey Allen,
     I am not aware of that. I did go to SQR class 2
yrs back but I may have forgotten!
I would appreciate you helping me set this up.
Thanks
Sarat.
--- Allen Cunningham <allen.cunningham@SONOMA.EDU>
wrote:
> Sarat - Do you know the technique of running SQR
> outside of proc scheduler
> from a batch file? This is the recommended, but
> unpublicized way the
> PeopleSoft SQR instructors teach.
>
> ac
>
> -----Original Message-----
> From: Discussion of SQR, Brio Software's database
> reporting language
> [mailto:SQR-USERS@list.iex.net]On Behalf Of Sarat
> Sent: Thursday, May 23, 2002 1:06 PM
> To: SQR-USERS@list.iex.net
> Subject: Unable to run SQR without trusted
> connection
>
>
> Hello,
>
> DB: SQL Server 2K
> OS: WINNT
> APP: PSoft HRMS 7.51, SQRW
>
>  I want to run an SQR using SQRW.exe (outside
> PeopleSoft). I tried to use PeopleSoft OPRID and
> password but it errored saying "Access denied on
> various tables, owner not dbo) even though my access
> id is 'sa' for my PSoft Oprid. So I used SQL Server
> login a/c  windows authentication way.
> Every time I try to run an SQR, it gives me
> "connection failed" followed by "Use Trusted
> Connection?" window. When I check (yes) the box, I
> can
> run the sqr. How and where o I set "Use trusted
> connection" always?
> Or how can I use my PSoft id to run SQRs?
> Thanks,
> Sarat.
>
>
> __________________________________________________
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com


__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com