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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

SSRS DataSource as XML (Using WebService) Error: Credentials

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :Sql Server
 
Hello all, I have a requirement in which i have to generate reports (using SSRS) with my Sharepoint list as Data Source. This can be done by consuming the web services in my SSRS, by providing the connection string and Type = XML. My connection string when browsed in browser, "http://<server name>/_vti_bin/lists.asmx" gives me the *method lists* in the <server name>.. which is fine. However when this is used in my DataSource in SSRS, i get the following error: "You might not have permission to view this directory or page using the credentials that you supplied. The Web server has a filter installed to verify users connecting to the server and it failed to authenticate your credentials." :( In the credentials tab, i am using the "Windows Authenticated"   Any help is highly appreciated. :)


View Complete Post


More Related Resource Links

ssrs 2008 reports Datasource error in Test server..

  

Hi ,

 i Have upgraded my Reports from Report server  VS 2005 to  VS 2008 .

My reports works fine in local, development & test server.

After Ugrading to 2008 it works fine in local server & devlopement serverr.

 When i deployed to Test server i am trying to access my reports i am getting below errors,

 An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..

i checked the Datasource conncetion properties..its pointing to correct Test database only..

My reports are windows integrated...

Now it works in srs 2005 developement & test server. For same properties it works in dev server,  it  doesn't works in srs 2008 test server.

 

Why? Can anyone give me some idea...?

 


SSRS and DataSource cannot be found error

  
Hi,

I just upgraded a server from SQL 2005 to SQL 2008.  We are running Reporting Services.  When I try to view my report I get this error:

An error has occurred during report processing. (rsProcessingAborted)
The data source 'My_DataSource' cannot be found. (rsDataSourceNotFound)

The database is available and I can query it just fine via T-SQL

Any thoughts?  



ssrs 2008 R2 - report parameter with no default set throws java script error

  
We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

[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,

Linked Report Subreport- Error: Subreport could not be shown on SSRS 2008r2

  
I've got 2 folders: /Finance /Japan In the Finance folder I have a Sales report that has 3 subreports, and a salesregion parameter. I created a linked report in /Japan to /Finance/Sales, hide the salesregion parameter, and set the default to Japan, so they can only see their region's sales data. But when a Japan user runs the Sales report, they get Error: Subreport could not be shown because they do not have access to the /Finance folder. Any ideas?

WCF REST webservice authentication error when hosted with godaddy

  
Hi guys, I'm currently hosting my site on a shared windows hosting box with Godaddy. I have upgraded my hosting account to .NET 3.5 and having IIS7 as well which is in integrated pipeline mode. I recently build a simple WCF web service using the REST started kit preview 2. Once i uploaded it to the server, I am getting this error"IIS specified authentication schemes 'Basic, Anonymous', but the binding only supports specification of exactly one authentication scheme. Valid authentication schemes are Digest, Negotiate, NTLM, Basic, or Anonymous. Change the IIS settings so that only a single authentication scheme is used." You can see it here:http://sawasdeethaiart.com/service.svcThe obvious fix for as i have read from various websites, is to make sure I configure my IIS to have either Basic or Anonymous specification enabled. But as i am on a shared hosting account, i dont have any access to do this. (I have checked all my options in the IIS hosting panel, but there is no option). I am also done this in my web.config<authentication mode="None"></authentication> Is there any other option I can add  to my web.config to overcome this? or is there any other fix for this? Any help will be greatly appreciated. Thanks,Mark  

SSRS 2005 WebService Programatic Multiple Parameters?

  
I am using ssrs webservices with c#. Works great until I try to pass in multiple parameters then I get: "Default value or value provided for the report parameter 'X' is not a valid value." I am at a loss - I have the split function in my stored procedure and can pass in the values like '01/05/2010,01/062010' etc no problems. I have tried wrapping the comma seperated string with single quotes and without, tried adding them as seperate inputs with no luck same response. Report works fine from SSRS interface but not when calling it using web services. Any assistance is greatly appreciated - I have done numerous web searches and found no answers. Below is the c# code snipet: //set up the parameters List<ParameterValue> input = new List<ParameterValue>(); ParameterValue pval = new ParameterValue(); pval.Name = param.Name; pval.Value = "'" + paramsSelected + "'"; input.Add(pval); //call the report service.Render( ReportName, "PDF", null, null, input.ToArray(), null, null, out encoding, out mime, out outParams, out outWarn, out outStreams);

Bogus DataSource, DataSourceID Error Message

  
I believe this may be a bug in the .NET runtime or perhaps in LINQ2SQL, but I am not sure where or how to report it? Can anyone help me? I have a simple C# web page that is using a gridview to display an email log. The grid is bound in the code behind to a LINQ2SQL query and there are no parameters set for the DataSource, or the DataSourceID in the gridview in the .aspx page. This page works fine in Visual Studio 2010. Compiles, runs with no errors or warnings. When we publish it to a server with IIS 6.0, it displays the following error: "Both DataSource and DataSourceID are defined on 'gridview1'.  Remove one definition"  The solution is to set  "grdVendorEmailLogs.DataSourceID = string.Empty;"  But why when there is no DataSourceID declared or set to begin with? Here is the gridview code:  <asp:GridView ID="grdVendorEmailLogs" runat="server" AutoGenerateColumns="false"                    Width="80%" CssClass="gvHeaderRow" Font-Names="Verdana" Font-Size="Small">                    <Columns>  &n

Integrated SSRS and kerberos working great.But one user gets An unexpected error occurred while conn

  
I have this one user who can access SharePoint with no problems otherwise but is getting errorAn unexpected error occurred while connecting to the report server When they try to access an SSRS reports I confirmed he has access. Client issue? AD Account issue?Thanks.

SSRS NULL Error

  
HelloI encountered the following error because in my stored procedure, some of the tables were truncated. I resolved the problem, but wanted to know how I can ensure that the report users will not get an error when they run the report and a record does not exist.  Build complete -- 0 errors, 0 warnings[rsRuntimeErrorInExpression] The ToolTip expression for the textrun 'Text.Paragraphs[0].TextRuns[0]' contains an error: The query returned no rows for the dataset. The expression therefore evaluates to null.[rsRuntimeErrorInExpression] The ToolTip expression for the textrun 'textbox3.Paragraphs[0].TextRuns[0]' contains an error: The query returned no rows for the dataset. The expression therefore evaluates to null.Preview complete -- 0 errors, 2 warnings Thanks,   Kajo  Kajoo

"Service not available " Error in SSRS 2008

  
HI ALL, I Have created few reports in SSRS 2008 and deployed to report manager,though reports are working fine in it but sometime what happens when we click any reports its shows error "Service UnAvailable". after getting that report ,i simply close the window and open again after 10 or so ,again it work fine . Please suggest whether its a bug in report manager or i am commited some mistakes over it.   Regards Amit.

SSRS and Sharepoint Error

  
Hi After installing SSRS with SP2 and setting up the integrated database and services I am getting the following whenever I try to browse the the report server website using the URL.  Report Server has encountered a SharePoint error. (rsSharePointError)   e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'Domain\User' are insufficient for performing this operation., ;  Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'domain\User' are insufficient for performing this operation.   I have the reporting service and SQL installed on the same server with the server added to the MOSS farm and central admin running on both the database server and a seperate WFE. In an attempt to find out where the insufficient permissions lay the account being used is a local admin on the database server and a SQL admin and is also being used for the windows server identity and web service identity for SSRS. It is my understanding that I do not need to install the add in for MOSS at this point, and I should be able to browse the sites in a list through the SSRS virtual directory I created under the default website. Many thanks

how to pass sharepoint webservice credentials without hardcoding the credentials?

  
Hi,         i have a requirement where i need to use lists.asmx webservices. whenever an item is created in  announcement list on server A, its reference i.e. the item id needs to be added to the announcement list on server B. i got this done working, but i hardcoded the credentials for the webservice. something like this cmoss2.Lists StudentList = new cmoss2.Lists(); StudentList.Credentials = new System.Net.NetworkCredential("administrator", "admin1234", "myDomain"); StudentList.Url = "http://cmoss:6789/_vti_bin/lists.asmx"; cant we do this with out hardcoding the credentials? kindly suggest me, if there is any workaround. Thank you all  

SSRS DatsSource as XML (using WebService)

  
Hello all, I have a requirement in which i have to generate reports (using SSRS) with my Sharepoint list as Data Source. This can be done by consuming the web services in my SSRS, by providing the connection string and Type = XML. My connection string when browsed in browser, "http://<server name>/_vti_bin/lists.asmx" gives me the *method lists* in the <server name>.. which is fine. However when this is used in my DataSource in SSRS, i get the following error:"You might not have permission to view this directory or page using the credentials that you supplied. The Web server has a filter installed to verify users connecting to the server and it failed to authenticate your credentials." :( In the credentials tab, i am using the "Windows Authenticated"   Any help is highly appreciated. :)

error in inserting data into the datasource

  

hello all i have a gridview and textbox i want to insert the data that typed in the textbox  into the gridview i can do this but in other culomn i just can insert number 
and when i type some world the error say:Invalid column name'every thing ' 
 

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="soal.aspx.vb" Inherits="soal" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
    </style>
</head>
<body bgcolor="#fe9cef">
    <form id="form1" runat="server">
    <div>
    
    </div>
    <table class="style1">
        <tr>
            <td>
                <asp:GridView ID="GridView1" runat="server" AllowSorting="True" 
                    AutoGenerateColumns=

SSRS Subscription Error (rsInvalidDataSourceCredentialSetting)

  

Hi,

I just started using SSRS using SQL Server 2005. I've created several reports and have deployed these reports so they are available to use in Report Manager. I started playing around with subscriptions hoping to automate and schedule printouts for my end-users. I am trying to subscribe to this one report and have filled in the necessary fields in the subscription page but after getting everything filled in, when I hit OK, I get the ff msg - "The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)". I've looked this up online and found a Microsoft Technet page on changing the setting of the data source I'm using and is as follows -

1.Go to the Data Sources properties page of the report that you want to automate.
2.For the Connect Using option, select Credentials stored securely in the report server.
3.In User Name and Password, type credentials that can be used to access the database. If you are using SQL Server as the data source, the user name must be valid for both logging on to the server and for accessing the database that contains the data for the report.
4.If the user name and password are credential

Sharepoint + SSRS -Report Security??? An unexpected error occurred while connecting to the report s

  

I am able to deploy reports and run them as the farm admin that I did the Grant entry for in CA > App Mgt > Reporting Services > Grant DB access.

 

However, my AD personal user that has Local admin on every server has integrated SA security to the SSRS and Sharepoint Database is a Farm admin get's this error trying to run the reoprts.

 

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

 

Now if I log in as the farm admin ( the user I did the grant on) I can run and add the reports to the SSRS webpart... Am I going to have to add every user through that Grant feature? With integrated Sharepoint security there is no /reports virtual to decide what users can run  what reports so I'm not sure..

 

Some  other details.. I'm using Kerberos security, and CA > App mgt > Reporting Services > Manage integration mode is set to Trusted (not Windows).. otherwise .. I can't pull up Default settings under that Reporting Services section of CA.

 

I also d

Categories: 
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