I am running SharePoint 2010 Enterprise with 2 servers in the farm (SharePoint and db server). They are both running windows server 2008 R2 and the SQL Server is also R2. I have installed the reporting services R2 add-on on to the SharePoint server. I have configured the report server on the SQL server and also installed the sharepoint on it and added to the farm. I am pretty sure I have configured reporting services on the central admin properly. I can browse to the reportserver fine too. The problem I have is that when I try to deploy my report developed in visual studio I get a pop up for credentials and no matter what I try for the user name and password, the pop up keeps coming back up and nothing happens.
The same question has been asked on MSDN, but no solution yet.
I understant it should be some permission issues , but I can use the same account to manual upload report to document library and it all work correctly. I am running VS2008 with admin right , the user is SPFarm admin , site collection admin to the current site , Sysadmin on the sql server and admin on the reporting server.What other permisions am I missing?