I looked online and couldn't find anything to help me make this change. I want to change the default URL for reporting services to another url. Is this possible? Any assistance would be greatly appreciated.
View 3 RepliesHi,
It has been one week I am researching this issue on internet and trying everything I find. But no luck. What I am trying to do is to install SRS on SQL 2005 Enterprise Edition. The reporting services configuration tool has "All Green" check marks. When I browse either of http://localhost/Reports and http://localhost/ReportServer it prompts for password. I am logged on to domain administrator account, I have tried all users' passwords it gives 401.1 error.
I have tried accessing it from another machine or by using loopback ip or machine name; it doesnt work.
Would somebody have any clue to it ?
Thanks,
Fahad
Hi, I want to modify the layout and stuff of the main reporting page...but I'm not sure how to open it ... is there a project for it that gets installed on the server?
I've seen some video demos on the microsoft site and they had some pretty nice front ends set up. I'd like to put some actual metrics on that front page and set up some links and different layouts.
Can someone please at least point me in the right direction to do this? I'm hoping it doesn't require setting up an entirely new site from scratch.
Thanks,
Roxanne
I have just upgraded from Report server 2005 to 2008 r2. I have a program that calls the report server to run some reports but I have getting the error Server did not recognize the value of http header SOAPAction:
[URL] .....
I can log in to the report server and run any report that I want without any issues.
Hi there
Just trying to get a URL which will when i type in
http:\reports
will get me the destination off http:\reports
eportsfolderhome.aspx
I implemented a http header for my server called reports and put the ip address in the hosts file..
when i type in http:\reports
eports it works
however how will I get it too work by just typeing in http:\reports ?
anyone tried this before ?
thanks
We built our prod server [vm] with SQL Server 2008 R2 on Server 2008 R2. It works nicely. Then we made a copy of the VM and renamed it (so our test environment would be IDENTICAL to production). After that, SSRS was broken: I get "HTTP Error 503. The service is unavailable." I can't connect via http, or SSMS.
We have tried:
* Running SSRS config tool (several times)
* Running with/without the IIS Server Role
* Dropping & recreating the SSRS keys
* Recreating the ReportServer database, etc
* Checking all of the accounts, permissions, etc
* Running SQL Repair
* Going through the registry to fix any references to the machine's old name
* Uninstalling, reinstalling SSRS
* Completely uninstalling ALL of the parts of SQL Server 2008 R2, deleting all directories, removing references to SQL Server from the registry, rebooting, reinstalling everything.
None of this has worked. SSRS [R2] is still 503 on our test box.
the SSRS [NT] service seems to run, without error. The Event Viewer doesn't seem to be recording any errors. The SSRS logs say that the default URL is wrong, but we get the same error in Prod, and Prod works fine. The other SQL Logs say something about not being able to contact the service. However, as I said, the [NT] service seems to be working fine.
Sorry for the long post, but I'm trying to include as much info as possible.
I'm having trouble getting SQL Server 2005 Reporting Services and MOSS 2007 working together in integrated mode. Everything seems to be ok, but we get a 'HTTP 401 Unauthorized' error when using the 'Set server defaults' link from MOSS 2007 Central Administration. None of the other links give this error, but I'm not sure whether MOSS just eats the error message...
Here's the background:
Sql Server 2005 is installed on a separate box, let's call it SERVER1. This Sql Server hosts both the MOSS content database as well as the reporting services database.MOSS 2007 is installed on a different box, let's call it SERVER2I've installed all the required components for both boxes with no installation errorsSSRS seems to be running fine on SERVER1. Report Manager can be used directly with a browser in native mode.SSRS also *seems* to be running fine in Integrated mode, i.e. I can create a reporting database for integrated mode:
The url http://host/ReportService/ReportService2006.asmx responds normally when I access it through browser using my domain credentialsThe url http://host/Reports/ returns a message saying that I can't access it in integrated mode, which, I take, is normal
MOSS is running ok on SERVER2
I can see that SERVER1 is in the same farm after I've installed WSS3.0 on SERVER1Also I can see the "Reporting Services" section in Central Administration
So all in all, everything seems to be ok. However, when I try to use the 'Set server defaults' link from MOSS Central Administration I get an 'HTTP 401 Unauthorized' error. I'm assuming clicking this link will result in MOSS calling the Reporting Services' SOAP endpoint ReportService2006.asmx which now seems to be the culprit. Here's why I think so:
Whenever this occurs, the IIS logs on SERVER2 show that someone from SERVER1 is indeed trying to connect to ReportService2006.asmx, but I'm not seeing any user credentials being passed (whenever I access the asmx through my web browser, the credentials I entered in the browser are recorded in the log). Furthermore, the Event Viewer on SERVER2 shows Audit Failure (code 529) events occurring every time I get the HTTP 401 error.
The Event viewer's message is as follows:
Logon Failure: Reason: Unknown user name or bad password User Name: Domain: Logon Type: 3 Logon Process: Kerberos Authentication Package: Kerberos Workstation Name: - Caller User Name: - Caller Domain: - Caller Logon ID: - Caller Process ID: - Transited Services: - Source Network Address: <SERVER1 IP> Source Port: <PORT>
From the Event Viewer message and the IIS log it would seem like my MOSS is trying anonymous access whenever it tries to access the SSRS SOAP endpoint, which of course results in a 401, since anonymous access is not allowed. Please note that if I enable anonymous access in the Reporting Services' virtual directories (just for testing), I get a different error. This indicates that the HTTP 401 indeed originates from this particular web service call.
I've heard that SPS2003 and Reporting Services don't like each other on the same box, but this is hearsay. Does anyone know if this is a confirmed fact? This box does have SPS2003 and SSRS2005 installed. I tried to uninstall the SPS2003 but that didn't help anymore.
I noticed someone having similar issues in another thread, but I
didn't see resolutions. I'm pretty baffled as to whether
this is a problem with the MOSS Add-in or the Reporting Services
installation.
Any input on this issue is very much appreciated. I'll try to also include a follow-up if we're able to get this working ourselves.
Hi,
I have deployed the reports to the report server(centralized server). when i try to access the reports directly thru report server i.e http://servername//ReportServer in my local system. it asks for the username/password, when i give the username and password it accepts and shows me the report.
the same report i try to access in .NET Application, i do not know how to pass the credentials and it throws the error :"The request failed with HTTP status 401: Unauthorized ".
I am using VS 2005 and SQL Server 2005 and SQL Reporting Services 2005.
with regards
Suresh Babu
How to enable http for SSRS service in my current sharepoint 2013 environment with https.
this is needed as we have a limitation in SSAS: We cannot specify HTTPS in the Analysis Services Report Action.
We are using SharePoint 2010 integrated with Reporting Services 2008 R2. We have successfully configured RS and we are able to create RDL reports using Report Builder from the SharePoint site.
However we are getting following error message when we host same RDL report using Report Viewer control in an application page i.e. ASPX page:
<ERROR>The request failed with HTTP status 401: Unauthorized</ERROR>
We can fix this issue by setting:
1) setting impersonation to false in web.config file:
<identity impersonate="false" />
2) Setting Report server URL to _vti_bin path:
rptViewer.ServerReport.ReportServerUrl = new Uri("http://sharepointserver:1000/_vti_bin/reportserver");
If we turn impersonation to true we get the same error. Other project module requires impersonation to be enabled. Hence we cannot proceed further with this work around/fix.
I am using SQL Server Reporting. All reports are deployed on REPORTING SERVER.
I want to implement security roles as same as in Active directory. Currently reports are being accessed using Anonymous user setting in IIS.
I have added users in SQL Server security as well as data base level. But when user accesses report following error occurs:
The request failed with HTTP status 401: Unauthorized
Please reply with solution as soon as possible. I will be very thankful to you
Hi I have problems when I try to see http://localhost/Reports/ send the follow message:
Failed to access IIS metabase.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase.
The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see http://support.microsoft.com/?kbid=267904.
I tried diferent commands
aspnet_regiis -u
aspnet_regiis -i
aspnet_regiis -ga ASPNET
that I found in the web but the problem is the same.
Someone can help me please?
Thank you.
(in swedish)
http://localhost/reports gives :
Ett namn inleddes med ett ogiltigt tecken. Det gick inte att behandla resursen http://localhost/reports/. Rad 1, Position 2
<%@ Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePag...
default installation. Even tried to reinstall all with the same result
Hints?
/Allan
OK
solved by further searching on msdn:
"problem loading report manager: The XML page cannot be displayed "
This is the error I get:
Object not found!
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.
If you think this is a server error, please contact the webmaster.
Error 404
localhost
Thursday, February 15, 2007 12:50:47
Apache/2.0.54 (NETWARE) mod_jk/1.2.14
Hi all,
When I build a simple project using the report wizard project.
When i deploy the report i get the following error.
TITLE: Microsoft Report Designer
------------------------------
A connection could not be made to the report server http://localhost/ReportServer.
------------------------------
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<?xml version="1.0" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>Server Unavailable
</title>
</head>
<body>
<h1><span style="font-family:Verdana;color: #ff3300">Server Application Unavailable
</span></h1>
<p>
<span style="font-family:Verdana;">
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
</span></p>
<p>
<b>Administrator Note:
</b> An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
</p>
</body>
</html>
--. (Microsoft.ReportingServices.Designer)
------------------------------
BUTTONS:
OK
------------------------------
Could some one come to my rescue.
Thanx in advance.
Ronald
Hello all,
I'm using SQL Server 2005 SP 2 with Reporting services and MS dynamic CRM 3.0.
During the installation of CRM, a lot of Reports are deployed to the ReportServer.
I can connect to the ReportServer over http://myserver/ReportServer, can walk through the folders and select the wanted Report, but I only get the header of the Report without the Action Icons and Data!
If I use http://myserver/Reports, the selected Reports works very well.
Has anybody an idea what is happen?
hi
when i try to browse to http://localhost/Reports or ReportServer, a login is prompted. I don't know what to fill in there. Should it be configured somewhere?
Or should I configure the Reports and ReportServer in IIS to allow anonymous logins?
- if i do this, I can see the homepage of reports, but noting is listed
- if i browse to reportServer, i get the error "he permissions granted to user 'EVO610IUSR_EVO610' are insufficient for performing this operation. (rsAccessDenied)"
Can someone please urgently help me? I don't know where and to configure this login prompt.
Hi All,
I have setup SSRS 2000 and gotten it to work but I am having trouble with SSRS 2005. I can't access to reportserver anywhere on the network. The only way to get to reportserver is termserv into the server and hit it with http://localhost/reportserver The server is Windows 2003 server Standard Ed. running SQL 2005 SP2 and Sharepoint Portal Server 2007. Can somebody please help? Thank you.
Does anyone have instructions on how to configure http access to SQL Server 2005 Analysis Services on Vista?
View 5 Replies View RelatedHi -
I got through the installation hoops for SQLEXPRESS Reporting Services in Vista and set up the default configurations in Report Services Configuration. I can explore the default directory for "Reports" in IIS7, but I can't browse in IE. I get the "The report server is not responding. verify that the report server..." message in the browser. This is after I migrated the app per the initial http 500 error using the preferred method - %systemroot%system32inetservAPPCMD.exe migrate config "Default Web Site/Reports".
I'm running Vista Ultimate, VS2005, SQLEXPRESS SP2. I've tried running IE as admin and also I've disabled UAC from gpedit.msc - ...Windows SettingsSecurity SettingsLocal PolicySecurity Options and unchecking UAC.
Thanks,
Mike
There was a 2008 SSRS service running on server "abc".
I have a .Net UI that uses the wsdl at [URL] ....
They deployed SSRS 2012 service on a new server "xyz".
DNS points abc to xyz. Nslookup looks right shows both xyz and abc alias to the same IP.
when I try to go to [URL] .... it redirects to xyz as expected for the host name but the HTTP GET /ReportServer is appended with GET /Reports/ReportServer which doesn't exist and I get an 404 error.
I have no admin rights to see anything and I have no idea if it was an inplace upgrade or a new server. I assume it's new since the actual server name changed in nslookup. Why would it append the default virtual directory when it makes the hop to server "xyz"?
Hi,
I am new at using Report Service and after successful install the SQL SERVER EXPRESS ADVANCE SP2 and configured the ReportIing Services Configuration. I try to launch the report manager by typing http://localhost/Reports I get the following error:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I've read many forums but I couldn't resolve my problem. Any help would be greatly appreciated.
By the way, I am running IIS 7 on Window Vista Business Ed. & SQL Server Express Ed. I am not sure if this make any differences.
Hi all
After deploying my report on the report Server, I try to access it on the browser which gives me the following error.
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
A name was started with an invalid character. Error processing resource 'http://localhost/reports/Pages/Folder.aspx'. Line...<%@ Page language="c#" Codebehind="Folder.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.Folde...
How can I trouble shoot this error.?
Please help me out.
Thanx in advance.
Ronald
my analysis server is hosted on a win2k server with IIS, the hosting page ison another machine. I have followed everything as per MS KB article and Icould not connect through the analysis server using http. i have similarimplementation on my dev machine but the main difference is my OLAP is ontop of winxp. i just wanted to know if i am missing any other setting notspecified on the MS KB article on how to implement OLAP cube through HTTPover win2k operating system.note: i tried connecting to olap using the MDX sample application usingMSOLAP.2 provider and connecting through a simple office web component. Ithink the best way to test the connection is through the MDX sampleapplication that comes with Analysis Server installation.
View 2 Replies View RelatedI know that SSRS default rendering formats is HTML. is there anyway we can change this behaviour to render in XM format for specific reports.
View 5 Replies View RelatedI have the following setup
Machine 1
WSS 3.0
Installed Reporting Service Add-in
Machine 2
Reporting Service
Sharepoint Object Model
SQL Server
Sharepoint and Report Server DB
I have congigured Reporting Service for Sharepoint Integrated Mode adn Created new Reprot Server DB
Sahre Point Integration is Green and verified link
In Sharepoint Central Administration
Manage Reporting Service Integratio i have selected the URL and "Trusted Account" as my web applications use "Windows Integration - NTLM".
All services, DB access everything running under one domain user account.
I am logged into sharepoint with same account. When clieck on set server defaults i get following error
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized.
Same error when i try to add a report to a sharepoint webapplication
The domain account is part of "Farm Administration", "site colletion administrato" and local administrator also on both servers.
Can someone let me know how to fix this.
during period of troubles connecting to Local Servers and Sites location i.e., to [URL], the place where all Reports are saved by default, I have continued to work on some Reports that have been saved to file system of my localhost/developing machine. But, upon recovery of http location, I can not see/open those files?
how to approach those files in order to open them in Report Builder 3.0 and thus, to "save as" them to the http location? Seems that Report Builder has chosen that location, by default, somehow.....
I know parsing json data has been discussed lots but what I want is probably a little simpler or different:
I have a URL where I can open and get the Json data.
I need to parse and load the Json data into a SQL table, and I want to use it in SSIS, not using C# or VB.NET coding.
I am on Visual Studio.NET 2008 and SQL 2008R2
Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
Hal1490
Hal9000
Hello SQL gurus.
I just wanted to kmow if we can connect a SQL server DB , located at some remote geographical location, via HTTP protocol.
Thanks in advance.
Ankit
Hi there,
I want to access to sql server 2000 on localhost with http
.Following instructions on "Sql Server books online", If I perform on Window Server 2003 R2 operating System, the result was not unsuccessful. However, on Window XP, the result was successful.
hello, i have this summarized stored proc. Problem is, when using'Send', my aspx page reads (asp.net)Request.Form as emptyHowever, when I use a simple html file to post, it works. Does anyoneknow what's wrong?EXEC @iHr = sp_oaCreate 'Msxml2.ServerXMLHTTP.3.0',@iObject OUTPUTdeclare @data as nvarchar(max)set @data = 'boo=yeah'EXEC @iHr = sp_OAMethod @iObject, 'Open', null,'POST',@smtpWebService, 0EXEC @iHr = sp_OAMethod @iObject, 'setRequestHeader', null, 'Content-Type', 'application/x-www-form-urlencoded'EXEC @iHr = sp_OAMethod @iObject, 'send',null,@datawhile @State<>4beginexec sp_oagetproperty @iObject, 'readyState', @State outputendEXEC @iHr = sp_OAGetProperty @iObject, 'responseText',@retVal OUTprint @retValEXEC sp_OADestroy @iObject
View 2 Replies View RelatedHi
Is it possible to access sql server 2005 via http and do some management and administration task?
Thanks in advance,
Larry