I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures. The code I provide is meant to be illustrative of a point and is not meant to be used in a live application. You may have to or before you can post: click the register link above to proceed. Database Vendor Code: 102 There are several causes of this error. This is useful since we have several hundred actively used Crystal Reports in which the connection information is embedded in the report.
I don't see any option to set this up in the report itself. I have the crystal developers edition on my local machine, designed and saved a report runs fine on my machine. Or would it work to have a common reporting id for the database that all of the reports would use? But when I use the Crystal Report 2008 Development Tool to launch bot the main and the sub reports they loaded fine without any issues. If you know of any other ones let me know. The error is: failed to open the connection. I have tried using the trusted user but still get the exact same error.
If I try to refresh manually I have no issue at all. My password, is the same for both the crystal and the sql machine. I agree to my information being processed by TechTarget and its to contact me via phone, email, or other means regarding information relevant to my professional interests. Here is what I have done so far. Refresh ; Thanks in advance. Browse other questions tagged or. Not the answer you're looking for? Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 on this site the.
The main problem is that my reports work perfectly on my local computer, but when I try to run those reports on client server architecture the following error comes up and application stop working. Do you have similiar experiences, can you point me the right way? I can connect with my Windows account though. The most likely explanation is the most likely to be the right one. State 1 is used to hide actual state in order to protect the system, which to me makes sense. Just happened to me, and turned out to be different than all other cases listed here.
I am able to remote to the server using this account. Any help in this issue is appreciated. So, I am hoping that if you try to create a udf file like the article suggests. Additional note: Check in the connection parameters tab if you've not forgotten some strange connection string there. Above that,, ask your questions.
Post navigation Dear Justin, Thanks for your valuable post and solution. Cannot find anything, except where I can schdule the report to run, tried that,, and that is when I get the above error. Password might have expired and probably several other reasons…. So you just created your login on LocalDb. Now you can able to login and put your user name as 'sa' and password is your won password.
Once I disabled my wireless adapter and rebooted, the Windows integration switched back to the domain account and authenticated fine. Not the answer you're looking for? You may need to open a case with support with our Admin or authentication team. I am working on a application, which includes some reports. It appears as though it depends on how the user is logged on to the network as to whether or not they are able to run the reports. I checked through the Crystal Report settings and help files and could not see any information on how to correct this issue through Crystal Reports, although many people seem to have been reporting the same error. However I came up against many dead ends the solution would have to ensure that Crystal Reports would be forced to connect with a user and password. Would you like to answer one of these instead? At first I forgot to restart the services, so I was still getting the error, but now I am able to connect without an issue.
Browse other questions tagged or. . Here is the link to the article:. Also, we are using two different versions of Crystal Reports. The login also contains the exact properties of the same login in my old server.
Specifically, you may not copy entire articles and publish them on your own site even if you provide a link back to my site. If in future we need to change the account user or password we will be able to do so in a centralized location rather than having to update several hundred Crystal Reports. Is there anything such as recompile the application? To make this integration as seamless as possible we made sure to re-point traffic directed to the old database server name to the new server name. This is obviously a bug that many people are experiencing, but most help requests end with the person being told to make sure their connection information is correct, which is quite unhelpful and not the problem. Please tell me what can be the possible cause and any directions i should look into? I had already set up Mixed mode as you had already done as well so the previous posts do not apply. I stumbled upon this blog which seems to be a few years old.