Logon Failed using Push Method in CR.NET

[TheStriker]

I have been trying for weeks to get rid of this error but it just won't seem to go away. I have googled high and low and found nothing. I know it is probably a simple solution to this very common error but it eludes me.

The skinny:

I am just a guy trying to impress his boss by embedding Crystal Reports in my ASP.Net application and this error has been haunting me for the better half of a month and I am at my wits end. I've tried every walkthrough, code sample, push-pull method, recommendation I could find but still no joy. I have found success when using one table with no params but for this report I must be able to use an SP with four tables.

The scenario:

I am a web developer and DBA for my application and I have all the appropriate permissions to perform most of the admin functions on the DB when I need to. I use my machine to test locally then copy my project to the production web server for use on our intranet. Again, I have had success in the past with CR.NET on my local machine with single tables as my datasource but this time I need to use a stored procedure with four tables.

The code:
Here is my page load event that I am currently using.

The Push Method using a dataset with a stored procedure.

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
        Dim rpt As New CrystalReport1
        Dim crDatabase As CrystalDecisions.CrystalReports.Engine.Database
        Dim crTables As CrystalDecisions.CrystalReports.Engine.Tables
        Dim crTable As CrystalDecisions.CrystalReports.Engine.Table

        daSiteGroup.Fill(DsSiteGroup1, "Site_Group_Rpt")
        crDatabase = rpt.Database
        crTables = crDatabase.Tables
        For Each crTable In crTables
            crTable.SetDataSource(DsSiteGroup1)
        Next
        CrystalReportViewer1.ReportSource = rpt

The connection string:

workstation id=<my workstation ID>;packet size=4096;user id=<my user ID>;data source="<my Server/datasource>";persist security info=True;initial catalog=<my database>;password=<my password>

Please note that I used the wizard to create this connection string.

Please feel free to point out anything that could be producing this elusive 'Logon Failed' error.

Thanks in advance for your help.