I have a report server configured to run on specific user account(user a) . When (user b) create a report using BIDS and create a connection to data source using windows authentication i am able to run the report in bids. when the same report is deployed to server and try accessing , it throws out an error stating failed connection to datasource . the user has content manager permissions in the report manager. s/d

Do you have Report Server and DB/Analysis Service on different machine. if this the case and you are running report manger on your machine than it will cause double hop and will get you error in connection. if this is the case please implement kerberose. Refer This for the same- http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docxGaurav Gupta http://sqlservermsbiblog.blogspot.com/