Hi im running a report on sql server 2008 which has data source from SQL 2005, both SQL 2008 and SQL 2005 are linked together in management studio. my concern is i want use windows integrated security when i run the report in browser which is not letting me to do that, when i run on test environment it is running well, im entering my user name and password inorder to run the report in the browser when i use windows integrated security it is giving me error as could connect to datasource, does any body has ideas inorder to over come this issue, i want to use windows integrated security rather than entering my username and password