We've recently attempted to get RS 2005 64bit up and running on MS Virtual Server and the installation seems to have worked properly (the RS Configuration all seemed fine also). However, when going to http://localhost/Reports or http://localhost/ReportsServer, it gives me the message "Service Unavailable". Everything looks good in IIS (using 2.0).
What else can I do to troubleshoot this issue?
We have a 64bit installation of SQL Server (SSIS, SSAS) running and working fine. There is a requirement to install 64bit SSRS on this existing setup.
The problem is: While running the SQL Server Setup wizard, the Reporting Services checkbox remains greyed out. In other words, there isnt an option to select SSRS for installation.
So the question is: Is it even possible to install 64bit SSRS on an existing 64bit SQL server installation - given that SSRS wasnt installed during the first pass.
PS: The SQL Server is SP2 on a Windows Server 2003 configured as an App Server.
I just installed the 64bit Vista and than wanted to install the 64bit SQL 2005 Std. Server on it.
Note: I downloaded my license from https://licensing.microsoft.com/eLicense/L1033/ProductDetail.Asp?SKU=228-05338.
Installing from SQLSTDSEL.ISO file results in the warning that for the REPORT- Server the .NET version has to be 32bit.
Stopping the installation at this point and try to install from SW CD SQL Svr Standard Edtn 2005 64Bit X64 English #1 x64 MLF.x11-57664 + SW CD SQL Svr Standard Edtn 2005 64Bit X64 English #2 x64 MLF.x11-57665 does not give the above error but on the other hand installs no server at all since somehow the installation routine is not working at all.
Installing now - after at least analysis server and reports server are 64bit and installed - from the first mentioned ISO results in the installation of the DB- Server.... but as a 32bit installation.
Now I wonder what did not work out - so maybe someone here has an idea if and how this problem is solveable.
Hi
On W2K3 i have this message "Service Unavailable" when i'm trying browse to my Report Manager.
The ReportServer service is started.
What happend?
Thanks!!
I have recently installed SQL 2005 Express Edition with Advanced Services and, after a couple of tries, got everthing to intall - Reporting Services and Business Development Studio. The Report Server appears to have configured correctly (green check marks) except when I go to access the Report Server (http://localhost), I get the 503 Error. I have tried restarting IIS (7.0) and ASP.Net 2.0, to no avail. I am running Windows Vista Ultimate. Everything is on one machine. Thanks in advance for any help.
View 7 Replies View RelatedI did a quick Google for this but found nada...
If I develop a report in SSRS 64 bit, can it be ported to a 32 bit installation? Any issues?
I will do my own testing, but I was curious if anyone else had experience doing this.
Hi All -
There are times when I need to disable Reporting Services, which I do by stopping the ReportServer application pool service in IIS, temporarily. During these times if a user attempts to access reporting services they get the default Sevice Unavailable error message. I would like to create a custom Service Unavailabile message. Does anyone know how I can do this?
hi all,
i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.
===================================
Cannot connect to http://localhost/reportserver.The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
===================================
but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.
do i need to start any services for this...
so anybody knows how to troubleshoot this issue.
Thanks in advance...
Hi:
I wanted to make sure some things clear before setting up service broker. I have enterprise server as 64 bit and local client servers as 32 bit. I would like to know what steps do I need to take care when I am setting up service broker b/w sql server enterprise editon 2005(64 bit) and sql server express 2005 client server(32 bit)...any special considerations ...?
Thanks,
Pramod
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.
I have managed to get the Forms Authentication sample to work bu there is a hitch. I am running Report Server and Report Manager on the same(test) PC. I can logon to the Report Server without a problem but when I try logon from the UILogon.aspx page for Report Manager I receive the following error:
An error occurred while attempting to get the ReportServer Url. The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
An error occurred while attempting to get the ReportServer Url. The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)An error occured while attempting to get the ReportServer Url. The RPC server is unavailable.(Exception from HRESULT: 0x800706BA).
I can register users which suggests that the page can connect to the database.
Any help???
All,
I am looking at implementing some sort of throttling whereby "expensive" reports are setup as Subscriptions (and hence are run by the Windows Service), while all other requests go the Web Service.
My question is:
Do the two systems share any underlying systems? I understand (of course) that they use the same DB, etc. etc. However, I can't quite tell whether there is an underlying engine that is a common base or if they really just spin up different instances of the same objects and essentially each host the application separately?
Any help is greatly appreciated!
Mark
Hi,
Is it possible to call a Web Service using SSRS and bind the dataset to the the table in the Report? Please share your views.
Thanks and Warm Regards
Saanj
Am using the Web service of SSRS to assign the roles for a user (which is already available in Report Manager).
Policy[] p = new Policy[1];
p[0] = new Policy();
Role[] R = new Role[1];
R[0]= new Role();
//RoleGroup Rg = new RoleGroup();
R[0].Name = "Report Builder";
p[0].GroupUserName = "MyMachineNamevikas";
rs.SetPolicies(@"/",p);
The same I have tried with SetSystemPolicy method also.
Policy[] p = new Policy[1];
p[0] = new Policy();
Role[] R = new Role[1];
R[0]= new Role();
//RoleGroup Rg = new RoleGroup();
R[0].Name = "Report Builder";
p[0].GroupUserName = "MyMachineNamevikas";
rs.SetSystemPolicies(p);
Where, MyMachineName - is the machine name where SSRS is residing.
bvikas - windows local machine user
I have used the above codes in achieving the mapping between the SSRS role and the windows local user. Getting error on this. I even thought of directly doing the mapping by putting entry in SSRS database. But found that few fields are encrypted and I would prefer to acheive it through API way.
-Muthu
Bug:
An existing SSRS 2005 data source at the root directory cannot be used by the SSRS SetItemDataSource web method.
Steps to reproduce:
1. On the machine running SSRS 2005, create a folder named Reports and upload an RDL file named "Existing.rdl" into that directory. For clarity the SSRS path to this report is /Reports
2. Set up a valid data source at the root directory (For illustrative purposes we'll name it DS).
3. Set up a web reference to a SQL Server Reporting Web Services 2005. e.g. http://localhost/reportserver/reportservice2005.asmx
3. Try to set the DS data source to the "Existing" report by calling the SetItemDataSource web method.
C# Code Excerpt:
...
try{
ReportingService2005 reprtSrvc = new ReportingService2005();
DataSource[] dsarray;
string reportName = "Existing"
string _selectedFolder = "/Reports/"
DataSourceReference reference = new DataSourceReference();
DataSource ds = new DataSource();
dsarray = new DataSource[1];
reference.Reference = "/";
ds.Item = reference;
ds.Name = "DS";
dsarray[0] = ds;
//Exception thown ...
_reprtSrvc.SetItemDataSources("/" + _selectedFolder + reportName , dsarray);
}
catch (SoapException ex)
{
//Exception
Message.displayMessage(ex.Detail["Message"].InnerXml, MessageType.Error);
}
...
Exception details...
ex {"System.Web.Services.Protocols.SoapException: The operation you are attempting on item "" is not allowed for this item type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "" is not allowed for this item type. at Microsoft.ReportingServices.Library.SetItemDataSourcesAction.ResolveNewDataSources(DataSourceInfoCollection newDataSources, Boolean forModel) at Microsoft.ReportingServices.Library.SetItemDataSourcesAction.SetReportDataSources(CatalogItem item, DataSource[] dataSources) at Microsoft.ReportingServices.Library.SetItemDataSourcesAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetItemDataSources(String Item, DataSource[] DataSources) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetItemDataSources(String Item, DataSource[] DataSources) at Microsoft.ReportingServices.WebServer.ReportingService2005.SetItemDataSources(String Item, DataSource[] DataSources)"} System.Web.Services.Protocols.SoapException
Server Software
SQL Server 2000 (all sps up to date)
SSRS 2000 (all sps up to date)
Scenario:
1 - SSRS + SQL2000 Database server
2 - Web servers
We have installed SSRS on 2 web servers that are acting as a web farm for a central Report Server.
After we installed SSRS on the 2 web servers the scheduled reports on the central Report Server stopped working.
We tried disabling the ReportServer service on the web servers and then the scheduled reports began to work again.
Why would the ReportServer service on the 2 web servers interfere with the central Report Server?
Can the web servers be used to load balance the scheduled reports?
Any advice would be appreciated.
I created two reports in SSRS and have configured both the web service and report manager URLs in report services configuration manager.
whenever I try to open either one of the two reports from the manager or service I get the following error msg.
"An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.
(rsReportServerDatabaseError)
Invalid object name 'DataSets'. Could not use view or function 'ExtendedDataSets' because of binding errors."
I get a similar msg when I try to deploy the reports from VS 2010. Only the first 2 sentences are returned.
I'm mystified as to why DataSets is an invalid object name. It shows as the TargetDatasetFolder name WebsiteReports Property Page. I've looked around for the error source and can not find where this error is stemming from.
Hi all does anyone know where I can find more information on the Render method of the Reporting Services WS?
Specifically there is a DeviceInfo parameter that you need to pass in and it is a string that is in an XML format but I cannot seem to find any documentation on the specifics of it. I have seen a few examples but no specifics.
Any help with this is greatly appreciated?
Thank you,
John
Hi All,
I want to send notification to SSRS on change in database for that I am using SSB to send message to SQL Server Reporting Services.
Can I use SSB and if yes, how? Please guide me I am new to this.
Thanks,
Omkar.
Hi,
Is there a separate service pack 2 for SQL Server Reporting Services 2005? I know there is a SP2 for SQL Server 2005 that was just released. I'm asking because SRS 2000 had a service pack separate from the SQL Server service pack.
Thanks.
Hi frineds,
i created the 1 report with pie chart ,but i am unable to display the values in the pie chart region inside the each colors
i am displaying the marks of a studnet ,but here
just like for each region we need the value HOW TO SET please help me in the properties or else (WHERE ?)
-------------------------
10 (red color)
-------------------------
30 (green color)
--------------------------------
Is there a way to return the fields collection of a dataset using the Reporting services Web Service? I can get to the reports but not the datasets. Thank you in advance for any support you can provide.
View 1 Replies View RelatedHow can I find out if SSRS 2005 service Pack 2 is been installed on my system?
View 4 Replies View RelatedSometimes I have to unlock the account 3 or 4 times a day. This is getting annoying. Why would my service account keep getting locked out?
View 3 Replies View RelatedWe were recently acquired and need to move our existing SSRS 2012 mail server from our internal SMTP service. The internal service doesn't need to have a 'real' account to send email out. Everything seems to be setup and running under the internal service.I think I need to change the Email Settings information in "Reporting Services Configuration Manager". Namely the Sender address and SMTP Server fields. But without actually making these changes, I don't see where it is going to ask for the password. Really hate to make changes on a production server.
Do I need to change the "Log On As" account in the "SQL Server Configuration Manager" as well? If so, does this need to be the same account as used in the Sender Address (above)?. there is a lot of ink about making additions to the "rsreportserver.config" file. Our existing file does not have any of these entries.
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.
I am building a webapp that calls an SSRS instance to display a report based on another servers web service.I can make a call from the ssrs server using this in the RDL:
<Query>
<Method Namespace="http://machine/webservices" Name="HelloUser">
<Parameters>
<Parameter Name="user">
<DefaultValue>Craig</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="true">*</ElementPath>
</Query>
This works no problem. but.. I want to have the user parameter "Craig" be a parameter passed in from the web app. If it were a regular SQL data source you would put @user in the query. How do you do it with XML text queries?
I am facing a problem which is based on the restrictions on the domain of the customer. After deplyoing the report on the server we are getting the following error message in the report manager after executing (clicking) a report link:
Logon failed.
Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)
I googled for that and it seems to be an authentication issue where some user / account is not granted to log on as service / locally, but the problems is better described than the solutions. Did anyone faced that problem so far ? Which account has to be granted what priviledges or permissions in Windows. We are using a SQL Server 2005 / Reporting Services 2005 running on the same machine whereas the virtual directories Reports and Reportserver are running in a separate Application Pool
Thanks,
Thomas
In one of my projects, i have been using the SSRS web service to render a report as pdf and then manually emailing it out.
I need to know whether the data set for the report returned any data or not (so that i can avoid emailing the report with a blank report body).
Ofcource this can be done by executing the same query (same as the query for the report) from C# code and checking the count of the resultset, before calling the SSRS Render method. But it might not be an efficient method.
Was wondering the the SSRS Web Service provides an property or method that can let me figure out whether the resultset was empty or not (after the report execution).
Thanks.
Is there any example I can find a full feature demo of SSRS Web Service Rendering with Interactive Sort and other features enabled?
For MS: Indeed I think ReportViewer Control should be an open source component as we as developer needs the flexibility to customize the report viewer interface as well as can learn directly from the control source so to understand how can we integrate better with SSRS.
Hello,
How can I stop a report I started by using:
ReportExecutionService rs = new ReportExecutionService()
.
.
.
rs.Render(...)
I need to stop the report when a user clicks a button in my aspx page.
TIA
gad
I am selectively insert data from serverA databaseX to serverB databaseX.
(serverA is linked server on B.)
I could insert parent and child tables. But get error when insert to grand-child tables:
Server: Msg 8501, Level 16, State 3, Line1
MSDTC on server B is unavailable.
Don't think I need to turn on MSDTC on B. But I could copy and paste from source A server to target B server. Confusing on some table could insert while others with error....
thanks
-D
Having to do contigency planning for a log shipping environment. Have the scenario covered for mdf's not being available (on a separate array), or complete server death. But what if the array the log files are on dies? Has anyone had to deal with this? I was wondering if you could just do a full backup of the current DB's and copy them over (I have my log files coming oer about evey 5 minutes) so I am not sure even if I can if I will gain much. Or if you lose your trans logs are you pretty much SOL.
Thanks