473,765 Members | 2,047 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

"Logon failed" in Crystal reports when switching to a different database server

Running Crystal Reports with the hotfixes and patches & VS 2003.

I created a CR report on my development server which has SQL Server. The
report runs fine inside Visual Studio. When I switched the source of the DB
to the production server using the 'set location' option in CR and ran the
app again, I get "Logon Failed" error message. The database wizard worked
fine so this tells me CR was able to connect and retrieve the schema from
the second server and permissions are ok. So why am I getting a "logon
failed" message? AFAIK, CR saves the logon info in the .rpt file.

--
John Dalberg
Nov 19 '05 #1
1 2284
On Thu, 10 Feb 2005 08:21:53 -0800, John Dalberg wrote:
Running Crystal Reports with the hotfixes and patches & VS 2003.

I created a CR report on my development server which has SQL Server. The
report runs fine inside Visual Studio. When I switched the source of the DB
to the production server using the 'set location' option in CR and ran the
app again, I get "Logon Failed" error message. The database wizard worked
fine so this tells me CR was able to connect and retrieve the schema from
the second server and permissions are ok. So why am I getting a "logon
failed" message? AFAIK, CR saves the logon info in the .rpt file.


I found the answer.
KB 319264

--
John Dalberg
Nov 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
6262
by: VC | last post by:
Hello, I have an issue here. Hope someone can help me. Issue: Developer is using a web application from one server (IIS) (say Server A). A second server (say Server B, which is SQL Server 2000) hosts the stored procedures. The SQL datawarehouse is hosted on a third server (say Server C ,which is SQL Server 2000) and contains allof the data.
0
1935
by: sztonix | last post by:
Hi all, I encountered a crystal report deployment problem. I make reports with Crystal Report for Visual Studio .NET 2003. It works fine in the development machine. And then make setup package. Installed on a windows server 2003 system (without visual studio .net 2003), the report gives error about "Logon Failed". The data source is specified to OLE DB SQL Server, and the LogOnInfo is specified by
1
2941
by: keefah | last post by:
Hi, I can't seem to get past this problem, though I've tried multiple examples off the web. I've registered integrated Crystal (VS.NET 2003 Pro). I've made sure the assemblies are all there. I've tried design-time ReportSource assignment and runtime. Why can't I get past this? Below is error page from most basic of tries (just a dumb (text only) report within a viewer on a webform. Thanks in advance, -Nick Description: An unhandled...
2
3907
by: Karun Karunakaran | last post by:
Hi, I am using the Crystal Enterprise .NET assemblies to generate and display a crystal report in a webform. This report connects to an SQL server (running locally) using a specific username and password. I use the InfoStore object to query for the report from the CE server (also running locally) and bind it to the CrystalReportViewer control in the webform. I am getting an "SQL Server logon failed" when I try to generate this
1
2964
by: Ezra | last post by:
Our company's web server is trying to access graphics files on another server. When I run the app from Visual Studio (1.0) on my localhost, the server in question is available (which is accessed a virtual directory) and I'm able to display the files. However, when we logon to the intranet through a browser, and click the link which will display the files, we get the "Enter Network Password" logon box. We set the proper permissions on...
1
1913
by: Roy | last post by:
Hey all, I have a VB App which uses the bundled version of Crystal Reports for VS.NET 2003. It works fine in when I run it using VS *but* when I deploy it anywhere (including the development PC itself) it won't load a report and displays the cryptic "Load Report Failed" error. It's frustrating. Why would it work great on my machine using the VS "Start" option, but fail to work when I try to run it as an executable?
2
3296
by: Jeff_Mac | last post by:
Hi there. I'm a bit of a newbie, and I would appreciate any help that anyone can give me on an error I'm getting with Crystal Reports. Every time I attempt to view a report using the Crystal Report Viewer, I get a "Load Report Failed" error, and I'm not sure what I can do to resolve it. I know it's not the connection to the data -- I'm able to get a datagrid to display the data just fine after filling a dataset. I tried searching the...
0
1587
by: Darrell | last post by:
I am using VS 2005 Beta 2 on XP Pro. I have created a WebService with an "empty" Crystal Report. The only thing in this report is a text element saying "Hello World!". If I run the WebService via debugging on the APS.NET Development Server, all is fine. When I try this via IIS 5.1, I get the exception "Load Report Failed". I believe that I have set folder permission rather open to see if this gets rid of the problem but still no go. Is...
1
1800
by: aaaaaa | last post by:
running a crystal (v10) reporting app on a virtual web server and getting the "Validation of viewstate MAC failed...." error when opening the crystal viewer. Any help please!!!
0
9568
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10163
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9835
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7379
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5423
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3924
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3532
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2806
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.