Data Connectivity
 Crystal Reports Forum : Crystal Reports .NET 2003 : Data Connectivity
Message Icon Topic: Crystal Reports and Terminal Server Post Reply Post New Topic
Author Message
techie3
Newbie
Newbie


Joined: 11 Jan 2007
Location: United States
Online Status: Offline
Posts: 18
Quote techie3 Replybullet Topic: Crystal Reports and Terminal Server
    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?


Edited by techie3 - 29 Mar 2007 at 8:41am
IP IP Logged
techie3
Newbie
Newbie


Joined: 11 Jan 2007
Location: United States
Online Status: Offline
Posts: 18
Quote techie3 Replybullet 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?
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.