Error in crystal reports

Hi .
I was using access as my backend.
Now i am switching to sql server 2005.
Now my crystal report is linked with datasource.
I have just changed my dsn for sql server.

But while loading crystal report,its giving me error as

Logon Failed.
"Details 28000:[Microsoft][ODBC Sql server driver][SQL server]Login failed for user 'sa'.

can anybody tell me solution ?

Say Crystal Reports version and post the code, if you're using an app to load the rpt

For x = 1 To Report.Database.Tables.Count
Report.Database.Tables(x).ConnectionProperties("user id") = "userid"
Report.Database.Tables(x).ConnectionProperties("password") = "password"
Next x

this is for VB6 using crystal report