I have the following questions to ask about sql server 2008 r2 standard edition: 1. At work, a fellow co-worker says the SSRS reports lose the data source connection strings and the user name and pawwrods to some when the SSRS 2008 r2 report is setup. Is there a way to prevent this from occuring? 2. Is there a way to keep users from seeing all the reports that can be executed from running? Basically some of the people in the IT department that have the same access level, said they could not see some reports on the Microsft version of the sql server web service? If this is true, how can you prevent this from occuring?

Hi, For 1) I'm assuming you are talking about the Shared Data Sources in a Report Server project in Visual Studio, as opposed to a Data Source created directly on Reporting Services. The latter, the data is stored all in the ReportServer database that was specified when setting up SSRS. Now, as for the .rds file used in Visual Studio, if you open the file up in a text editor, notice that the username and password is not stored in the file. It is actually stored in the .rptproj.user file. So, check that someone didn't remove the .user file from source control (.user files shouldn't be in source control, but in your case...). This is scenario is testable by entering your credentials, saving all files, and exiting Visual Studio. Find and delete the .rptproj.user file, and open your Report Server project up again and see the credentials gone! A work around is add the "User ID=user;Password=pass" as part of the Connection String. When the .rds is opened up, the Connection String won't show this portion, but the Credentials tab should have the right values. Also Check SP3 is intsalled. 2) For 2 check go to report manager and check the Secuirity , maybe something to do with it. Check the Link below http://www.mssqltips.com/tip.asp?tip=1356 Regards, PS