Re: Unable to run SQR without trusted connection:

[Allen Cunningham <allen.cunningham@SONOMA.EDU>]

Sarat - Get my white paper that describes how to do it from this archive:


http://groups.yahoo.com/group/peoplesoft/files/

The name of paper is 'running sqr from batch file'. It has all necessary
steps to do this. You will need sysadm password for the instance you are
running it out of. I have only done it against Oracle, but SQL Server should
not be too different.
HTH,

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 2:37 PM
To: SQR-USERS@list.iex.net
Subject: Re: Unable to run SQR without trusted connection:


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