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

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

Issues in GetItemDataSources web service call in 2008 Report Server R2

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
Hi, I'm using Reporting Services web services endpoint ReportService2005.asmx with 2008 report server R2 and I'm facing some issues in getting the data source names for a report definition using the GetItemDataSources web service. The problem is that the data source names returned are different from the names of the actual data sources on the report server. The report has the following data sources: 0 1 _0 _A Data Source And the names returned by the GetItemDataSources for 2008 report server R2 is: AutoGen_0 AutoGen_1 AutoGen__0 AutoGen__A Data_Source When I make the same calls using a 2005 report server, the names returned are the same as that in the report definition. To summarize, only numeric data source names are changed to "Autogen_<number>"(eg. Autogen_0), data source names beginning with "_" are changed to "Autogen_<data source name>"(eg. AutoGen__A)  and spaces are replaced by an "_".   What is the problem for the data source names returned for 2008 report server R2? Or has there been any change in the way in which report server stores the data source names? Thanks, Kulbhushan Singhal.  

View Complete Post

More Related Resource Links

Server 2008 R2 64 bit, SSRS 2008 64 bit with Report Builder 3.0 issues with Oracle OLE Driver

Folks, ran out of idea on this issues. Setup as shown at the Title. I can connect via VS 2010  but report builder cannot run properly when setup with connection string. I use a 32 bit Oracle Driver and VS 2010 works well with it, however, Report Builder on SSRS report a bad image issues while attempting to use the same driver. What have been tried: 1-Already attempted to try to download Oracle ODP drivers 64 bit, but current driver 11g and minor version above 11g does not install, installation failed. So far all chats indicated that Server 2008 R2 does not have a Oracle 64 bit driver provided y Oracle. Any help is appreciated ....    

Trying to make a SQL Server Reporting Service 2008 report public for basic users


Hey.  I'm somewhat new to SSRS 2008 and I've built two datasources connecting to "HumanResources" and "HumanResourcesDev5" databases on a single server.  Both of those datasources have been changed from a Windows NT login clone to a preset login for a temp account that we have for testing called "Test2".  I have opened my created datasets and verified that when they open they ask for the password for the new credentials that I have set for the datasources.  After verifying this and the connection I re-opened the reports that I made within Report Builder (not Report Designer a VS extension) and verified all of the dataset and datasource information.  These reports and report parts get saved to the http://localhost/Reports folder within the server.  I have published the report parts to the /Report Parts folder within the localhost. 

This is where I begin to have issues...

When someone uses the reports that I have generated through report builder and link to them on our sharepoint site when a person without an actual account on the SQL server tries to view them they cannot because they do not have sufficient permissions.  And what I noticed is that it still tries to use their Windows NT credentials rather than the temp account (Test2) that we have created which is why they

Is this same as SQL server Reporting Service or else what can we say for these type of report genera

Hi      In my windows application I am generating reports using this steps          1) Creates a stored procedure in the sql server for the required report output          2) In the .Net application add new Item adds a DataSet1.xsd binds the stored procedure to the DataSet1           3) Adds a Report1.rdlc to the application and places the requred fields in the Report1.rdlc          4) Adds a ReportViewer control to a form and binds the Report1.rdlc to the ReportViewer contol and shows the report Is this same as SQL server Reporting Service or else what can we say for these type of report generation 

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

report viewer error / visual web developer 2008 / sql server 2008 / report viewer add on / win7 x64

hi, i decided to export my local site to iis today, the process wasn't smooth.   anyway. i was able to access my site, the db tables are working as i am able to create new records and retrieve them. my main problem now is with the report object. i've tried the work around found here : http://support.microsoft.com/kb/2002980.. it helped sort of. i used to have only a big page of error before i did the work around, now i am able to see half of the report (the report interface) but the contents, the field are filled with 404 errors. any idea how i can fix this??                  

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

SQL Agent - service account permissions - SQL Server 2008

Hi @ all   I installed two SQL Server 2008 on Server 2008 R2 Std (principal and mirror) and an AD Server 2008, with sperate service accounts, connect as SA, localy all works fine. I created some agent tasks (PowerShell, T-SQL), but I get some Error massages in the history, that service account of SQL Agent didn't have the permission to query a remote machine(access denied for wmi (HRESULT: 0x80070005 (E_ACCESSDENIED)) and linked database(SQLSTATE 42000 Error(7314)). The simple query with SA permissions on the remote machine works and the powershell scripts with the local domain user works too. But not with the SQL Agent. WHY?? Where ist the different between the user account permisions and service account permissions? Which settings are needed? Example: get-wmiobject -class win32_service -computername 192.168.xxx.xxx| where {$_.name -like '*SQL*'} Powershell Console: works                                     SQL Agent Job: access denied I tried some solutions with user rights, group policies and security permissions but nothing works. like: Configuration -Service Accounts, SQL Server or SQL Server Agent service account http://support.microsoft.com/kb/283811/en-us http://msdn2.microsoft.com/

Moving a Copy of SQL Report Server 2005 and Upgrade to 2008

Hello, We have SQL 2005 Report Server in a Windows 2003 64 bit server box. We want to create a copy of this report server database somewhere in the domain, so that we can access it for a different purpose. My question is, will there be any complications with this? I'm thinking about the encryption key that's needed to access the database. If we are successful with this, we might also want to upgrade to SQL 2008. Thanks for your help,   Elizabeth K.

SQL Server 2008 R2 Installation and Service Pack 1 Question

I am migrating a SQL 2000 server to a SQL 2008 R2 server (on different physical servers) . When I ordered SQL Server 2008 the volume licensing allowed me to download sql server web 2008, sql server web 2008 R2 and sql server 2008 service pack 1. I don't know why I have three options to download. Don't I just need to just install the sql server 2008 Web R2? Are there any sql 2008 R2 service packs available?   

How to set the IP addresses for teh report server on sql server 2008 reporting services

How to assign IP address to report server on 2008 version, i don't see nothing on IIS. I have installed sql server / report server 2008 on windows 2003 server. I don't see no info in IIS, can you please help, Also how to check the configuration files i remember in 2005 version i still have to open teh configuration file in notepad and do some modifiications with teh http://local to http://IPaddress etc. Thanky ou very much for the help ful info.  

Error connecting to Remote report server database in SQL Server 2008 R2 DataCenter Edition

I am trying to configure my report server installed on Server A to point to a reporting services DB on Server B. I am able provide the name and test the connection. However, when i click next on the configuration wizard after providing the Server A name I am receiving the below error: The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services I have SQL Server 2008 R2 DataCenter Edition on both the servers.    

SQL Server 2008 express SQL Server Service won't start

Could really use some help. Am running XP Pro SP3.  Had 2005 Express running fine previously.  Installed 2008 Express but cannot get the SQL Server service to start.  SQL Server Agent does start though.  In log (below) it seems to be trying to access an E:\ drive that doesn't exist (did default install to C:\Program Files) - plus other issues.  Have 5gig+ free, so not sure why it's saying not enough space.  Have RTFMd the problem for a whole day with no luck.  Any advice much appreciated.   Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)  Apr  2 2010 15:53:02  Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) (Hypervisor)   Error: 17054, Severity: 16, State: 1. The current event was not reported to the Windows Events log. Operating system error = 1502(The event log file is full.). You may need to clear the Windows Events log if it is full. (c) Microsoft Corporation. All rights reserved. Server process ID is 4988. Authentication mode is WINDOWS-ONLY. Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG'. This instance of SQL Server last reported using a process ID of 3232 at 9/4/2010 9:36:12 AM (local) 9/4/2010 1:36:12 PM (UTC). This is an informational

Sql server 2008 installation on windows 7 issues

Hey all,   I was installing SQl server 2008 Dev version on windows 7. It went smooth and when  ran the select @@version it shows sql server 2005 express edition.Does anybody know what is the issue? Any help would be greatly appreciated Thanks

Problem consuming 32bit WCF service which references a native Dll in a 64 bit OS(Windows Server 2008

I have some 32bit Dlls which i want to use it in 64bit OS as i do not have a source code of this to recompile it for 64 bit OS. I have created a x86(32 Bit) WCF service which calls these Dlls and hosted it as a Windows Service on a x64(64 Bit) machine using Windows Server 2008. I have created one more x64 client which calls a function in the WCF which in turn calls a function from the 32 bit native Dll. Whenever i try calling this WCF from the client I get an error as given below.Can anybody please guide as to where I am going wrong and what is needed to solve this issue. Thanks in advance for any help.******The Error Message********************System.BadImageFormatException: Could not load file or assembly 'TestWCFWrapper, Version=, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format.File name: 'TestWCFWrapper, Version=, Culture=neutral, PublicKeyToken=null'   at TestWrapperWCFClient.Form2.button1_Click(Object sender, EventArgs e)   at System.Windows.Forms.Control.OnClick(EventArgs e)   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)   at System.Windows.Forms.Control.WndProc(Message& m)   at System.Windows.Forms

SQL Server 2008 R2 Setup & Service Packs

Hello I installed SQL Server 2008 R2. (Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor) ) Are there any Service Packs for SQL Server 2008 R2 available i need to apply? Thanks V

Deploying report from Visual studio 2008 to report server

Hi, When I try to deploy report from visual studio 2008 into report server in dev. enviroment, I am getting error messag saying ...specified data source is not found and permission granted to user is insufficient. But I am a content manager in specified report. Please any help ful suggestions!

SQL 2008 R2 Report Server - what sync method should I use?

Setting up a report server inside the same network for accounting to run reports on. Data can  be 1 day behind and would like to be able to add more indexes than the original server.  No data will be written back to the original  (pub) server.  I have about 5 databases on the sql server that I'll be replicating. In reading the book, seem Transactional is the best choice. Any ideas or new features I should try instead?  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

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