I am asking for the report execution at runtime, for ad hoc and canned reports (that are written with stored procedures).

Can the end user connect with SQL Authentication?

We...