Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







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 Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
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
Vista IIS7 And Asp.net Reporting Services Wont Deploy
I am using vista, iis7 sql server 2005 sp2, vs 2005.

i first noticed that i could not deploy to the localhost server after upgrading to vista.

i installed sql server sp2 and configured the iis7 using the control panel. Everything i needed to check off got loaded exept the asp.net check box in the ApplicationDevelopmentFeatures subcategory under the iis configuration section.

It errored out when i clicked apply. there was no specific error just that it did not get added.

Controlpanel> Programs>T urnWindowsFeaturesOnAndOff> InternetInformationServices> WorldWideWebServices> ApplicationDevelopmentFeatures> Asp.net  (check box)

When i click OK, afte a few minutes, i get a message:

         "An error has occurred. Not  all the features were successfully changed."

what good is iis7 if it cannot support asp.net?

I assume something is wrong. It is not permissions. I am the administrator account and i have assigned my account as the administrator for both sql server and reporting services.

So what is it?   

Jerry Cicierega

 

View Replies !   View Related
Using TFS Build To Auto-deploy Reporting Services Reports
Has anybody used Team Build to deploy reporting services reports to a test server?  We currently use an RSS script that gets the current files from VSS and then deploys them to the RS server, but we would like to migrate the code to TFS.

View Replies !   View Related
Can't Access Reporting Services In Management Studio Or Web Interface Using Windows Integrated Security
I know from searching this forum that there have been many variations of the issue I'm currently suffering, but I haven't found anything quite like mine or a solution to solve it. The issue I'm running into is that I am unable to log on to Reporting Services using Management Studio or the web interface when Windows Integrated Security is enabled. I have full functionality using basic security, but the risks involved make it impossible to deploy basic authentication out into production. The error I'm receiving in Management Studio is The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient). I recieve the same error when I try the web interface.
 
I've looked the most recent logfile in WindowsSystem32LogFilesW3SVC1 and these entries match up to the time I attempted my authentication.



Code Snippet
2008-05-12 20:30:42 <Edited: Server IP> GET /reports - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:42 <Edited: Server IP> GET /reports - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 301 0 0
2008-05-12 20:30:42 <Edited: Server IP> GET /reports/ - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:46 <Edited: Server IP> GET /reports/home.aspx - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 302 0 0
2008-05-12 20:30:46 <Edited: Server IP> GET /reports/Pages/Folder.aspx - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:47 127.0.0.1 POST /ReportServer/ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2008-05-12 20:30:47 127.0.0.1 POST /ReportServer/ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2008-05-12 20:30:47 127.0.0.1 POST /ReportServer/ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 2148074248
2008-05-12 20:30:49 127.0.0.1 POST /ReportServer/ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2008-05-12 20:30:49 127.0.0.1 POST /ReportServer/ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2008-05-12 20:30:49 127.0.0.1 POST /ReportServer/ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 2148074248
2008-05-12 20:30:50 <Edited: Server IP> GET /reports/Pages/Folder.aspx - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 500 0 0
2008-05-12 20:30:50 <Edited: Server IP> GET /Reports/js/ReportingServices.js - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:50 <Edited: Server IP> GET /Reports/js/ReportingServices.js - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2008-05-12 20:30:54 <Edited: Server IP> GET /Reports/styles/ReportingServices.css - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:54 <Edited: Server IP> GET /Reports/images/blank.gif - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:54 <Edited: Server IP> GET /Reports/images/blank.gif - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2008-05-12 20:30:54 <Edited: Server IP> GET /Reports/images/48error.jpg - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:54 <Edited: Server IP> GET /Reports/styles/ReportingServices.css - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2008-05-12 20:30:54 <Edited: Server IP> GET /Reports/images/48error.jpg - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2008-05-12 20:31:07 127.0.0.1 GET /reports/ - 80 - 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:31:07 127.0.0.1 GET /reports/ - 80 - 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 1 0
2008-05-12 20:31:13 127.0.0.1 GET /reports/ - 80 - 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:31:13 127.0.0.1 GET /reports/ - 80 - 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 1 0
 
 
I tried to highlight one of each of the HTTP errors I am getting. 401.2 and 401.1 are the ones I kind of expected, but have no idea why I'm getting them. The 500 0 error is a bit troubling, because unless I'm mistaken thats a server side error.
 
Here's my current setup. As far as I can tell, I've done everything to set up correctly for Windows Integerated security.
 


My Specs
The server machine running all SQL 2005 services. It resides in a domain. All Clients are in the same domain.


Intel Dual Processor 3.20 gig Xenon

Windows Server 2003 w/ SP2

Microsoft Sql Server 2005 w/ SP2
Reporting Services Setup
The virtual directories Reports and ReportServer are set to Windows Integrated Security with Anonymous Access disabled. All other checkboxes in Directory Security are unchecked. For permissions in Reports, I have:


Administrators (servernameAdministrators) - Full Control

ASP.NET Machine Account - Modify, Read & Execute, List Folder Contents, Read, Write

Authenticated Users - Modify, Read & Execute, List Folder Contents, Read, Write

Creator Owner - No permissions

Domain Users - Read & Execute, List Folder Contents, Read

SQLServer2005ReportingServices]WebServiceUsers$... - Read & Execute, List Folder Contents, Read

SQLServer2005ReportServerUsers$... -  Read & Execute, List Folder Contents, Read

SYSTEM - Full Control

Users (CompNameUsers) -  Read & Execute, List Folder Contents, Read
In ReportServer I have the same permissions except Authenticated Users is absent.
 
At one point, I even added the account Everybody and gave it full control, and I still recieved a HTTP 401 error. Any help at what I might be missing would be a godsend.
 
Thanks.
 

View Replies !   View Related
Reporting Services Login Box Appears When Trying To Deploy In SSRS 2005
Hi All,

I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.

I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.

Any ideas?

Thanks! GB

View Replies !   View Related
Login Screen Appears Multiple Times In Reporting Services Using Integrated Windows Security
We have a RS 2005 instance connected to an AS 2005 cube. It is configured for URL access using the default Windows security. This is fine as it is not an Internet-facing application.

I have added users in RS and they have custom security roles in the AS cube; they are able to interact with the cube via Excel. When these users go to the RS page, they are able to see everything on the site but are prompted multiple times for log in. The login screen only disappears when you hit cancel. They are then able to generate reports but have to keep hitting cancel on the persistent login screen. The only user that does not have this problem is a Local Administrator on the server that is hosting the RS.

I have tried explicitly adding the URL (http://server/reports) to the Intranet zone (the site was being automatically identified as Intranet but did this anyway). Also, in desperation, I tried changing the User Authentication setting to "automatically log in with ID and password" but this did not solve the problem.

Any ideas on how to resolve this?

View Replies !   View Related
Can't Deploy A Report From BIDS To A Remote Reporting Server
I've recently installed Reporting Services 2005 on a Windows 2003 Server.  Both have had SP2 applied and other necessary patches.  I can't deploy a report from my desktop machine to the Reporting Instance.  I get the following error:
 
===================================
A connection could not be made to the report server http://db04SSRS/ReportServer. (Microsoft Report Designer)
===================================
The request failed with HTTP status 503: Service Unavailable. (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()
 

 
Also, from SQL Server Management Studio while logged onto the Windows 2003 Server, I can connect using http://localhost/ReportServer, but I CAN NOT connect with just the servername db04SSRS.  I can connect to the Analysis Services and the Database Engine with just the servername

 
I've seen several threads with similar issues, but none of the solutions have worked. 

View Replies !   View Related
Unable To Deploy Package Using Deploy Wiz Or Mgmt Studio
Am getting errors trying to deploy a dtsx created by ms (the reporting services execution log one) to which I have made zero changes, but it is not working (2 errors shown below)

error from deployment wizard:
===================================

Could not save the package "H:SSISRSlogRSExecutionLog_UpdateinDeploymentRSExecutionLog_Update.dtsx" to SQL Server "xxxxxxxxxxx".  (Package Installation Wizard)

===================================

The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired).  The SQL statement that was issued has failed.


------------------------------
Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
   at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames)
   at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)

===================================

The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired).  The SQL statement that was issued has failed.


------------------------------
Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage90 Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, String ServerPassword)
   at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)



error from sql management studio
===================================

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

------------------------------
Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
   at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)

View Replies !   View Related
Reporting Services Vs SharePoint Integrate Mode (urgent)
Dear friends,
I'm having problems changing the reporting services from native modo to integrate mode...
I saw a lot of articles and tips, but I still have problems...
For example, when I change my database setup to integrate mode there is all ok, but in the SharePoint tab has an image with error...
 
and in the sharepoint server when I need to grant acess to database gets an error to...
 
and the page that always runned :
http://CGDWX01115883/ReportServer
 
after I change to integrate does not work and gives me this error:
Reporting Services Error



An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Exception has been thrown by the target of an invocation.

Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.



SQL Server Reporting Services


 
This page must run ok, no?
Get Online Help

Exception has been thrown by the target of an invocation.

Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.




SQL Server Reporting Services


 
This page must run ok, no?
http://CGDWX01115883/ReportServer
 
CGDWX01115883 is the report server and database server
SDC6001SPT01 is the SharePoint Server
 
Could someone help me?!
Thanks!
 

View Replies !   View Related
Reporting Services In SharePoint Integration Mode Problems
Hi,

 

I'm having problems setting up Reporting Services in SharePoint Integration mode. The development environment works fine, but I can't get it to work in production.

 

Problem seems to be in the authentication between SharePoint and Reporting Services. When I go to "Set Server Defaults" in the SharePoint central administration I get the following message:

 




Code Snippet

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
   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.ReportingService2006.ListSecureMethods()
   at Microsoft.ReportingServices.SharePoint.Soap.ReportService2006.ListSecureMethods()
   --- End of inner exception stack trace ---

 

I get the same message when trying to deploy a report from Visual Studio to a SharePoint lib.

 

Some info:

 

- SP apppool is running under domain account a

- SSRS apppool is running under domain account b

- SP uses NTLM authentication

- SP and SSRS are running on different servers

- SSRS Configuration shows all green checkmarks

 

Things I tried:

 

- Basic authentication instead of Windows Integrated on SSRS

- NTLM only instead of Negotiate on SSRS

- Settings SPN's for SSRS, didn't help

- Checked NTFS rights on ReportingServer dir, were fine (Domain users have read/list)

 

Does anyone have an idea about how to solve this? Any help is appreciated.

View Replies !   View Related
How To Edit A Textbox In Preview Mode In Reporting Services?
 

Hi everybody!
I've created a report in reporting services and in it i need to have a dynamic textbox.
Let me describe more.I have two reports ,in first report i have manegers' names .After that  users see first report and manegers' informations for example their names and saleries , they want to select manegers on base of  for example their saleries ,i mean she/he must see informations then decide and select manegers who their employees will be shown in second report ,in this case i need a textbox that the user can write Yes or No in it,and i need multiple select.
After that users select their manegers they can see manegers' employees in second report.
I need a textbox that has two values (Yes and No) and these values must be shown in textbox in preview mode to select by users  or user can select Yes or No .
Can anybody help me?
ShimaS
 
 

View Replies !   View Related
Installing SQL Server Reporting Services With SharePoint Integration Mode
 

Hello:
 
I can't seem to get Reporting Server to work with Sharepoint Server 2007. My results are similar to the thread http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1801673&SiteID=17 but with slightly different results.
 
Server is running 32-bit Windows 2003 running Reporting Services only. Everything is green (except Reporting Services Manager which is greyed out) in Reporting Services configuration manager. Windows Service account is set to a domain (Windows)account. This server is also running SharePoint Server 2007 as a Web Front End within our SharePoint farm, and the Reporting Services add-in has been loaded on the machine.
 
Issue 1: I cannot connect to the reporting service server AT ALL. When I type the URL into IE, I get the message:
 
Reporting Services Error





The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
The log file states:
 
w3wp!library!1!09/20/2007-16:08:50:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., 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.; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.
 
The report service service account (I am assuming it is the one I used to install Reporting Services and as the Windows account above can log in to SharePoint central admin just fine. And I can see the reporting server in the server farm in SharePoint central admin.
 
Issue 2: (It may be related) I can access "Manage Integration Settings" and "Grant Database Access" fine in SharePoint central admin. I am using trusted account because we are are using NTLM authentication. When I type in the database access it seems to find the report server because it doesn't throw an error.

When I click on Set Server Defaults I get:
 
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.
 
Thanks in advance for any assistance you can provide. I can't seem to find any info on this of help.

View Replies !   View Related
Reports Cannot Be Deployed From VS 2005 To Reporting Services In WSS Integration Mode
I tried to deploy reports from VS 2005 on Dev to Prod (different domain, in WSS integration mode) , but VS keeps showing the login window ...

I set up TargetDataSourceFolder, TargetReportFolder and TargetServerURL in VS 2005 on my Dev machine as mentioned in MSDN article "Deploying Reports, Models, and Shared Data Sources to a SharePoint Site" and tried to deploy reports to Prod machine. But VS 2005 keeps showing "Report Services Login" window to me, even when I used Administrator account of that Prod machine.

The WSS log file on the Prod machine shows this error: "The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators."

Any ideas?

Thanks in advance! I have searched for days for this issue ...

View Replies !   View Related
How To Get Server Mode Option In Reporting Services Configuration For Sharepoint?
 
Hi All,
I want to deploy my reports in a Sharepoint site.  So I need to change the Deployment mode from Native to Sharepoint Integrated mode.  When go to Reporting Services Configuration and in Database Setup - the Server Mode option is not visible.  Anyone help me what is the reason for this or How to get Server Mode option in Database Setup in Reporting Services Configuration menu.  However the system installed with Sharepoint and SSRS SP2.
 
Thanks in advance,
Senthil
 
 

View Replies !   View Related
Reporting Services In Share Point Integration Mode - Deployment Error
Hi
 
I am trying to deploy the reports on the share point site which is integrated with the reports Server.
 
I am getting below error while deploying  it.
 
Sharepoint Server, Reports Server and Database Servers are on 3 different boxes.
 
===================================

A connection could not be made to the report server http://vstsvr:171/sites/wslReports. (Microsoft Report Designer)

===================================


Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized. (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.ReportingService2006.ListSecureMethods()
   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()


 

Can any one help on this.
 
Thanks
Devanand

View Replies !   View Related
Unable To Connect To Reporting Services In Mng S
All,
While trying to access the Reporting Services in Mng studio.I receive the following error
Cannot Connect To ServerA
Client found response content type of 'text/html; charset=uf-8,but expected 'text/xml'
While trying to access the report on reportmanager.I receive an error."The report server is not responding.Verify that the report server is running and can be accessed from this computer"
Any suggestion?

View Replies !   View Related
Unable To Connect To Reporting Services
Hi all,
 
I am new to reporting services.  I have created a report project in SQL Server BIDS.  The datasource is SQL Server.  I was able to see the preview of the report and could build and deploy the report.  But when I try to run the report, it gives me error.  So I tried connecting to Reporting Services through SQL Server Management Studio. 
 
There I am unable to connect to the Reporting Services.
I am getting a very long error message.  Giving below few lines which made sense to me.
 
Client found response content type of text/html; charset=utf-8, but expected text/xml.
 
Parse Error Message : An error occurred loading a configuration file: Access to the path c:Inetpubwwwrootweb.config is denied

 
 
I have given full rights to ASPNET, AuthenticatedUsers.
 
Pl help to resolve this issue.
 
Thanks,
Tejaswini
 

View Replies !   View Related
Unable To Configure SQL 2K5 Reporting Services On IIS 5
 

hi all,
im attempting to configure my SQL Server 2005 reporting services on my development machine that is running IIS 5 on Windows 2000.
 
I installed the reporting services and went through the configuration application.  everything went fine.  the only item with a red x is the web services account - i read on several pages that within iis 5 you can't specify this and it always runs as the ASP.NET account. 
 
Every time i go to my Report Manager site i get the following error : The report server is not responding. Verify that the report server is running and can be accessed from this computer.
 
i have tried with several differnet admin accounts and none of them work. 
when i go to the actual Reporting server site i get this error :
ACCESS TO THE PATH : 'C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config'  IS DENIED.
 
i have given almost everyone in the world access to this file through windows security but to no avail.
 
Any ideas on what to try?
 
THANKS IN ADVANCE

mcm

View Replies !   View Related
Unable To Debug Using Reporting Services Process
I have written Custom delivery extension, I am trying to debug this by attching the process ReportingServicesService.exe , I am getting error "Unable to Attach to the Process.Access is denied".  I am Admin on my sytem, ASP.net is also part of admin and debuggers group. I am using Visual studio 2005, reporting services 2005, ReportingServicesService.exe  is also under my login

 

Any idea??

View Replies !   View Related
Unable To Install Reporting Services On Vista
Hi ,

i'm a new to vista and also with sql server 2005 reporting services ..

i was able to install all the tools in sql2005 express edition except reporting services ..gives a message IIS required ..even though the IIS is running and able to browse http://localhost  ..

can any one give me an idea , how to install reporting services on vista with IIS7

 

Thanks

 

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved