Cannot able to open database requested by the login?

Hi,

I am using SQL View as source. I have imported the view in DS and used as source in my mapping.

I am able to view the data in DS and the view has been given select authorization rights.

But when i tried to trigger the job, it is displaying the error

Cannot open database requested by the login?

Do you faced the same kind of issue?

kindly let me know what should be done to extract data from the SQL view?