Unable To Deploy Report In Reporting Services Running In Wss 3.0 Integrated Mode

I configure an evaluation stand alone server installing SQL Server 2005 Service Pack 2 and the SQL Server 2005 reports Services Add-in for SharePoint Technologies (http://msdn2.microsoft.com/en-us/library/bb677368.aspx).
 
When I deply some reports from visual studio running on the same machine to reporting services runnig in sharepoint integrated mode, I get the following error:
 
TITLE: Microsoft Report Designer
------------------------------
A connection could not be made to the report server http://win2k3r2ee/Report.
------------------------------
ADDITIONAL INFORMATION:
The request failed with HTTP status 502: Bad Gateway. (System.Web.Services)
------------------------------
BUTTONS:
OK
------------------------------
===================================
A connection could not be made to the report server http://win2k3r2ee/Report. (Microsoft Report Designer)
===================================
The request failed with HTTP status 502: Bad Gateway. (System.Web.Services)
------------------------------
Program Location:
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Microsoft.SqlServer.ReportingServices2006.ReportServiceAuthentication.GetAuthenticationMode()
   at Microsoft.ReportDesigner.Project.ReportServiceClient2006.CheckAuthenticated()
   at Microsoft.ReportDesigner.Project.ReportClientManager.DetectEndpointAndAuthenticate(String url, ICredentials credentials, String& authCookieName, Cookie& authCookie, EndpointType& endpointType)
   at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
   at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
 
 
 

View Replies


ADVERTISEMENT

How Can I Show A Report From SQL Server Reporting Services Not In Integrated Mode

 

I've build some reports for SQL Server 2005 Reporting Services, this server is not in SharePoint Integrated Mode. Then I need to show in a web part the reports from this SSRS server.
 
I'm trying to create a new web part that instantiates the ReportViewer object and is added to the SharePoint page, but I'm receiving an error message (Unknown error as SharePoint shows).
 
My code is simple, I just have a property for the report URL and the object.
 
Here it is:
 
ReportViewer rptViewer = new ReportViewer();
rptViewer.ServerReport.ReportServerUrl = new Uri(reportServer);
rptViewer.ServerReport.ReportPath = reportPath;
rptViewer.ServerReport.Refresh();
this.Controls.Add(rptViewer);
 
Do you suggest anything? How can I show my reports from a standalone SSRS server?
 
 
Thanks.

View Replies View Related

Drillthrough Problems With Reporting Services In Integrated Mode

We have started to use reporting services in integrated mode with windows sharepoint. Since this installation the drillthrough reports have stopped working. We get the following error when a hyperlink is cllicked:-

 
The item 'http://vtrends/reports/IslandRegionCountryState' cannot be found. (rsItemNotFound)

 


In the textbox properties we have set the 'Jump to Report' hyperlink option to use a condition. Based on the link clicked, one of two reports will be displayed. If i remove this condition and manually select the report to run then there are no problems. This however is not the functionality that is needed.
Any help will be appreciated.





 

 

View Replies View Related

Problems Configuring SQL Reporting Services In SharePoint Integrated Mode

I am trying to follow the instructions on:
http://technet.microsoft.com/en-us/library/bb677365.aspx
they contain many "if"s and links to other sites and I got totally confused and stuck.
The idea is - I need to have one machine with SQL for reporting services and SharePoint databases and the reporting services and the other machine for a complete SharePoint installation (the main server of the farm)
 
Now I have done the following:
two servers (lets call them SQL and MOSS)

The domain contains the following users:
sqlservices: for running all the SQL services and reporting services
moss: for administering MOSS databases
moss-services: for running all the MOSS services
Machine SQL -  installed Windows Server 2003 Standard Edition SP1, joined to the domain as SQL
The following is done from a local Administrator account:
IIS 6 with ASP.NET installed
SQL Server 2005 with SP2, Reporting services installed but not configured
all the services are running as domainsqlservices
.NET 3.0 installed
http://support.microsoft.com/kb/918642 fix installed
done WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regiis €“i
MOSS as Web Front installed, not configured
 
 
Machine MOSS - installed Windows Server 2003 Standard Edition SP1, joined to the domain as MOSS
The following is done from a local Administrator account:
IIS 6 with ASP.NET installed
.NET 3.0 installed
http://support.microsoft.com/kb/918642 fix installed
done WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regiis €“i
Computers->My computer->DCOM Config->IIS WAMREG admin Service->PropertiesSecurity->Customize->Edit, added domainmoss-services and domainMOSS users with rights Local launch, Local activate
MOSS Complete installed, configured for: New server farm
Database server: SQL
Username: domainMOSS
Port: Default
Auth: NTLM
SharePointRS.msi installed to enable RS in SharePoint Admin page
 Then temporarily gave to the user domainMOSS sysadmin rights in the SQL server on the SQL machine to avoid errors with creating databases while configuring SharePoint from the Admin Portal.
 From the Admin Portal configured
Office SharePoint Server Search with domainmoss-services account
Shared Services Administration €“ New SSP created with 2 separate web apps for SSP and MySites, both app pools run as domainmoss-services and SSP itself runs as domainmoss-services
Windows SharePoint Services Search configured, Service Account - domainmoss-services, Content Access Account -  domainmoss-services
 
Everything went OK.
 
Now came back to the machine SQL:
run Reporting Services Configuration and:
Report Server Virtual Directory €“ created new, called it ReportServer. When hit Apply, the applicatin suddenly quit, but I checked €“ the Virtual Directory was registered on the IIS and working.
Checked if Windows service identity is domainsqlservices, OK.
Web service identity: Application Pool: New
Name: ReportServer
Windows Account: domainsqlservices
Apply, everything went fine.
 
Database setup: choose server SQL, Connect
Database name: New name: ReportServer,
checked Create the report server database in SharePoint Integrated Mode
OK
Credeantials Type -  Service credentials (I guess it means previously set domainsqlservices will be used)
Apply,OK, everything went fine.
 
Launch SharePoint Products and Technologies Configuration Wizard, Connect to an existing farm, Database server: SQL, Retrieve datbase names: selected SharePoint_Config, Username: domainMOSS, Next, everything fine here.
 
Now as far as I understand I need to give reporting services an access to SharePoint databases? Went to the machine MOSS, launched SharePoint 3.0 Central Administration:
 
Application Management-> Reporting Services->  Manage integration settings, URL: http://SQL/reportserver, Windows Authentification, OK
then back, Grant database access-> Server Name: SQL, OK, now it is asking for credentials. And now the problem: no matter what I enter (domainsqlservices, domainMOSS) I get a message: €žA connection to the computer cannot be established€?. Why, why, why?
I can ping the server, SharePoint services are running fine and they are using the SQL server on the SQL machine and there are no errors in the event viewer (they should be if there were any problems to connect the SQL databases).
 If I enter wrong credentials, I receive "Unable to log on with the given username and password.", so I guess there IS a connection to the computer (or how else could SharePoint determne that login is wrong?).



Also, if I open http://SQL/reportserver, I get €žThe report server has encountered a configuration error€? and the log in C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles says €žSharePoint content service is null. Report Server may not have joined the SharePoint farm, or Report Server service account may not have been granted access to farm.€? I guess it is OK while I have not granted access to the SharePoint databases?
Please, show me, what did I do so wrong that €žA connection to the computer cannot be established€?? How can I grant the access and finalize configuring Reporting Services?
Thanks.

View Replies View Related

HTTP: 401 Unauthorized When Trying To Use Reporting Services And MOSS2007 In Integrated Mode

Sorry for the long post, but I'm trying to include as much info as possible.

I'm having trouble getting SQL Server 2005 Reporting Services and MOSS 2007 working together in integrated mode. Everything seems to be ok, but we get a 'HTTP 401 Unauthorized' error when using the 'Set server defaults' link from MOSS 2007 Central Administration. None of the other links give this error, but I'm not sure whether MOSS just eats the error message...

Here's the background:
Sql Server 2005 is installed on a separate box, let's call it SERVER1. This Sql Server hosts both the MOSS content database as well as the reporting services database.MOSS 2007 is installed on a different box, let's call it SERVER2I've installed all the required components for both boxes with no installation errorsSSRS seems to be running fine on SERVER1. Report Manager can be used directly with a browser in native mode.SSRS also *seems* to be running fine in Integrated mode, i.e. I can create a reporting database for integrated mode:
The url http://host/ReportService/ReportService2006.asmx responds normally when I access it through browser using my domain credentialsThe url http://host/Reports/ returns a message saying that I can't access it in integrated mode, which, I take, is normal
MOSS is running ok on SERVER2
I can see that SERVER1 is in the same farm after I've installed WSS3.0 on SERVER1Also I can see the "Reporting Services" section in Central Administration
So all in all, everything seems to be ok. However, when I try to use the 'Set server defaults' link from MOSS Central Administration I get an 'HTTP 401 Unauthorized' error. I'm assuming clicking this link will result in MOSS calling the Reporting Services' SOAP endpoint ReportService2006.asmx which now seems to be the culprit. Here's why I think so:

Whenever this occurs, the IIS logs on SERVER2 show that someone from SERVER1 is indeed trying to connect to ReportService2006.asmx, but I'm not seeing any user credentials being passed (whenever I access the asmx through my web browser, the credentials I entered in the browser are recorded in the log). Furthermore, the Event Viewer on SERVER2 shows Audit Failure (code 529) events occurring every time I get the HTTP 401 error.

The Event viewer's message is as follows:

Logon Failure:     Reason:        Unknown user name or bad password     User Name:         Domain:             Logon Type:    3     Logon Process:    Kerberos     Authentication Package:    Kerberos     Workstation Name:    -     Caller User Name:    -     Caller Domain:    -     Caller Logon ID:    -     Caller Process ID:    -     Transited Services:    -     Source Network Address:    <SERVER1 IP>     Source Port:    <PORT>
From the Event Viewer message and the IIS log it would seem like my MOSS is trying anonymous access whenever it tries to access the SSRS SOAP endpoint, which of course results in a 401, since anonymous access is not allowed. Please note that if I enable anonymous access in the Reporting Services' virtual directories (just for testing), I get a different error. This indicates that the HTTP 401 indeed originates from this particular web service call.

I've heard that SPS2003 and Reporting Services don't like each other on the same box, but this is hearsay. Does anyone know if this is a confirmed fact? This box does have SPS2003 and SSRS2005 installed. I tried to uninstall the SPS2003 but that didn't help anymore.

I noticed someone having similar issues in another thread, but I
didn't see resolutions. I'm pretty baffled as to whether
this is a problem with the MOSS Add-in or the Reporting Services
installation.

Any input on this issue is very much appreciated. I'll try to also include a follow-up if we're able to get this working ourselves.

View Replies View Related

Reporting Services 2005 In SharePoint Integrated Mode With Forms Based Authentication

Well, I have SQL Server 2005 SP2 Reporting Services installed and configured in sharepoint integrated mode, so I am deploying reports in sharepoint libraries. Also I configured sharepoint to use forms authentication with builtin AspNetSqlMembership provider, but after this action I couldnot open reports through sharepoint library, instead of this, error was displayed mentioned below. I searched and found hotfix Cumulative Update 3 build 3186 for this issue, request it from microsoft support and applied it, but nothing has changed!

Error I have been experiencing is following:

An unexpected error occurred while connecting to the report server.
Verify that the report server is available and configured for
SharePoint integrated mode. --> The request failed with the error
message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/_layouts/login.aspx?ReturnUrl=
%2f_vti_bin
%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>

I continued to dig and find out that this hotfix should update Microsoft.ReportingServices.SharePoint.UI.WebParts.dll from version 9.0.3042.0 to new version 9.0.3180.0, but when I checked file version after applying hotfix, it remained the same as was before i.e. 9.0.3042.0. Apparently this cumulative update does not fix this issue.
anyone has any idea how to solve it? Thanks in advance.

sorry for my poor english :-)

View Replies View Related

Deploy/edit Reports In Sharepoint Integrated Mode

Hi,

I'm working with the Dec CTP of SQL 2005 SP2 and the associated Sharepoint addin.

I've been able to get a report created in VS2005 and manually uploaded to the Document Library holding reports, and the report works when I open it (using an internal datasource, not shared).

My first problem is I can't get VS2005 to deploy datasources or reports to my doc library.
I have configured
TargetDataSourceFolder http://server/site/doclib
TargetReportFolder http://server/site/doclib
TargetServerURL http://server/

When I try to deploy my Shared Data Source, it asks me to login, and will not accept my credentials (I am farm administrator, and site collection administrator, and local administrator, and a site owner)

 

Secondly, for the report I manually uploaded, I can't edit it in Report Builder (from Sharepoint) because I get stuck on entering something that works into the Select Site or Server dialog box.  I've tried http://server/ and http://server/site/ and http://server/site/doclib



Can I have some tips please?

Thanks
Martin

View Replies View Related

Cannot Deploy Reports From Visual Studio To Sharepoint In Integrated Mode

Hi

Having finally managed to get over the hump of getting Sharepoint integrated mode working in a farm install, I am having a problem deploying reports from Visual Studio to Sharepoint.

I have set the deploy properties as follows:

TargetDataSourceFolder: http://ppdwn-bl10:8888/ReportTest/Data Sources
TargetReportFolder: http://ppdwn-bl10:8888/ReportTest/Harvest Reports
TargetServerURL: http://ppdwn-bl10:8888/

Visual Studio is updated to Service Pack 2, as is of course the report server.

The reports APPEAR to deploy - they actually appear in the document library after deployment! But the result is:

------ Build started: Project: Harvest Reports, Configuration: Debug ------
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Harvest Reports, Configuration: Debug ------
Deploying to http://ppdwn-bl10:8888/
Deploying data source 'http://ppdwn-bl10:8888/ReportTest/Data Sources/ReportWarehouse.rsds'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdown.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdownSaleable.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/FaceBreakdown.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/LustreBreakdown.rdl'.
Report Server has encountered a SharePoint error.
Deploying resource 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/paspaley.gif'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ShapeBreakdownByPercentage.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ShapeBreakdownByPM.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/Summary.rdl'.
Report Server has encountered a SharePoint error.
Deploy complete -- 9 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========


Unfortunately I cannot view the reports in Sharepoint - I can see them in the document library but when I click them I get the same error, except in the web browser. "Report Server has encountered a SharePoint error".

The Report Server log shows the following:

w3wp!library!1!03/06/2007-09:38:24:: Call to GetPermissionsAction(http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdown.rdl).
w3wp!library!1!03/06/2007-09:38:24:: Call to ListParentsAction(http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdown.rdl).
w3wp!security!a!03/06/2007-09:38:24:: i INFO: Exception while running with elevated privileges
w3wp!security!a!03/06/2007-09:38:24:: i INFO: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
w3wp!library!a!03/06/2007-09:38:24:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error.
w3wp!security!a!03/06/2007-09:38:25:: i INFO: Exception while running with elevated privileges
w3wp!security!a!03/06/2007-09:38:25:: i INFO: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
w3wp!library!a!03/06/2007-09:38:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error.




Any help would be appreciated.

Thanks
Adam

View Replies View Related

How To Deploy A Report In Reporting Services Without Using VS 2005?

When I try to put a new report in existing folder there's no problem,but now i have fresh installed Reporting Services and no Visual Studio2005. How do i open a new folder?

View Replies View Related

SQL Server 2005 Running In 2000 Compatibility Mode And Reporting Services

Can you run SQL Server 2005 in SQL Server 2000 compatibility mode and still use it with Reporting Services 2005?

View Replies View Related

Unable To Deploy Reports From VStudio When Working In SharePoint Integration Mode

Hello, I have a configuration where my SharePoint services are running on a web machine and the SQL server reporting services are running on a different machine.
I installed SQL SP2 and the SQL Server Reporting Services Add-in for SharePoint by following all the instructions listed in €śConfiguring Reporting Services for SharePoint 3.0 Integration€? (http://msdn2.microsoft.com/en-us/library/bb326356.aspx).
My issue is that when I Deploy a report from a VS Report Server project by running Visual Studio on the machine where reporting servicers is running, everything works fine.
But if I try the same thing on any other machine on the network, I get a €śThe file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.€? message.
 
I€™m sure I€™m missing something on the configuration but I can€™t tell what.
 
Thanks a lot
 
Gabo

View Replies View Related

Report Builder In Integrated Mode

Hi,

I have an installation with Reporting Services in integrated mode with WSS 3.0, with Reporting Services Add-in for SharePoint.

I have a document library in witch I added a data source to an SSAS database and a Report model on top of this. When I click Add a Report with Report Builder, the report builder opens, but it fails to connect to the model.

There is a dialog window "Select Site or Server "asking for a URL. I put in there http://localhost, but is not working. I am not able to connect to the report model.

I will appreciate any help on what could be the reason or how can I investigate this.

Thanks,

Dan

P.S.

I did the same scenario on the development environment it works from start, without any problems. But now on production €¦.

View Replies View Related

Reporting Serivces In SharePoint Integrated Mode Give The Wrong User.

Hi,

I'm using reporting services 2005 SP 2 in SharePoint integrated mode (with WSS 3.0) with forms authentication.
Both reporting services and SharePoint are installed on same server under the same website.

This setup was working correctly until I extended the site for an intranet version of the application to enable the site search to work with forms authentication (see http://technet2.microsoft.com/windowsserver/WSS/en/library/8208d71e-7c41-4845-bc06-95429de02cf11033.mspx?mfr=true)
Now the search works correctly but the logged in user reported by reporting service is always the SharePoint application pool user.  If I stop the intranet site reporting services reports the correct logged in user but obviously the search stops working.

How do I get round this problem? Any help would be greatly appreciated.

Thanks


Andy

View Replies View Related

Using Jump To Report In Sharepoint Integrated Mode

Is there a way to use the Jump To Report option within the new Reporting Services add-in Sharepoint webpart (SQL Server 2005 SP2, Report Server in Sharepoint integrated mode)?

daw

View Replies View Related

Building A Report-dashboard In WSS 3.0 Integrated Mode

I have a page with three Web parts;

1. Filter Web Part that uses a BDC-driven list of clients

2. Part showing RDL's from a doclib

3. Report viewer Web Part

I can use the Filter part to supply a parameter value to 3. when I select an RDL manually, I can set the Viewer connections to get the Report Definition from 2. But I can't get both options to work at the same time. The reports in 2. all have the same Parameter so there shouldn't really be a problem.

Looking forward to any suggestions or a way to provide feedback on the CTP (RS SharePoint Addin).

TIA.

Ed

View Replies View Related

Cannot View Report With MOSS And SSRS Integrated Mode

Hello,
 

I have configured Reporting services to use MOSS integrated mode. I have two servers, one for MOSS and the other for SQL database and reporting server.
 

Since I am using NTLM for IIS authentication, I can only use "Trusted Account" for Reporting Service Integration.

Then I created a report in SQL Server BI development studio and deployed to a MOSS document library. The deployment was successful. However, when I tried to open the report, I got the following error message:
 

An error has occurred during report processing.
This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode.
 

I have tried to switch to "Windows Authentication" for Reporting Service Integration, but this will give error for "Set Server Defaults" screen. Also the deployment from BI studio to MOSS will fail with authentication error. So I think I have to stay with "Trusted Account" option there.
 

What should I do to make the report accessible while using "Trusted Account"? Is there any configuration which has to be done for this purpose? Any input is appreciated.
 

Thanks,
Jun
 

View Replies View Related

Passing Paramater Values To A Report In Sharepoint Integrated Mode

How do I pass parameters via a URL in Sharepoint integrated mode. I tried using rs:Command=Render&Parm=value(with my parameter and value of course), but it ignore this and still ask for the parameters.

View Replies View Related

Error: Email Subscription To Report (Sharepoint Integrated Mode) Options

I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.

 

Below is the message detail:


A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)


Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?

 

Regards,
Gunady Ng

View Replies View Related

The Operation Is Not Supported On A Report Server That Is Configured To Run In SharePoint Integrated Mode

 

Hi,

 

I got the following exception from the code listed below:

 

System.Web.Services.Protocols.SoapException occurred
  Message="The operation  is not supported on a report server that is configured to run in SharePoint integrated mode. ---> The operation  is not supported on a report server that is configured to run in SharePoint integrated mode."
  Source="System.Web.Services"
  Actor="http://haileizws32b:8080/ReportServer/ReportService2005.asmx"
  Lang=""
  Node="http://haileizws32b:8080/ReportServer/ReportService2005.asmx"
  Role=""
  StackTrace:
       at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
       at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
       at Microsoft.PerformancePoint.Planning.Client.Common.ReportServer.ReportingServices2005.ListChildren(String Item, Boolean Recursive) in c:Officedev14ppsplanningclientCommonReportingServices2005.cs:line 1001
       at Microsoft.PerformancePoint.Planning.Client.Common.DataAgent.RetrieveDirectoryStructureFromReportingServices(Object caller, Object parameters) in c:Officedev14ppsplanningclientCommonAgentsDataAgent.cs:line 2027
  InnerException:

 

The code is like:

 

ReportingServices2005 reportingServices = new ReportingServices2005();

reportingServices.Url = "http://haileizws32b:8080/ReportServer/ReportService2005.asmx";

reportingServices.Credentials = System.Net.CredentialCache.DefaultCredentials

CatalogItem[]  items = reportingServices.ListChildren("/", true);   <== This code throws the exception.

 

I can browser and view the items from both Sharepoint site and ReportServer site without problem.

 

Can you tell me what is wrong?

 

Thanks a lot!

View Replies View Related

Unable To Deploy Report

Howdy!

My first attempt to deploy a report from SQL Server Reporting Services failed and I'm not sure what to change to fix the problem.  

The error message reads: "A connection could not be made to the report server http://localhost/ReportServer." 

Then under Additional INformation, it reads:  "Client found response content type of 'text/html; charset=utf8', but expected 'text/xml'."

 

I also had a problem after I configured the Reporting Services.  To confirm that the ReportServer database had been created, I tried to access http://localhost/Reports from Internet Explorer.  The error message I get is: "The XML page cannot be displayed"  Then it says that "a name was started with an invalid character.  Error processing resource 'http://localhost/reports/'. Line 1, Postition 2."

 

I'm assuming that the latter problem is causing the former, but I don't know what to do to correct it.  Can you help me out?

 

Thanks!

Mark 

View Replies View Related

Unable To Deploy A Report

I deployed  a report i'd been practicing on and it worked fine.  I then attempted to deploy it to production and was asked for user name and password.  On the server i used for production I am an admin yet my credentials did nothing, just keeps asking for user and pass again. 

Along the same lines I want to know how to allow people within our network to view production reports without needing to type in credentials.

View Replies View Related

Unable To Deploy Report

I've created a report and have the role of a 'global admin' however, when I try and deploy the report, I get an error message that I don't have permissions.
What other permissions do I need?
Thanks
Susan
 

View Replies View Related

Integrated Video In Reporting Services?

Hello,
 
After searching the SQL reporting services forum for a while, I decided to lay this problem before you.
I am faced with the following problem:
I want to generate a report containing video data, this videodata is streamed into a SQL 2005 database.
The main question I have is whether it is at all possible to show moving images in an report? (for instance with a CRI?)
Or should I look in another direction (I initially thought of an external link to HTML file with an MediaPlayer Object and having the file stored on a harddisk for instance?)
Any help on this subject would be greatly appreciated!
 
kind regards,
 
Michiel

View Replies View Related

Report Model Accessing SSAS Cube In SSRS Sharepoint Integrated Mode----- Perspective ID Error

Hi,
 
I am receiving the following error when I run the report builder query. I am able to successfully select the dimensions and measures that I am intrested in but when I run the report I get the error message.
 
The 'PerspectiveID' custom property for the 'query' perspective is either not set or is not set to the string data type.
----------------------------
Semantic query execution failed.
----------------------------
Query execution failed for data set 'dataSet'.
----------------------------
An error has occurred during report processing.
 
I am testing this against both Adventureworks standard and enterprise cubes. Additionality I saw a post in this forum
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
that seemed related but I am using reporting services in sharepoint integrated mode so I am having a hard time trying to troubleshoot this.
 
Thanks,
Larry
 
 
 
 
 

View Replies View Related

Unable To Deploy To Report Server

Hi!
 I have the report server in Share Point integrated mode.
 When I Deploy a report from a VS Report Server project by running
 Visual Studio on the machine where reporting servicers is running, everything works fine.
 But if I try the same thing on any other machine on the network, I get the following message:

TITLE: Microsoft Report Designer
 ------------------------------

A connection could not be made to the report server http://test/.

------------------------------
 ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml' ( and so on....)

Do I need to install sp2 on the machine I'm trying to deploy from?

//C

View Replies View Related

Unable To Deploy Report To Server

I get a Report server login pop up Is there a default login and password for a default install of the report server? I am trying to deploy my report from my computer to our server. I can upload from my computer but can not deploy to the server.
 
 

View Replies View Related

Integrated Development Environment For Reporting Services

Is there a development environment for Reporting Services (2005) that is integrated with source control? 

 

You can use Visual Studio to develop reports and place them under source control.  But as far as I can tell, you cannot implement security, scheduling, etc. through Visual Studio.  For these you can use a second environment, e.g. SQL Server Management Studio - but is this environment integrated with TFS?

 

In other words, is there a single development environment, integrated with TFS, where you can develop all aspects of Reporting Services reports?

View Replies View Related

Unable To Deploy SSRS Report Models

I am having mucho difficulties deploying Report Models from my box.

I create a brand new report model project, I add a data source, a datasource view, and a report model.  Everything builds fine.  I setup the project to point to a valid SSRS Server (and I tried this on another person's box, everything worked fine), click deploy- enter the credentials, and the logon box just keeps popping back up instead of deploying.

When the credential box pops up, it has a "" in it.  When I try this on another person's box, it works fine.

I just upgraded to SQL Server 2005 SP2, but I do not have Visual Studio 2005 SP1.

Could some of that be a problem?

View Replies View Related

Unable To Deploy A Report Model That Contains An ODBC Connection

Hi,
 
I'm trying to deploy a Report Model to my local machine that contains an ODBC connection to an iSeries Access ODBC Driver. The system DSN is already setup on my PC, named exactly the same. The data set views and report models create and build succesfully but when I try to deploy using BIDS  I get an error description "System.Data.Odbc" for the dataset file and the model.
 
I can't really see anything substantial in the log files, although not sure what one I should be looking in.
 
Any help gratefully received
 
Paul

View Replies View Related

Reporting Services: I Cannot Deploy Reports.

 
I am using Visual Studio 2005 and trying to deploy reports to SQL Server 2000.
I get the following message:
 
 
A connection could not be made to the report server http://aklink1/reportserver.
 
------------------------------
ADDITIONAL INFORMATION:
 
The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)
 
 
Please help!

View Replies View Related

How To Deploy Reporting Services Into Different Folders

Hi,

can i deploy reporting services rdl files into different folders in RS?

will it be able to create the folders by itself or do i need to create them beforehand?

thanks for any answers.

-

HY

 

 

View Replies View Related

Deploy Failed In SharePoint Add-in For Reporting Services

Hi all,
 
I am a newbie for SSRS 2005 and have a problem about deployment step. First, I have already configured the reporting services and have also tried to create the report by SSRS. Everything is fine until the deployment of my project. The error is shown as followings:
 
The path of the item '/DS/DSSS2' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash.          
 
Deploy failed
 
And, these bellows are my details
Full name path              : c:mossdata
eport
eportml
eportmlDRPSS2.smdl  
TargetDatasource         : DS
Data Source Name       : DSSS2
 
Then, I have come back to the SharePoint portal and found that the data source folder and data model folder are created as my earlier steps (before deployment step). I, therefore, build the report by using Microsoft report builder and adding the built report into my port through the SQL Server Reporting service report viewer. It is fine and shows the result as my design. But I wonder the error warning in deployment step and would like to solve that. I think my full path name is not longer than the 260 characters as above.
 
Have anyone suggest me about this situation for fixing the error?
 
Thank in advance



 

 

View Replies View Related

Migrating Reporting Services 2005 With Integrated Sharepoint 2007 To Another Server

hello good afternoon, I am having this issue, I need to move reporting services from one server to another, but I need that credentials, roles and reports stay the same. But as the reporting services is integrated with sharepoint, dont know if I can move both at the same or it has to be done one at a time.  this is just data migration, but still I will like to Know how it can be done having the same structure with the roles and credentials. or it is prefered to do a ghost?? but the issue will be that we have the reporting services in one place and the data in another... don´t know how this will affect. thanks in advanced for the help.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved