How do you implement Single Sign On (SSO) using Crystal Reports XI in a Visual Studio .NET web application?
This article applies to Crystal Reports XI, Crystal Reports XI Release 2, and Crystal Reports for Visual Studio .NET 2005. The solution will not work in Crystal Reports 10 or lower.
There are two steps to implementing Single Sign On (SSO) using Crystal Reports XI in a Visual Studio .NET web application. The first step has several sub-steps that are outlined in the referenced article.
- The required system configuration is explained in a Microsoft white paper. Search for "Troubleshooting_Kerberos_Delegation" at www.microsoft.com.
- Within your Visual Studio .NET code, you will need to add code between the section in which report objects are set and the section in which the log on code is set ('if .IntergatedSecurity = False'). The code to add is:
Report.DataSourceConnections(0).IntegratedSecurity = True
SSO DOT NET WEB APP KERBEROS DELEGATION HOP HOPPING INTEGRATEDSECURITY Crystal Reports for Visual Studio Troubleshooting Kerberos Delegation Crystal Reports for Visual Studio .NET 2005 , c2018929 , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , How To