row level & view level security not working through live connection to SQL server

I am having a report which fetches the data from a view from SQL server through a live connection.  This view has underlying security based on Microsoft Sales security. View definition looks like t...