I am using SSRS 2008 R2 (sharepoint Integrated). The unattended execution account is configured and has permissions to access the remote database in question. In fact, I can (if I jump through certain hoops) get reports to run and retrieve data using the unattended execution account. But any time I try to use Report Builder to create a new report using a datasource configured to use "credentials are not required", I get the message "You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server." This message is clearly false...because the unattended account is correctly configured. The workaround I have found is: build and test the report using integrated authentication then edit the datasource to change it to "credentials are not required" But I figure I must be doing something wrong. Why does Report Builder keep telling me "You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server." ????

Hi Carlo.G, If we have configured the datasource to use Windows integrated Security,we are not able to use SQL Server Authentication in the connection. Please just use the following connection string: Data Source=servername;Initial Catalog=databasename If we want to use SQL Server authentication, please follow these steps: Set the connection string to be: Data Source=servername;Initial Catalog=databasename Check "Credentials stored securely in the report server", and type the UID and PWD in the username and password textbox. For more information, please see:Specifying Credential and Connection Information http://technet.microsoft.com/en-us/library/ms160330(SQL.90).aspx Lola Please remember to mark the replies as answers if they help.