Print ID:0 problem and keeping SA password

[cpitc]

I have created a report using Crystal Reports 2008. I am linking to SQL server 2005 database. I ahve 2 small problems.

1. When I refresh the report it always asks for the SA password, is there a way I can get the report to remember the password.

2. I have attached this report into our ERP system, however when I run the report it says "Crystal Report Problem, Print ID:0, Cannot Open Report File". I ahve a feeling it is because of the problem in number 1.

My concnetion is Microsoft OLE DB (ADO) for SQl.

Any ideas anyone

Thanks