Remote Desktop: Losing credentials ...

Hi,

I've experienced a problem (bug?) when deploying reports to the report server. My users kept complaining about losing authentication to reports when I deploy a new report. I found the problem but don't understand why this is happening. My collegue developped the earliest reports and loggs in with a different user on Remote Desktop to develop the reports. When the report is deployed, the datasources are deployed also.

Now when I log in on Remote Desktop with another user then my collegue and open the same report project, and check out the datasources, the credentials are gone ... ?!? So when I deploy a report the datasource with the empty credentials are deployed too, wich causes all the authentication problems.

My Question: How comes I can't see the user credentials my collegue filled in? When I open the report project the credentials are gone. I log out, my collegue loggs in, and the credentials are back

I suppose this has something to do with Remote Desktop and the users connecting to it?

Thanks in advance!

Nobody?|||I believe Visual Studio stores the data source credentials in a user specific data file (<projectname>.rptproj.user). This is by design, so that one developer cannot "borrow" another developer's credentials. However, if you are using shared data sources, there is a simple workaround. Make sure that the OverwriteDataSources property in the Project Properties is set to FALSE. This way, shared data sources are only deployed if they don't already exist. On the first deployment, you may have the update the data source on the server, but subsequent report deployments will not overwrite it.|||

Hi jwelch,

Thanks for the explanation. Your solution will probably prevent anything like this happening ever again.

Respect! ;-)

|||Can you mark the response as an answer? It helps others who encounter the same problems find solutions more easily.