I am using Visual Studio 2010 with the Crystal Reports plug in. I have created a report in the designer which takes one parameter and runs a stored procedure on a SQL2008 express database based on that parameter. In the designer preview I am prompted for the parameter value and the report displays the correct data. When run in live mode and I use the same data value as in the preview it works. If I select another parameter value it fails and prompts me to log in to the database nor it will log in when the details are entered. This is happening on a number of reports (which use run time parameters for stored procedures) so I feel I am missing something simple but cannot think what it is. Has anyone got an idea as to what I am doing wrong?