Search This Blog

Deploying SSRS Reports in SharePoint 2010 asking for UserName and Password Issue fixed

Deploying SSRS Reports in SharePoint 2010 asking for UserName and Password Issue fixed

While Deploying SSRS reports in Sharepoint it is asking for UserName and Password the Reason of this Issue is your not providing Correct Url  of TargetServerURL and for othersfolder  the Sharepoint document Librarary

For Eg Suppose you have your SharePoint Site is:

Http://Testing/TestingDomain/AllDocuments/Reports

Reports is that folder where you are Deploying Your Reports.

Then go to Your Project Properties 
Right click your Project -Properties
Below Screen will appear.

Now in Target Server URLType your sharepoint Main Site or Subsite.Not the Folder where you are deploying the Reports.


Target Server URL:Http://Testing/TestingDomain

for Other Folder Like TargetReportFolder,TargetDatasourceFolder and all other add the Document library path where you are deploying your Datasource and Reports
Like in our Example we are deploying inside Report Folder.
so add below url in other boxes 

Http://Testing/TestingDomain/AllDocuments/Reports

Deploy the Report it will not ask for UserName and Password.

Note:If you select your DocumentLibrary folder of Sharepoint and copy into browser it will include other folders with page extension like below  Http://Testing/TestingDomain/AllDocuments/Reports/form.aspx 
 tmake sure the TargetServer URl and Other Target folder doesn't contain any asp page extension the path should contain upto your document libarary name and do not add backslash after the Document libarary name.
If you are still getting error then it must be some error with Report Server URL alter it the error is most related with URL provided by you.

No comments:

Post a Comment