i have a recent blog that is rendered using reported module , here is the sample query string i use

select top 5
    '<a href="'+PermaLink+'">'+ble.Title+'</a>'
  as [Recent Blog Entries ]
  from blog_entries ble
  inner join blog_blogs bb on bb.Blogid = ble.Blogid
  where ble.Published = 1
  and bb.Portalid = @portalID
and bb.Blogid = 1
    order by ble.AddedDate desc

the problem is that when a user is logged in and click the one of the reports entry it some how ask the user credentials again and after that it never asks agaon. for some resaon for the first if you click the entry in reports module it ask the user credentials. i don;t know what the problem is and is there any fix for this?