Using "Integrated Security" w/Crystal Reports 11?

[blakemckenna]

My shop has had problems using "Integrated Security" with Crystal Reports 11 ever since we installed CR 11. Our users logon to our network using an "Active Directory" logon. We use SQL Server 2005 as our backend DB and VB.Net 2005 as our development tool. Everything works just fine from a Development machine but when installed on a Terminal Server....it craps out. For some reason, everytime a user goes to print a CR from within a VB.Net app, we get the "Database Logon" screen. See below.

Here is a code snippet of a typical call to a CR report.

    Public Sub PrintStatusCodesListing()
        Try
            dErr.clsModule = "modReports"

            Dim crDoc As New rptStatusCodes

            With crConnectionInfo
                .ServerName = "HERCULES"
                .DatabaseName = "Drip"
                '.UserID = "testUser"
                '.Password = "password"                
                .IntegratedSecurity = True
            End With

            strFormula = "{tblStatusCodes.statusID} > 0"

            crDoc.RecordSelectionFormula = strFormula
            frmReports.crViewer.ReportSource = crDoc
            frmReports.crViewer.DisplayGroupTree = False
            frmReports.ShowDialog()

        Catch ex As Exception
            dErr.clsProcedure = "PrintStatusCodesListing()"
            dErr.clsMsg = ex.Message
            dErr.OnlineErrorHandler(dErr.clsModule, dErr.clsProgram, dErr.clsProcedure, dErr.clsMsg)
        End Try
    End Sub

The RED highlighted code is in place now in production and we are still having this issue. All our online applications use the "Click-Once" technology. We have no DBA, so we are kinda "Flyin' by the seat of your pants".

Thanks for the help