Application Role problems with Crystal Report
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 ?
Re: Application Role problems with Crystal Report
Quote:
Originally Posted by
henyung
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 ?
I am also facing same issue... did you find any way around or diff. solution?
Re: Application Role problems with Crystal Report
don't revive old threads, please