Hi,

I am using mssql application role to protect my data, but there is a problem with the reporting (crystal report 7), the report's connection hasn't granted to the application role, so it have no any permission to the data.

Anyone know how to run sp_setapprole with crystal report ?