Crystal Report Popup Logon Window On Windows Server 2012 R2 (IIS 8.5)

[Former Member]

I have a web application that works so well with Windows 7 (IIS 7.0) and Windows 8 (IIS 8.0). Both Windows 7 and Windows 8 are running SQL Server 2012.

My Problem started when I deployed to  Windows Server 2012 R2. Now I m getting a pop-up windows requesting logon information.Server Name,Database Name and User Name are not editable except password textbox.

My Crystal Report version is 13.0.2000.0. And I have installed Crystal for Visual Studio 2012 (CRforVS_13_0_6 ). My Database ( SQL Server 2012) is also installed on the same machine. Both Windows and SQL Authentication are enabled. The same code moved to fresh windows 8 and 7 and everything works fine. Please I need help.

Thanks Danjay

[Former Member · Accepted solution]

You pretty much need to edit the reports as Ludek specified to download the trial and edit the reports to use the newer SQL OLE connection especially if your using sql auth. Meaning in your reports you probably have them saved using "SQLNCI" an old SQL 2000 provider and need to use "SQLNCI10" 2008 provider or "SQLNCI11" 2012. You could also write code to update the connections info when there executed "this is how I fixed the issues so I would not have to update every report" , if your already doing this, then in your web.config change it.

You might also work around this issue by installing an older native client like 2005 but this may not work for you since SQL is on the same machine as the web app running the reports.

Good luck!

[Former Member · Accepted solution]

Thanks Keith

I would prefer the code option. Could you kindly show me sample of this code,it might be the solution that i need.

I was not the original developer. The web application was developed back in 2005 by a client in-house  developer. Somehow for some reasons the developer is gone. I initially the app could not even load.

I had to install the crystal report run times and then later changed some assembly reference in web config. Some debugging effort.And so everything works on my windows 7 machines. It also works on windows 8 machine. And now the same setup on windows server 2012. Only few reports works. But lots of them are not working. Redesigning or editing the report cant be the an option. I rather not start it. I might have to move back to either windows 8 or windows 7. 

Would be there be any major draw back hosting on windows 8 or windows 7

Thanks

[former_member183750 · Accepted solution]

By asking for help with the code, you really are putting the cart ahead of the horse. I am not sure why you are resisting the suggestion of trying this in the CR designer first. Baby steps first, then try to walk, never mind running...

If you really want to try running, using the search box in the top right corner will bring up all kinds of resources, including developer help files and sample apps...

- Ludek

[Former Member · Accepted solution]

I'm a little confused. How did you update the report already to point to your new SQL server without an external config file? Also i'm guessing you used different credentials to logon to the new SQL server how was this all changed?

But again, I still agree with Ludek, download and install the demo designer onto a different machine not the one with the runtime as it causes issues. Edit a report that is working and look at its connection info and then edit a report that is not working and see its settings.

for recoding you would be better off using the samples they provide.

Also this issue is not because you moved to server 2012 its because you moved to SQL Server 2012. If you want the easy fix go back to SQL 2005.

[Former Member · Accepted solution]

Thanks Keith,

As for the Connection into SQL Server, I m using the same Credentials with the same as it the Old.

Same Database Name, UserID and Password.Also in the Pop-Up, all the fields are blanked out which does not allow editing except the password Textbox.But I have not tried changing the Server Name to the same old one.I will try this and get back to you.

I would install the demo designer as recommended and get back to you. But ultimately I don't want to go that path. I simple would prefer something that I can install or change at one point and everything Works just like the windows 7 and 8 OS.

Also this issue is not because you moved to server 2012 its because you moved to SQL Server 2012. If you want the easy fix go back to SQL 2005.

I dont quite agree with you on this because the same setup  works perfectly on Windows 7 and Windows 8. Both windows 8 and 7 all fresh systems. Web application  and SQL Server 2012 both on the same machine. Crystal report runtime (CRforVS_13_0_8)  installed on the same machine.

Regard

[former_member183750 · Accepted solution]

Hi Danjuma

Please understand that my recommendation re. the designer was for testing purposes, not a final solution. Apologies if that was not clear

- Ludek

[Former Member]

You will most likely need to install Microsoft SQL Server Native Client that contains the newest provider packs to connect to SQL normally embedded in your reports. The issue your experiencing is a SQL connection issue.

http://www.microsoft.com/en-us/download/details.aspx?id=29065

[Former Member]

Thanks Keith Lettiero,

I already installed the SQL Server 2012 SP 1. Which already contain the latest SQL Server Native Client. U went to the URL you provided and downloaded the SQL Server Native Client. At the point of installation, my server complained that a higher version of the SQL server Client is already installed.

So still no luck

[Former Member]

I guess I should have been clearer.

This popup is coming up because your report is not properly establishing a connection to the database you specified in your report. This could be caused by many basic reasons like a few listed below.

1. firewall blocking access to SQL
2. Improper report configuration
3. incorrect user and password
4. etc...

The most common reason after upgrading to new equipment that I have seen is the provider was not on the report server needed to connect to the SQL server causing this popup to come up. To test this simply enter the correct information in the window and if keeps coming up then it is most likely the provider. If it works when you enter the correct information then somehow your connection information is not proper in the report itself or the way your updating the report with the connection information.

Note: The native client pack needs to be on the report server(Runtime location).

What I just wrote may not apply to you because I noticed you have everything on one server. Your issue is probably because your mixing the runtimes.

From my experience you can only use one at a time and must uninstall anything before installing a new one.

[Former Member]

Thanks Keith

Yea I have everything on the same server. I have made a new Installed on A another server just to make thing clearer. I only  have CRforVS_13_0_8 installed as the Report runtimes. I have tried the previous ones before without luck.

When I entered the parameters it still dont go off. I dont know what else to do.

[former_member183750]

See my reply from Feb 25.

- Ludek

[former_member183750]

It would be interesting to see if you can run the report(s) in the CR 2013 designer on the Windows Server 2012 R2. You can download an eval of CR 2013 from here:

SME Free Trials | SME Software | SAP

It will not interfere with your current app install.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[DellSC]

You're on a very early version of the Crystal for VS runtime that was not compatible with Win2012 because it was released long before that OS came out.  Try upgrading to the latest SP.  You can find the downloads for that here:  http://scn.sap.com/docs/DOC-7824

-Dell

[Former Member]

Thanks Dell, I have installed the latest SP but still no luck. I now have this version CRforVS_13_0_8 installed. But still the same problem.

Thanks anyway.

[Sriram2009]

Hi

Could you share the screen shot with logon page?

Regards

Ram

[Former Member]

[Sriram2009]

Hi

Check this SAP Note

1337367 - 'The report you Requested requires further information' when opening migrated Crystal Repo...

Regards

[Former Member]

[Former Member]

Thanks Sriram

I m not able to logon to the URL you provided ( SAP note). I m being asked for SAP Service Marketplace username and password which I do not have.

1337367 - 'The report you Requested requires further information' when opening migrated Crystal Repo...

Regards