[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Unable to run SQR without trusted connection:

Re: Unable to run SQR without trusted connection:when running from SQRW use
the database username and password, you are not connecting through
PeopleSoft
  -----Original Message-----
  From: Sarat [mailto:sjyotsna@YAHOO.COM]
  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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.362 / Virus Database: 199 - Release Date: 05/07/2002