My team is currently using SSRS 2005. We are experiencing what seems to be a common problem based on other threads I have seen. In our RDS file we have it set to Use a specific username and password. However when I commit this RDS file into source control and my team mates pull down the latest RDS, they do not have the username and password. From what I understand this is simply how SSRS 2005 works. If anyone knows a fix, that would be awesome. My question is, does anyone know if SSRS 2008 have this problem ? Does anyone else have any advice on working with RDLs in a team environment and sharing credentials? Thanks! flea

Hi flea, By default, the username/password saved in the shared data sources can be kept when it is deployed into report server. Can you reset the username/password in the datasource Properties->General->"Credentials stored securely in the report server" if they are cleaned up? thanks, Jerry

Hi Jerry, Thank you for your response. The problem I am having is, I am on a team of 7 other developers all of which are working on migrating our company over to Reporting Services. Each of us are building reports on our local machine. Our Development Environment is using a SQL account to execute the reports in order for us to use the subscription feature as well. We want to develop locally as closely to the Dev environment as possible. However, if I go and set the credentials in the datasource, when I go and commit this file to source control or have another developer copy it off my machine; the username and password are not going with that file; its just isolated locally to my machine (or the server I deploy the file to). I understand Microsoft is doing this for security reasons; but seems like it prevents teams of developers from working together sharing the same username and password. I guess my only work around at this point is to provide the username and password to each developer to use locally and not commit the RDS file to source control Thanks, Flea

Hi Jerry, Thank you for your response. The problem I am having is, I am on a team of 7 other developers all of which are working on migrating our company over to Reporting Services. Each of us are building reports on our local machine. Our Development Environment is using a SQL account to execute the reports in order for us to use the subscription feature as well. We want to develop locally as closely to the Dev environment as possible. However, if I go and set the credentials in the datasource, when I go and commit this file to source control or have another developer copy it off my machine; the username and password are not going with that file; its just isolated locally to my machine (or the server I deploy the file to). I understand Microsoft is doing this for security reasons; but seems like it prevents teams of developers from working together sharing the same username and password. I guess my only work around at this point is to provide the username and password to each developer to use locally and not commit the RDS file to source control Thanks, Flea

Hi Flea, Acutally, this is by design behavior in source control. As you understand, it is for security reasons. thanks, Jerry