Wednesday, October 23, 2013

Display Crystal Report with ASP.NET 4.0 from IIS7 Production Server

To display crystal report (with ASP.NET 4.0) from the IIS7 production server, following steps are requried... (it worked for me and hopefully will work for you too...)

Step 1:
Installing Microsoft Data Access Components (MDAC) 2.8 Software Development Kit. 
2.      Service Pack 1 of MDAC from the link: http://www.microsoft.com/en-us/download/details.aspx?id=5793

Step 2:
Adding ASP.NET 4.0 as Application Pool on IIS 7
1.      Open your command prompt (Windows + R) and type cmd and press ENTER
You may need to start this as an administrator if you have UAC enabled.
To do so, locate the exe (usually you can start typing with Start Menu open), right click and select "Run as Administrator"

 2.     Type cd C:\Windows\Microsoft.NET\Framework\v4.0.30319\ and press ENTER 
 3.     Type aspnet_regiis.exe -ir  and press ENTER again.
·         If this is a fresh version of IIS (no other sites running on it) or you're not worried about the hosted sites breaking with a framework change you can use -i instead of -ir. This will change their AppPools for you and steps 5-on shouldn't be necessary.
·         at this point you will see it begin working on installing .NET's framework in to IIS for you
 4.     Close the DOS prompt, re-open your start menu and right click Computer and select Manage
 5.     Expand the left-hand side (Services and Applications) and select Internet Information Services
·         You'll now have a new applet within the content window exclusively for IIS.
 6.     Expand out your computer and locate the Application Pools node, and select it. (You should now see ASP.NET v4.0 listed)
 7.     Expand out your Sites node and locate the site you want to modify (select it)
 8.     To the right you'll notice Basic Settings... just below the Edit Site text. Click this, and a new window should appear
 9.     Select the .NET 4 AppPool using the Select...  button and click ok.
10. Restart the site, and you should be good-to-go.
(You can repeat steps 7-on for every site you want to apply .NET 4 on as well).

Step 3:
Copying "aspnet_client" folder into your web application directory
Take this content: C:\inetpub\wwwroot\aspnet_client
And copy to here: C:\inetpub\wwwroot\WebAppFolderName\aspnet_client
(I installed IIS root directory in C: drive)

Step 4:
Modify web.config file
Add following section into web.config file...
<startup useLegacyV2RuntimeActivationPolicy="true">
      <supportedRuntime version="v4.0"/>
      <requiredRuntime version="v4.0.20506"/>
</startup>

Now, you are done setup Crystal Report withASP.NET 4.0 into the production Server...
Enjoy!!!