SQL Reporting :: Computer Name Could Not Be Obtained?
Jan 29, 2010
have to support an application which has been developed by another developer who is not with our company. When I run the localhost application http://localhost:8080/ReportServer/Pages/ReportViewer.aspx? from my server, it works fine but when I enter http://ipaddress:8080/ReportServer/Pages/ReportViewer.aspx? from another computer, it throws an rsInternalError 'Computer name could not be obtained.'I have other aspx pages hosted on my server and am able to access those pages from the other computer by entering http://ipaddress/kt/Default.aspxI am a total newbie to SSRS.
I am trying to find the MAX number from a database field,The query below returns me the maximum value if i run it in SQL Enterprise Manager but i am not able to print the value in numbwe. Please help me to print the MAX value obtained from the database.
SqlConnection MyConnection = new SqlConnection("Data Source=localhost;Initial Catalog=hcgoa;User Id=sa;Password=;"); SqlCommand MyCmd = new SqlCommand("SELECT MAX([no]) AS Expr1 FROM jmain", MyConnection);
I am running a website from IIS on one computer and I want to view the web page on another computer. the only way I can do this is by using the ipaddress of the computer with IIS on it but would rather have a url. How can I generate a url or use a domain name from [URL]. I signed up for an account on that website but dont know how to use it. I dont know how to configure it.
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?
I 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.
I 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.
I 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.
i'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.
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.
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.
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 ?
We are running sql server 2000 with reporting services version 8.00.743.00. Yes, I know it's old, but it works. Anyway it worked up until a week ago. Now when you try to render a report on IE 7 or 8 or Firefox, the windows authentication appears multiple times. The report continues to render fine in IE 6.
I have a SQL Server 2005 database with Windows Credentials. I am trying to pass my credentials from Visual Web Developer to my report but it returns me: "Cannot create a connection to data source". My web application is based on Windows login as well.
I know it sounds weird and unusual but I have got a requirement like this: I want to know how I can run an exe or take some control of a user's computer. Please note that when I say user computer I mean only 2-3 computers on which I have admin privileges.
So, the complete requirement is that I have to control other computers for which I have admin user and password in asp.net.
I have a problem in deploying the reports. when i try to deploy the reports it shows that Report Sever not working but when i try to start my SQL Server Reporting Services will get the below mentioned error so please can one could suggest me on this.
"Could not Start the SQL Server Reporting Services (MSSQLSERVER) service on local computer
ERROR1053: Service didnt respond to start or control request in a timely fashion"
I am truying to work in my PC with reporting services 2008, but I got this message:
The report server can not decrypt the symmetric key used to access sensitive or encrypted data in a database server reports. You must restore a key from a backup or delete the encrypted content.(RsReportServerDisabled) .
Please suggest me some good reference for learning RDLC reports. Does it provides all the features as provided by BOE3.1(Business Objects Enterprise 3.1).
I have a requirement to create a XML file from sql server data.I need to schedule this job to run at specific intervals of time.I don't know, if I could do with Reporting services.I would like to know, if it's possible with Sql server reporting services? how to do that.
