Print Page | Close Window

Crystal Reports and Terminal Server

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=432
Printed Date: 05 Apr 2025 at 2:07am


Topic: Crystal Reports and Terminal Server
Posted By: techie3
Subject: Crystal Reports and Terminal Server
Date Posted: 29 Mar 2007 at 8:40am
Our office setup crystal reports (which has subreports and had to use code to pass login connection info to all tables of the reports).  The vb.net application with crystal files are installed on a Terminal Server.
 
When running the subreports only the Adminstrator get the resulting report successfully (without being prompted using the "sa" account in the code.)  However, another user gets prompted and when trying to enter the sa login, Crystal report viewer fails.
 
Can anyone offer guidance?


Replies:
Posted By: techie3
Date Posted: 01 Apr 2007 at 4:47pm
It turns out users accessing the subreports need explicit 'login' permission on SQL server.  I was hoping it wouldn't need it since this will now require maintenance because temps are hired.  (My other reports work fine without requiring their windows acct to be added.)

 Is there another way around this?


Print Page | Close Window