I am getting user name and password promt while trying to access reporting manager URL at a simple test server. and i have tried so many user name and password even of administrator for that machine . but nothing worked for me.also googled it but no success.. and the same thing working on my PC without doing anything EXTRA..Any one master of SSRS ?
View 5 Replies
I have question is it possible to install Report Manager (IIS Service) on different server than Reporting Services is installed? I would like have IIS service (Report Manager) on one server and Reporting Services mechanism on the second one. Do you think this solution is possible?
View 2 Repliesi'm using sql server 2008 with advance services the below error is of reporting services.."The permissions granted to user 'sysnameASPNET' are insufficient for performing this operation. (rsAccessDenied)"when i'm trying to host appliction.. the above error is occured..it works fine when i try to execute locally.. but when i try to execute through the IIS i.e host applicationthe above error is displayed.
View 2 RepliesIs it good practice to add asp.net pages into the Report Manager web app?I would like to add some pages that allow users to manage what is in their multi-select dropdownlists on reports. Unfortunately, i can't host another web app, so i was wondering if i should just embedd pages within the report manager?
View 3 RepliesI have a report with 4 different variables await user input, these variable can be null but the problem I am having is since null is set to the default value for all of the variables the report will automatically generate itself when the user starts it.
Is there a way to halt auto generation so the user just sees the variables and the view report button other than setting one of the variables to not have a default value of null?
I have installed Reporting service 2008 on windows server 2008 which is in domain.In report manager i have created domain user and given browser role. when the specified user access
http://10.20../reportsit authenticated without promting login credentials.the User is also in domian.when the another user which is not added in report manager only getting Home screen.I want authentication propmt to be shown when user access report manager.
I have installed sql server 2008 express and reporting services. After installation of sql reporting services, im not able to see reports related virtual directory in iis and not able to see the report manager.
I have configured the virtual directory through using Report service Configuration tool too but still im not able to run the report manager [URL]. how to run the SSRS 2008 reporting services report manager?
when trying to run sql server report manager on Internet explorer its ok ,but when i try to run it in firefox i get thie exception?Server Error in '/Reports' Application.Access is denied. Description:An error occurred while accessing the resources required to serve this request. You might not have permission to view the requested resources.Error message 401.3: You do not have permission to view this directory or page using the credentials you supplied (access denied due to Access Control Lists). Ask the Web server's administrator to give you access to 'C:Program FilesMicrosoft SQL ServerMSRS10.MSSQLSERVERReporting ServicesReportManagerhome.aspx'.Version Information: Microsoft .NET Framework Version:; ASP.NET Version:2.0.50727.4955
View 1 RepliesI am developing a intranet for our company and right now have a problem on loading my report. I developed my report with Visual Studio 2005 and try to load it with Visual Web Developer. I downloaded ReportViewer as well. My database connection is Windows Authentication also. Here is my code in Visual Web Developer:
Imports Microsoft.Reporting.WebForms
Imports System.Net
Imports System.Security.Principal
Partial Public Class ShowReport
Inherits System.Web.UI.Page
Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
ReportViewer1.ServerReport.ReportServerCredentials = New MyReportServerCredentials()
End Sub
Private Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles form1.Load
Dim strReportURL As Uri
strReportURL = New Uri("http://SERVERNAME/reportserver")...........................
I am not getting data in subreport along with main report, But If I run the subreport alone I am getting data.below is the code which I am using , Please figure out my problem and give me the solution.
rptH.FileName = Server.MapPath(
rptH.Load();
ReportClass rptH =
[code]...
In my report i want the headers to appear on each page when i go
to view the report.
Here are the actions i have done:
1) Insert > Table > Insert New Table on to the report
2) I have then dragged the fields from the dataset on to the report.
3) I have clicked on the Header of the column, then clicked Tablix Properties
I have clicked in the tick box: Repeat header rows on each page.
4) I have also clicked Keep header visible while scrolling.
5) I have clicked ok.
When i go to run the report, i can see all the page headers on Page1. If i go
to page 2 and so on, I am unable to see the headers.
I am calling a report from my ASP web app and was working perfectly, but now for some reason the report is coming up as blank and only shows the header section where it shows export, page numbers etc...The report works 100% direclty from reports and reportsmanager but not from my application - there are no errors to even guide me to solving it.At first i had reporting services 2005 and was having this problem and then i installed Reporting services 2008 and hosted the report on there but i am still getting the same problem.....very frustrating!!Does anyone have any idea what could be causing this??
This might be a clue: this app is on my clients pc and i installed VS2010 on the pc so i can try troubleshoot this but when i open the app VS2010 tells me it is setup to use framework 2.0, strange cause before this problem i opened it in vs2010 and was in framwework 4.0 - but now ifi go to the build dropdown it does not give me the option to select framework 4.0 - just goes up to 3.5??the app was originally created in VS2005 then I upgraded it to vs2010.........it could be possible that there is aconflict with the report viewer on the webpage conflicting somewhere???the app still works 100%(except for reporting) on IIS using framework 4.0 so it is still on the PC..please help - my client is unable to use the app without the printing and i am getting desperate!!Here are the hardware and software details:
-Windows 7 Pro
-IIS 7
-framework 2, 3.5 and 4
-ASP.net 4 Web app developed in VS2010
-DB on SQL 2005 exp adv
-also have SQL2008 exp adv installed
I am developing a site that use ReportViewer to show the users a SSRS report. Basically I have my report uploaded in my SQL Server Reporting Services Server (It is an SQL Server 2008 by the way).I want to set the Report dynamically so I do it this way:
Protected Sub Page_Load(ByVal sender
As
Object,
[code]...
I need to get list of users reporting to a particular manager from the Active directory. In the active directory there is manager property with contains the data in the following way.
CN=Gegore Lid,OU=IT,OU=Sales,OU=XXXXX,OU=XXXX,DC=YYYY,DC=intra
[Code].....
it possible to pass the query dynamically to sql server report from .net or from any other source.
View 1 RepliesAny one used Microsoft Chart Control in SQL Server Reporting Service reports? Specifically the 2005 version?
View 3 RepliesI would like to design master page header to show report title and date. For Master footer page, I want to show address and page number. Thus, all report no need to design more page header and footer.
View 5 RepliesI developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or something missing.
View 1 RepliesI am having an issue where if I click on the print icon in the report viewer embedded in an application, I get the error "unable to load client print control". However, when running through report manager, this is fine. I am running SQL Server 2005 SP3 and report viewer 9.
View 1 Repliesi am trying to call a report with a ReportViewer control using this code:
[Code]....
but i am having this error
Microsoft.Reporting.WebForms.MissingReportSourceException = the source of the report definition has not been specified.
what would be the user name and password of http://localhost/Reports to access SERVER 2005 Reporting service
View 7 RepliesI am new to Sql Server Reporting .How to customize sql server reporting services home page?
Means, how to put some background picture, how to change shapes of Tabs, how to Insert Header Picutre at the top and so on.
I have created a drill down report in SSRS which works fine in Visual studio but when deployed and viewed using a report viewer on an asp.net web page it acts funny. It load fine the first time but as soon as i expand any of the drill downs the width of the report suddenly becomes very! lengthy and the details data disappears.
View 2 RepliesI am trying to implement custom sercurity modal in Reporting Services and i am not successfull. I am getting instance count error at below line.
// Loop through the instances of the server class.
ManagementObjectCollection instances = serverClass.GetInstances();
I posted my question in the below forum and could not get answer yet.
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/81b5a886-cca5-4d13-9805-c5b57c8a20e9
The link i used for forms authentication is as follows:-
http://msdn.microsoft.com/en-us/library/aa902691(SQL.80).aspx
What could be going wrong? Why i could able to cross "scope.Connect();" AND "serverClass.Get();" and getting below error
and could not get any instances. I saw a help link of similar problem and given full permission, but could not get instances at all.
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/fd5d19da-5cf5-45a9-bc77-7849a9565714
Exception Info:-
serverClass.GetInstances() {System.Management.ManagementObjectCollection} System.Management.ManagementObjectCollection
+ Count 'serverClass.GetInstances().Count' threw an exception of type 'System.Runtime.InteropServices.COMException' int
{System.Runtime.InteropServices.COMException}
IsSynchronized false bool
Code:-
const string WmiNamespace =
//@"\localhost
ootMicrosoftSqlServerReportingServicesv8"; // ORIGINAL
@"\localhost
ootMicrosoftSqlServerReportServerv9Admin"; // NEW ONE
//@"\localhost
ootMicrosoftSqlServerReportingServicesv9Admin"; // NOT
WORKING COPY
const string WmiRSClass =
//@"MSReportServerReportManager_ConfigurationSetting"; // ORIGINAL
// @"MSReportManager_ConfigurationSetting";
@"MSReportServer_ConfigurationSetting"; // NEW ONE
string fullWmiClassName = WmiNamespace + ":" + WmiRSClass;
ManagementClass serverClass;
ManagementScope scope;
//scope = new ManagementScope(WmiNamespace, connOptions);
scope = new ManagementScope(WmiNamespace);
// Connect to the Reporting Services namespace.
scope.Connect();
// Create the server class.
serverClass = new ManagementClass(fullWmiClassName);
// Connect to the management object.
try
{
serverClass.Get();
}
catch (Exception ex)
{
throw new Exception("Could not get WMI information. "
+ ex.Message);
}
It seems the Print Icon in Reporting Services is now throwing up a Windows Authentication box. Even when entering my domainusername and password, nothing happens. It just keeps popping up?
Our reporting service URL is a http://IP Address/........
Not sure if that has anything to do with it. We did add the I.P. in the Local Intranet Zones but still nothing works.
