Repeated Reporting Services Login issue when deploying through BIDS to a remote server

Question

We are having a problem deploying a reporting services report to a sql reporting services computer that is configured in SharePoint Integrated mode. I can successfully deploy to the SharePoint document libraries set up for reports and data connections if I do it locally from the box that SharePoint and Reporting Services are deployed on. If I try and do the same thing with the exact same deployment properties from a remote box, I constantly get a Reporting Services Login dialog popping up and no combination of domain\username and password will work. I've even tried the machines local admin account and still nothing.

Any ideas where to start looking?

Answer 1

This occurs when BIDS cannot connect to the Report Server instance. Check the URLs, and see if any firewall is blocking the connectivity to the remote RS instance.

Answer 2

I finally found the solution to this issue. Basically the build of sql server 2008 reporting services I installed added an RSWindowsNegotiate setting into rsreportserver.config file and I was running the reporting service under an account other than Network Service. I removed the RSWindowsNegotiate setting and just left the RSWindowsNTLM setting and everything started working properly for us.

More info can be found here, Solving the Reporting Services Login Issue