Noel,

I use datasets for reporting, I don't access sql server directly...but I'm guessing you need to set the login credentials for each data table defined in the report.

Something like this...

Dim myTable As CrystalDecisions.CrystalReports.Engine.Table
Dim myLogonInfo As CrystalDecisions.Shared.TableLogonInfo
For Each myTable in oRpt.Database.Tables
   myLogoInfo = myTable.LogonInfo
   myLogonInfo.ConnectionInfo.UserId =    "user id"
   myLogonInfo.ConnectionInfo.Password = "password"
   myTable.ApplyLogonInfo(myLogonInfo)
Next myTable

There may be more to it than that, but if you're reporting directly off data in SQL server, I think you need to log into the tables.

Hope that helps...
Kevin