Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Third Party Products

User login

Frontpage Sponsor

Main

Poll
As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
50%
Handover everything to System Integrator from drawing BP till implementation of ERP
0%
Hire more inhouse skilled & capable IT Resource to work directly with SI
50%
Rely on SI Architects/Consultants
0%
Total votes: 2

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 25th April 2012, 22:56
batmush's Avatar
batmush batmush is offline
Senior Member
 
Join Date: Jan 2005
Posts: 117
batmush is on a distinguished road
Baan: BaaN IVc4 - DB: Oracle - OS: 2003 Server
Crystal ActiveX viewer requires user/pass

Hi all,

We want to move our Crystal reports website to another server from the original Baan server. Doing tests we found that it requires user/password to access baan db when opening reports from the new server. See picture.

Does anyone know why?
Attached Images
File Type: jpg activex-user-pass.JPG (41.6 KB, 22 views)
Reply With Quote
  #2  
Old 30th April 2012, 23:13
batmush's Avatar
batmush batmush is offline
Senior Member
 
Join Date: Jan 2005
Posts: 117
batmush is on a distinguished road
Baan: BaaN IVc4 - DB: Oracle - OS: 2003 Server
Hi all,

I see that the initial question was complicated or not detailed enough.
Can someone who's using Crystal through ODBC and with ActiveX viewer share screenshots of Security settings in SQL server, BUILTIN\Administrators in particular?
Reply With Quote
Sponsored Links
  #3  
Old 4th May 2012, 05:57
batmush's Avatar
batmush batmush is offline
Senior Member
 
Join Date: Jan 2005
Posts: 117
batmush is on a distinguished road
Baan: BaaN IVc4 - DB: Oracle - OS: 2003 Server
I'm missing something because I tried everything and IIS still doesn't pass user/password to SQL. Can be difference in bit (32 vs 64), or maybe XP IIS cannot communicate with SQL 2008 R2. Ended up with creating user in SQL that has reader rights only and passing the credentials in URL link like ...reportname.rpt?user=username&password=password
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Seagate Crystal Enterprise Integrated Baan Reporting Setup in IVc ulrich.fuchs Tools Administration & Installation 8 18th September 2009 09:59
Crystal Report Questions for BaanIVc4 steventay Tools Development 6 7th April 2009 04:45
Crystal Reports / Crystal Enterprise dbundaru Third Party Products 2 24th July 2003 00:09
Crystal Enterprise and Baan Native Driver shelley Third Party Products 0 9th August 2002 19:33


All times are GMT +2. The time now is 12:05.


©2001-2018 - Baanboard.com - Baanforums.com