Logon Failed for crystal report

Hi,
encountered a big problem here.

I have create a rpt with a crystalreportviewer on a aspx page. It runs well on my local machine. But when pushing it to my live server, (my database is on another machine), the following error occurred

CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.

Can enlighten??

this is my codes

crpt = New CrystalReport4()

For Each myTable In crpt.Database.Tables

myLogin = myTable.LogOnInfo
myLogin.ConnectionInfo.ServerName = "server1"
myLogin.ConnectionInfo.DatabaseName = "abc"
myLogin.ConnectionInfo.UserID = "sa"
myLogin.ConnectionInfo.Password = "sa"
myTable.ApplyLogOnInfo(myLogin)

Next

CrystalReportViewer5.ReportSource = crpt

THANKS FOR ANY HELP RENDERED