Crystal report error

crystal report created in asp.net2010 with stored procedure working fine on local but not on live.

Failed to open the connection. Failed to open the connection. Details: [Database Vendor Code: 53 ].

if i create report using table it works on local as well as on live but if i use stored procedure it showes error.

Its urgent