Hi All, Let me provide a brief information on the environment. SQL 2008 R2 Developer Edition + Business Intelligence tool SharePoint Server 2010 - Server farm installation but on single machine. SSRS 2008 When I am trying to deploy a report from Business Intelligence tool (as I created the report on BI only), I get Reporting Service Login prompt, which I want to get rid of. This is happening only if I am deploying the report from any client machine, but if I use server, it does not error out. I am using Windows NTLM authentication and do not want to use Kerberos Authentication. Steps I performed and instructions I followed - 1. I changed the target URL from http://servername/reports to http://servername/reportserver. This did not helped. 2. I changed the Execution Account to the farm account which has all rights on DB and server, still no use. 3. I read in the user guide of SSRS that if we are using Windows NTLM authentication, then we shall use 'Stored credentials'. Those were none other than SQL credential. I created a new credential and saved the entry in web.config to categorize the same as 'Stored Credential'. Still while deploying, I get the login prompt. 4. When I am creating a data source, I am providing the credentials there as per the user guide, still no good. Even if I change it to Windows Integrated mode then also it asks for credentials. 5. I checked in the rsreportserver.config file, the authentication mode is 'Negotiable'. I tried changing it to NTLM, still no good. I removed the same, got error. 6. DisableLoopBackCheck entry also exists. 7. The account I am using has rights on site, SQL and everywhere as per my knowledge. Still no good. Kindly suggest what can be done to remove that entry.Thanks, Sumit Gupta SharePoint Consultant MCP, MCTS, CCNA

Hi Sumit, If UAC is enabled (this is default on Windows vista and windows 7), Try opening the BIDS as an administrator and see if it works..- Chintak (My Blog)

Hi Chintak, I am using an account which is local administrator and Site collection Administrator for the Business Intelligence site. I forgot to mention that UAC is also disabled. I tried performing this from a Windows XP machine as well. Same issue. I tried this with 4 different machines with different credentials all having admin rights on machine and on site on which we are deploying the report. Still the issue is same.Thanks, Sumit Gupta SharePoint Consultant MCP, MCTS, CCNA

Hi Sumit, The TargetServerURL in BIDS project settings must be the Web Service URL(http://servername/reportserver). Reporting Services uses Windows integrated security by default, the interactive user must have a valid Windows local or domain user account or be a member of a Windows local or domain group account. In your case, does the user can access to the Report Server successfully? If not, I suggest you that refer to the following article: Setting Permissions in Reporting Services: http://technet.microsoft.com/en-us/library/aa337491.aspx Set Deployment Properties: http://technet.microsoft.com/en-us/library/ms155802(v=sql.105).aspx (Note: We must have Publish permissions on the target folder to publish reports to that folder) Regards, Bin LongBin Long TechNet Community Support

Hi Bin Long, Thanks for this information but it was not useful in my case. I already checked the service URL to be accessible by the account I am using on my machine. I am able to access the service URL. Secondly I do not agree on the point that the targetserverURL should be Web service. The reason is that, also I mentioned in my original post, I am able to deploy reports with my account or service account if I am deploying from the server where I mention targetserverurl as the actual site name like http://servername/sites/reportsite. So as I mentioned the issue is not occurring if I am deploying from the server but is occurring if I am deploying the report from my machine. The situation is quite obvious as I cannot grant developers to access server but will provide appropriate rights on database. So I am using one of the developer's account on server and it works whereas from their local machine it does not. Thanks, Sumit Gupta SharePoint Consultant MCP, MCTS, CCNA

Hi bin, I have the same problem. I am trying to deploy the SSRS report from SQL 2008 R2 BIDS to SharePOint 2010 Site Collection. It's keep asking me the login prompt even I am given farm level privileged user account credentials. I have the same environment as sumit mentioned. Thanks, Rajendra. Sharepoint Developer.

Hello, Firstly, please ensure that the user have sufficient permission deploy a report to SharePoint site(We must have Member or Owner permission on the SharePoint site to set the properties on the project). Then, please check the properties settings are correct. Please refer to the following article below: Publish a Report to a SharePoint Library: http://technet.microsoft.com/en-us/library/bb283155.aspx Finally, have you configured Kerberos authentication for SharePoint 2010? If so, this issue might be caused that Kerberos not being set correctly. For more information, please see: BIDS Deployment issue in SharePoint integrated mode: http://social.technet.microsoft.com/Forums/is/sqlreportingservices/thread/b198fbe2-85cc-43c1-a1d5-4c1614eb60e0 Enabling SSRS in SharePoint Integrated mode using Kerberos: http://blogs.msdn.com/b/sameersurve/archive/2008/09/12/enabling-ssrs-in-sharepoint-integrated-mode-using-kerberos.aspx Regards, Bin Long Bin Long TechNet Community Support

Hi Bin, Firstly the account I am using is Farm Administrator and has db_owner rights on respective database. I am not using Kerberos at all. I am using Windows NTLM. Also I read in user guide of Reporting Service that if you are using Windows NTLM, you must used 'Stored Credentials'. So for the same I created a SQL credential, provided appropriate rights and added the same while creating report. Also I have entry of this account in Web.config as well which makes it a 'Stored Credential'. Further I am able to deploy reports from server with the same account but I am not able to deploy reports from my machine with that account. Obviously my account has Windows Admin privileges on my machine but still there is an issue for that prompt.Thanks, Sumit Gupta SharePoint Consultant MCP, MCTS, CCNA

Hi Sumith, Did you get any solution ? Thanks Rajendra

Hi Rajendra, No not yet but to avoid further delay I am using upload methodology. I am uploading the RDS and RDL file and connecting the data source settings from the site for respective report to make it working as I cannot allow developers to access servers for every deployment.Thanks, Sumit Gupta SharePoint Consultant MCP, MCTS, CCNA

Hi, I suggest you that refer to the following article about Configuring Reporting Services for SharePoint 2010 Integration, especially the Service Account Configuration section. Please see: http://technet.microsoft.com/en-us/library/bb326356.aspx http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/795d7ad0-a2b3-4c2b-8eb9-0dc149b25274 Otherwise, you should consider looking at setting up Kerberos authentication. Please see: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23176 If this issue still persists, I would suggest opening a case with Microsoft Customer Support Services (CSS) (http://support.microsoft.com), so that a dedicated Support Professional can assist you in a more efficient manner. Regards, Bin LongBin Long TechNet Community Support

This happens if Anonymous is On for the web application. Turn it off from Central Admin site for this web application and try deploying again using BIDS. I got rid of this issue this way, hope it works for you. Regards, Manoj- Manoj "The opinions expressed here represent my own and not those of anybody else"