.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Use Report Builder 3.0 with SharePoint site using a port number

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
We are currently working with SSRS R2 and SharePoint 2010.  SharePoint 2010 has been deployed a multitenant solution.  SharePoint and SSRS are on separate servers.  We have successfully integrated the two products but are experiencing some anomolies.  The SharePoint site we are deploying to uses a port number (e.g. http://mysharepointsvr:2222).  When you launch Report Builder from this site, it does not open connected to a Report Server.  When you try to connect to a Report Server the obvious choice is to put in http://mysharepointsvr:2222 for the Report Server service.  However, this does not work.  We are getting the following error: Connection Failed.  Unable to connect to the server that is specified in the URL, 'http://mysharepointsvr:2222'.  Make sure the server is running, the URL is correct, and you have permission to use the server. However, if we use the SharePoint address without the port number it will connect.  This does not work as the SharePoint port determines which site we are directed to for resources.  In our case, we need to be able to browse the folders on port 2222 not port 80 (default).  As far as the error above is concerned, we are able to browse to the report server (http://sql101/reportserver) and see all of the SharePoint sites.  In all cases, identical credentials are being u

View Complete Post

More Related Resource Links

Sharepoint site by something other than computer name: port number


I am quite new to sharepoint and like what I see so far, but I am having major problems getting a site by a domain other than http://computername:portnumberto work for me.

For example.  Lets say my computer name is sharepoint server and I want to create a web application and collection by the name of mysite.mysite.com.  The mysite.mysite.com site creates fine and shows up in IIS fine.  I create a host file entry for mysite.mysite.com and point it to my server.  When I try and browse to the site http://mysite.mysite.com I get challenged for authentication.  If I ping the site it is pinging the correct server. I put in the correct username and password, but I am unable to login.  If I create a site that is just the computer name and a random port number I am able to log in.

I figure I am missing something simple, but I have tried to research this for several hours and have gotten no where. Can anyone point me in the right direction?

I would also like to add that I would like to make serveral sites that are running over port 80 by using host headers...if that changes anything.

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

Report Builder in sharepoint is not working.



We are using below Topology in production
Topology is 3 servers:
Sever1: Sharepoint Form (wss3.0 no MOSS)
Sever2: Sql server 2008
Server3: Reporting Services 2008
Operating system on 3 servers: Windows server 2008.
Authentication mode: Form based authentication.

 SSRS reports are working success fully in SharePoint using above topology, The issue is through SharePoint library when i am trying to access report builder reports the client is installing, after enter the credentials it is not connecting to server and am getting the following error "Unable to connecting server at 'http://servername/Reports/Forms/AllItems.aspx'  please use different url

The above issue on production only.

But in local development box there is no problem (in my development box SharePoint t, database (sql) and reporting service sits on my box only)

Thanks for your he

IIS - sharepoint/default website port number confusion



I have MOSS 2007 installed with IIS V7.

My default web site port is 80. When I created a new web application for my main sharepoint portal I also set it to 80. So obviously now the default web site port shows as stopped in IIS and it won't start.

What are the best practices. Should I change the port number for my portal to something else? I mean is it even a good idea to have sharepoint on port 80? If so, how do I go about changing the port number for my portal site?

any help appreciated.

Report Builder 3 report preview error in SharePoint integrated mode

Hello folks! I've faced some strange error with RB 3.  My environment is: Win 2008R2+SQL2008R2 CU3+Sharepoint Foundation services 2010 SharePoint services integrated with Reporting Services.  When I try to run RB3 from SharePoint library and built some report I get strange error at the previw screen : Failed to preview report. The item 'http://myserver/cd6409dc-1089-4e8a..' cannot be found. Details: System.Web.Services.Protocols.SoapException: The item 'http://myserver/cd6409dc-1089-4e8a-a2a4-f231c97039aa' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item 'http://myserver/cd6409dc-1089-4e8a-a2a4-f231c97039aa' cannot be found.    at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)    at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)  The most intresting thing, that my test environment with Win 2008R2 CTP+SQL2008R@ Nov CTP is working properly without any error. Could you please advise how to resole this problem? Thanks in advance, Andre.  

Sharepoint 2010 Standard Edition Custom List Reporting Using Report Builder 3.0


hi, i'm making this report from a sharepoint list. i want to add some of the fields as the parameters for the report. (e.g : Category, Department)

i tried to run the report, the parameters were shown as expected

but the problem is when i create a query in the dataset.

i'm using caml query builder for the query expression. it goes like this :

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ListName>IT Helpdesk</ListName>
    <FieldRef Name="Employee_x0020_Number" />
    <FieldRef Name="Title" />
    <FieldRef Name="Department" />
    <FieldRef Name="Category" />
    <FieldRef Name="Time_x0020_Spent" />
    <FieldRef Name="INT_x0020_Time_x0020_Spent" />
    <FieldRef Name="Severity_x0020_Level" />
    <FieldRef Name="Ticket_x0020_Source" />

Maximum number of Document libraries or Lists that can be created in a Site collection of sharepoint


Hello Guys, 

what is the maximum limit for creating document libraries in sharepoint 2010, is there any limit? if so can you give me the number and details where do i find it.

Thanks in advance.

Report Builder 3.0 unable to access SharePoint Foundation 2010 Report Server


I am having a terrrible time getting this to work. I have configured the SharePoint site and the SQL Servers involved to use Kerberos. That has been confirmed working.

I then configured the SharePoint site's Reporting Services integration (trusted account), enabled anonymous access and enabled report builder. I can launch report builder without any issues at all. The problem comes when I try to save my report. When Report Builder is started Items->New-ReportBuilder Report it opens and display in the lower left hand corner "No current report server." When I close the Wizard dialog and click connect I enter http://server.fqdn.net and I receive the following error:

Connection failed:

Unable to connect to the server that is specified in the URL, 'http://servername.fqdn.net/'.

Make sure that the server is running, the URL is correct, and you have permission to use the server.

I have also tried http://servername.fqdn.net/reportsserver/. When I try that I receive a login prompt. When I enter my credentials it tries for a few seconds and then sends another login prompt. I installed the report server using default settings. The reporting services db is on the same server as sharepoint. The configuration and other databases are on a remote S

Sharepoint 2010 Audit Logs with Report Builder 3.0



I'm trying to create a report using Report builder of a sharepoint 2010 list's custom audit log, is there a way to create a report using report builder 3.0 without directly using sharepoint's Database tables?


How to find number of documents uploaded to each sharepoint site?


How can I determine how many documents are uploaded to each sharepoint site?

Connectiong String For SharePoint List Using with Report Builder 3.0 ?


Hai Friends,

     I am Ali, I need to retrive the all lists in to Report Builder and need to prepare Report and need to deploy in Sharepoint Library.

1. I Configured Reporting Services in Sharepoint Integrated mode and Credentials are in Windows Integrated Mode not in Trusted acount. 

2. In Report Builder 3.0 Connection Type "Microsoft Sharepoint List"

3. Connection String 'http://<server name>/sites/<site name>' like this, when i test the connectinons getting this error (The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified.)

Please anybody help me to proceed next steps.



MD.Liakath ali

Changing the graphics on the home page of a SharePoint site

When you create a site in Microsoft Windows SharePoint Services by using the default Team Site template, the home page includes two default graphics. A Windows SharePoint Services graphic appears in the body of the page, and a picture of a house in a circle appears near the site title. You can change these graphics to customize your site. Changing the smaller graphic requires a Windows SharePoint Services compatible Web page editor

Take a tour of your SharePoint site

What is a SharePoint site for?
A SharePoint site is a Web site that provides a central storage and collaboration space for documents, information, and ideas. A SharePoint site is a tool for collaboration, just like a telephone is a tool for communication, or a meeting is a tool for decision making. A SharePoint site helps groups of people (whether work teams or social groups) share information and work together. For example, a SharePoint site can help you:

Coordinate projects, calendars, and schedules.
Discuss ideas and review documents or proposals.
Share information and keep in touch with other people.

Six easy ways to customize your site using Web Parts in SharePoint

Becoming familiar with Web Part customization techniques gives you a range of page-customization choices. For example, you can customize your site's home page so that it displays the specific information that your team needs. You can rearrange the list items on the home page, add lists, and even change the images on the home page. As you become more familiar with Web Part Page customization techniques, you can build interactive Web Part Pages that makes the data in lists more dynamic and useful, and you can add new Web Parts that provide access to external data and Web services.

SharePoint Application and Site Pages - Part 1 of 2

In this first part of the two part series, Steven covers the differences between Site and Application pages in SharePoint 2007, why each may be used in various circumstances, and prepares for the construction of a menu located application page. After a brief introduction he examines the concept of Site Pages and Application Pages separately in detail with supported screenshots.

SharePoint Application and Site Pages - Part 2 of 2

As the second article in a two part series, Steven examines the attributes and details of a SharePoint 2007 application page, including the construction and feature deployment of the same page based project. Since this is a WSS level objective, as opposed to MOSS, you will not need MOSS to work with the code included in this project. Windows Server 2003, WSS, and Visual Studio 2005 are all that is needed, with no additional add-ons. He provides a detailed analysis of each step involved in the creation and deployment of the project.

Office Space: Automated SharePoint Site Branding


Here's a custom branding solution for SharePoint sites that integrates Master Pages and CSS files at the level of the site collection.

Ted Pattison

MSDN Magazine July 2008

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend