When SSRS in forms authentication mode, how do reports connect to remote database servers to get data using the report requesting user's login/password?

Hi James, By default, SQL Server Reporting Services(SSRS) will use the credential we configure the data source to connect to the remote database servers. This is Forms Authentication regardless. If the credential we configure for the data source is "Stored Credential", the SSRS will use this stored credential. If the credential is Windows Integrated, then the retrieving will fail, due to there is no valid Windows Credential. If the credetnial is "Ask for user input", then while executing the report, a login is required. We need to type the username and password in the report parameter panel area. For more information, please see: http://msdn.microsoft.com/en-us/library/ms160330.aspx If there is anything unclear, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT