SharePoint 2010 Foundation + SQL Server Reporting Services Integrated mode installation issues

When trying to configure the SQL Reporting Services Add-in for SharePoint 2010 from Central Admin you might see the following error:

(Error Text: Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. …)

Most common cause: Kerberos

A lot of the help out on the web point to Kerberos authentication.

Here’s what eventually got it to work for me, which assumes you are using ONLY basic Windows Authentication.

In your RSReportServer.config file (usually in Program Files\Microsoft SQL Server\MSRS10_…InstanceName\Reporting Services\ReportServer), find the <Authentication> section. You will likely find a setting for <RSWindowsNegotiate/>. Delete/comment out this entry.

Open  your reporting service installation folder

\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer

Open the rsreportserver.config file and search for <Authentication> And comment out the RSWindowsNegotiate tag. Like here:

                        <AuthenticationTypes>

                                    <!--<RSWindowsNegotiate/>-->

                                    <RSWindowsNTLM/>

                        </AuthenticationTypes>

You can able to add your RS web services URL in to Central Admin. Important: choose Trusted Account as your authentication mode.

After that, everything started working fine for me.