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

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

SSRS - Credentials stored Issue

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

We have application where web application needs to interact with SSRS. It is in different box. SSRS runs under different service account. Web Application runs under different service account differnt box. But for all the data source we would like to use “Credentials stored securely in the report server ” with “Use as Windows credentials when connecting to the data source” whenever I do that I get below error. The service account I am trying to use is Application server IIS App Pool account. Because we would like to use only one acccount for all the credentials.


Log on failed. Ensure the user name and password are correct.


View Complete Post

More Related Resource Links

Data Truncation issue with Enterprise Library Logging WriteLog stored Proc


Hi ,

I'm using Enterprise Library Logging  feature for logging. The issue i am facing is when the Logging message is too large(more than 65534 chars) ,complete data  is not logged in the Formatted Mesage column which is  of data Type nText .

I am able insert complete data if i try inserting from Sql insert Query from sql management studio. Do i need to add any attributes to data base listener or do i need to change the sp.

 Is there any way to increase the WriteLog stored proc param size in EnterpriseLibrary.Logging config file ? . Please let me know.


Thanks In Advance.

ssrs space issue

Can anyone please explain how to reduce the blank space between two rows in ssrs report, I tried with adjustingthe row hight but it does not help meJeeva Jacob

Printing Issue in SSRS reports

Hi,   We developed around 70 ssrs reports for our new application.Its like,all the report names are mentioned in the left hand side and if we click it,.Net calls the SSRS reports and shows in the Right hand side.   The issue now is with the Printing.My client complains that they are not able to print the Reports properly.Some of the columns are moved to the next page,it seems.Reports are having different number of columns and we dont know how to resolve this issue.Should I use Landscape or Portrait?..If I give the table's width in the place of Report's width,will it work?    Your help would be greatly appreciated.

Issue with Enable and Disable Parameters in SSRS 2005

Hi Guys, I am currently facing an issue with Enabling and Disabling Parameters in SSRS 2005. Here is my scenario. I am having the following 4 parameters - ParamType (has values 1,2,3), ParamMonth, ParamStartDate, ParamEndDate Now What I want is When I select ParamType = 1 and 2 then ParamMonth should be enabled and ParamStartDate and ParamEndDate should be disabled. When I select ParamType = 3 then ParamStartDate and ParamEndDate should be enabled and ParamMonth should be disabled. I have done google search on this issue and found out that this is not possible at run time. Is there any alternative for this issue? If the above is not possible, I would like to get atleast in this way : When I select ParamType = 1 and 2 then ParamMonth should show the values (from dataset named MonthDataSet and default should be the latest Month) and ParamStartDate and ParamEndDate should show as NULL. When I select ParamType = 3, then I need to enter ParamStartDate and ParamEndDate values manually or pick via datepicker and ParamMOnth should show as NULL. I am not sure whether this is possible or not....but just trying to get in some way. Here is the query used in MonthDataSet : Select Month_Code, Month_Name from MonthTable. Thanks

Browser back button issue when ViewState stored in DB.

I implemented the solution of storing the ViewState in DB (since we were getting lots of Invalid & Corrupt Viewstate errors on our site daily) as given in the following website:http://weblogs.asp.net/adweigert/archive/2004/03/09/86628.aspxThe solution was implemented in one of the aspx pages on our site that behaves like a wizard (not using the wizard control though). After starting to store the viewstate in DB, the Invalid ViewState errors were eliminated completely, but I am now facing the following problem:1) User selects radiobutton1 of the two radiobutton choices on Page 2 of the wizard, a postback happens which displays some extra information on the page based on the selection. Now the user hits the next button on the page that also does a postback & displays Page 3.2) On Page 3, user hits the "back button" of the browser instead of the "previous page" button that is available on that page.3) This displays Page 2 from cache in original state(without any selections made). When user now selects radiobutton2, a postback is supposed to happen, but it does not. User then clicks "next" button on Page 2 (a postback does happen here however), & Page 3 is displayed, but it still thinks that radiobutton1 was selected (the original selection that was made in step1) on the previous page & hence displays information accordingly.I am assumi

Character spacing issue SSRS 2005 custom font

Hello together, we are facing a strange character spacing issue in SSRS 2005 SP3 (Version 9.00.4035.00). As we export the report to a pdf file, we get unwanted spaces between each character. The report uses custom fonts. Is there any known issue related to this? I appreciate your help. Thanks!  Kind regards Moritz Mars

Stored Procedure Subquery Issue

Hi, In the below stored procedure, I often get this error message... "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression." Why is this? I check for multiple entries and delete any that exist. Yet still gives that error on occassion.  Thanks. ALTER PROCEDURE [dbo].[MainTbl] -- Add the parameters for the stored procedure here @Name nvarchar(5), AS SET TRANSACTION ISOLATION LEVEL READ COMMITTED BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; Begin Transaction DECLARE @DetailsColour nvarchar(6); -- Insert statements for procedure here Begin -- Details DECLARE @CountDetails int; DECLARE @FirstEntryDetails int; SET @CountDetails = (SELECT COUNT (Name) FROM [DetailsTbl] WHERE Name = @Name ) if (@CountDetails > 1) Begin SET @FirstEntryDetails = (SELECT TOP(1) NameID FROM [DetailsTbl] WHERE Name = @Name ORDER BY NameID ASC) DELETE FROM [DetailsTbl] WHERE Name = @Name AND (NameID != @FirstEntryDetails) End Set @DetailsColour = (SELECT DetailsColour FROM [DetailsTbl] WHERE Name = @Name) if @DetailsColour is null begin set @DetailsColour = 'RED' end DECLARE @FoundData int; SET @Found

SSRS 2008 Conditional Column Visibility Whitespace Issue

Hi Everyone,I am using IIF statements to show/hide tablix columns based upon a parameter value. These statements are used as expressions in the visibility properties for the columns.If the parameter value is one that causes the column to be hidden, the coulmn does not appear on the report, but there is whitespace in its place.I have used this functionality very frequently in SSRS 2005 without the whitespace issue. The 2005 report automagically closed this whitespace up by moving the column to the right of the hidden one to now be adjacent to the column to the left of the hidden one at rendering. This is what i need to happen now in 2008.Has anyone else experienced this? If so, would you please share your solution? I am getting extremely frustrated by this...Thanks!!

SSRS 2008 Paging Issue 0 of 0

I have several reports that are many pages long when rendered in visual studio, but when rendered on the web client it show pages 0 of 0 with the next and last buttons disabled. Only the first page is displayed but if I export to any format it renders all the pages correctly. Please help!

SSRS page break issue

Hi, I am using SSRS 2005. I have developed a SSRS report which prints multiple invoices, having invoice numbers and the parameters. The report is printing multiple invoices having page break after each invoice ends. But there is a header and body section. The body section contains the line items. The issue is after the header part the body part is moving to the next page for some invoices. When the line items are less, it is printing contineously after the header. If the line items are more the whole body is moving to the next page. When I try to fix this issue, some records are printing in the same page of the header and only last record is printing in the next page leaving a long blank in the first page of the invoice. I appreciate any one can solve this issue and it will be really helpful in solving this issue. Thanks , Mahalingam

SSRS 2008 web portal issue, urgent!!

I created a report using reporting services 2008, now I want to upload the report into the web portal so that users can start running the report from the web browser. When I opened the http://server1/ReportServer url from the browser, I just see the below, I installed full version of reporting services 2008, so I am trying to figure out what piece is missing from the installation. Please advice. Thanks. server1/ReportServer - / --------------------------------------------------------------------------------       Friday, January 02, 2009 4:15 PM        <dir> Data Sources    Tuesday, January 20, 2009 10:13 PM        <dir> HR      Friday, January 02, 2009 4:15 PM        <dir> Accounting --------------------------------------------------------------------------------Microsoft SQL Server Reporting Services Version 10.0.1600.22 sqldev

SSRS Report issue blank page is coming

I have a report with 2 pages, some time the second page doesnot contain the data at that time i want to get only 1 page report. but as of now if second page does not have data it is coming as blank, can anyone help on this. I am using ssrs 2008Jeeva Jacob

SSRS Issue with reloading Report

Dear all, I have developed a couple of reports and could deploy them to different servers. All reports are working fine at all servers and test computers, however I cannot reload any of the reports on my own PC. I tried with IE7 and IE8 but nothing. Scenario: 1. Go to the report 2. Run the report 3. Change any of the paramters 4. Press View Report Button 5. No reloading nothing changes.   It seems like the system could not pass the new parameter value.   Could you please help me out? Thanks in advanc, Zoltan

SSRS DataSource as XML (Using WebService) Error: Credentials

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. :)

SSRS IIS Permissions issue

SETUP: We have a server that runs SSRS and is also our webserver. Our reports are set up in two ways, one so that everyone can see some of the reports and a few are locked down so only admins and specific users can see and run the reports. These are set on the http://server/reports site under the security task on the report.  Issue: Some bright spark decided to change the permissions in IIS since then users can only see the "one to all reports" and not even admins could see the "locked down" reports. So not knowing much about IIS i tried to get the sites back to how they were by fiddling around with the Anonymous access and the windows authentication  on the properties on the default website, the reports site and the reports server site. I finally managed to get the users access though the reports server site but not the reports site as it has a better interface. I suddenly though of what i thought was a good idea and copped a backup to oversight the files within the sites forgetting that copy paste dosnt overwrite the permissions and now I dont have access to any site. Is there an easy way to set the permissions back to where they were and to get the sites back up.  Thanks

SSRS Report rendering issue


Hi All,

i have a chart report and deployed in server and created a subscription for sending email with webarchive type. I can see the chart in out look and it is perfect. when i see the same report in blackberry the fonts are not showing properly(blured).

I have tested via attachement as a pdf file then i can see the clear report in both outlook and blackberry but when make a mode as webarchive i getting the font problem in blackberry.

I am looking for the solution.





- Thiru

SSRS in place upgrade from 2005 to 2008 issue


I did an inplace upgrade of SSRS 2005 to 2008 and now the reports are throwing the following error. The reports were all working fine and there is a datasource with the name 'Data Source Name' without the '_'.  Please help.

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

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