The ssrs tag has no wiki summary.
-6
votes
0answers
23 views
please help me to solve this proplem [closed]
Microsoft Report Designer
Could not connect to the report server http://'localhost:80'/ReportServer. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to ...
0
votes
1answer
27 views
SQL Server with one ethernet output and Webserver with another ethernet output
Scenario:
I have one server which is virtualizated using VMWare ESXi. Specs:
Windows Server 2008 R2
SQL Server Standard 2012
IIS 7.5
Hosting a MVC and a Webform application (using Reporting ...
0
votes
0answers
20 views
Publishing BIDS Report to SSRS?SharePoint
I am having an issue deploying a report from BIDS to a SharePoint Integrated Report Services Server. I have set up SSRS and everything is successful from the configuration wizard, I am using a Domain ...
0
votes
0answers
41 views
Layout of reporting services site looks odd [closed]
Logged into our SQL Reporting Services 2012 site today and it is appearing like this
This is an almost brand new install on Server 2008 R2 and it was working previously.
Any ideas what might have ...
0
votes
1answer
137 views
Can't connect to SSRS Report Manager: Insufficient access
I'm trying to access the report manager, which in my case is located at http://localhost/Reports. When I try to go there I get the following error:
User 'ComputerName\UserName' does not have ...
0
votes
0answers
18 views
Content Types in SharePoint all point to same document
Something got screwed up with my site templates. Now any template that is a document points to the same Word document. The ones I'm specifically referring to are the SQL Server Reporting Services ...
1
vote
1answer
172 views
SSRS 2008 R2 domain user assigned for role but cannot access
I have SSRS 2008 R2 installed on my server and need to deploy report from Business Intelligence Studio at another computer which is in the same domain and under domain user (non-administrator).
First ...
0
votes
0answers
132 views
SSRS ReportServer on localhost does not open on IE but opens on Firefox
I have two development virtual machines with Windows 7 32 bit on Virtual Box, with SQL Reporting Services (SQL 2012 Express) and IIS 7 installed. I am using some custom deployment scripts for rs.exe ...
-1
votes
1answer
255 views
Licensing SQL Server 2012 Reporting Services w/ SharePoint 2010 [duplicate]
Possible Duplicate:
Can you help me with my software licensing issue?
Here's my situation:
I have 1 VM that is running SharePoint 2010 SP1. I have a different physical server that is ...
0
votes
0answers
251 views
exec permission denied on xp_cmdshell
I want to use xp_cmdshell in a report on SQL Server Reporting Service (2008 R2). I activated the feature on the server, and I am able to call it successfully in the SQL Server Management Studio. ...
0
votes
0answers
165 views
SSRS 2005 Doesn't Know Me
I can't seem to resolve this error
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'MyDataSource'. (rsErrorOpeningConnection)
Login ...
0
votes
1answer
45 views
Report Server pointing to another Reporting Server
I am trying to configure a public facing Reporting Server, which is actually talking to a private Reporting Server backend. I have established the connections between the two of them, but I cannot ...
0
votes
0answers
43 views
Consolidate SQL Server Reporting Services
I've been a big fan of consolidating as many DB's to a few SQL servers for a while and I've had great success with it. However, I've never had to deal with SQL reporting services. Has anyone ...
0
votes
0answers
75 views
Report Builder 1.0 - How to set reports description property
Using SSRS Report Builder 1.0 is it possible to set a reports description property?
I can navigate to the report via the report manager ie http://server/reports -> manage report and set the ...
1
vote
2answers
125 views
Which Service Account should I use in SSRS?
I'm a newbie in SSRS, so my experiences are limited in this topic. In the SQL Server Configuration Manager, there are several options to set the Service Account. I have the option to either use a ...
2
votes
1answer
209 views
Cannot log in to SSRS 2012 using any account
I have installed SQL Sever 2012 along with Reporting Services.
I have configured Reporting Services using the Reporting Services Configuration Manager. It seems like the service is running properly, ...
1
vote
0answers
152 views
Issue with Reporting Services - rsreportserver.config is denied
Error message is 'd:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.'
I open SSRS configuration and I do see the service as started and ...
1
vote
0answers
79 views
Deploying reports to report server
I posted this question on stackoverflow, but I think it would be better here.
I configured SSRS 2008 on a remote server running under Network Service. I can access the report manager from my local ...
0
votes
1answer
507 views
How do I diagnose my poorly-performing SQL Reporting Services 2005?
I have a Windows Server 2008 R2 server running MS SQL Server 2005 and SSRS. The server has 48 cores and 128GiB of memory.
The IIS worker processes and reportingservicesservice.exe never get over ...
1
vote
0answers
364 views
Disable Cache in SSRS 2008 R2
This is a problem that occurs for our IE 8 users (does not happen on IE 9). When rendering a reporting services report IE 8 caches the report so if the data is changed and the user re-runs the report ...
2
votes
0answers
140 views
SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created
I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on ...
1
vote
0answers
66 views
Sharepoint Reports on Mac
When trying to view Sharepoint Reports, Mac users get the error "An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for ...
1
vote
1answer
170 views
One Way Replication of Oracle 11g to MSSQL 2008R2
We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS.
What is a good method to automate a one-way, read-only ...
2
votes
2answers
355 views
Sharepoint Reports do not work in Firefox
Using SSRS in integrated mode, Reports can be viewed in IE but not in Firefox, Chrome, Safari, etc. They get "An unexpected error occurred while connecting to the report server. Verify that the ...
0
votes
1answer
200 views
How can I get Visual Studio to deploy to SSRS named with CNAME instead of A record?
We have SSRS (SQL Server Report Service) running on an Amazon EC2 instance.
It had been named report.foo.com using an A record. Recently we changed it to a CNAME referencing the EC2 public DNS name. ...
0
votes
2answers
812 views
Adding, removing or editing permissions of a user in SSRS 2008 is throwing error “”Response is not well-formed XML
I am totally stumped by a really stubborn problem: When I try to take any action (add, remove, edit) in the Security tab of a report's Properties page on SSRS 2008 UI I get a generic error. All it ...
1
vote
2answers
1k views
Accessing SQL Server Reporting Services by Non-Admin Accounts
When accessing SQL Reporting Services Report Manager through Great Plains 2010, we're getting the following:
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
...
1
vote
0answers
738 views
reporting services 2008 R2 shows UAC for printing ActiveX after .NET 4.0 installation
Installed the latest updates on the server.
Now every time I try to print from a reporting service website the UAC opens..
I already tried to reduce security within IE9 to the minimum, but with no ...
0
votes
1answer
420 views
Date parameter format problem
On a report parameter of data type DateTime, when I select a date using the date picker, it uses my local format (dd/mm/yyyy), but then I get an error that the value is not valid for the data type, ...
0
votes
1answer
228 views
No Reporting Server connect option in SQL Server Management Studio 2008 Express
I'm trying to connect to our SSRS reporting server, but in my local SSMS, the Connect drop-down on Object Explorer only lists Database Engine and SQL Server Compact. I only installed SSMS this week, ...
3
votes
1answer
3k views
SSRS report “unable to load client print control”
We're using SQL Server 2008 for a (third-party) web app, and they utilise SSRS for reporting.
Recently, so I'm assuming this is related in some way to an MS patch, whenever we click on the "print" ...
1
vote
1answer
200 views
MSSSQL: SSRS, SSAS, SSIS edition
How can I know which edition of SSRS, SSAS and SSIS service is installed on a server?
Finding database edition is easy but how to find edition for other SQL services?
Any help please?
Thanks in ...
0
votes
1answer
426 views
Reporting Services 2008 SSRS usage metric reporting
We use web trends to track the usage of our web sites, but web trends is currently not capable of reading the logs produced by SSRS 2008. Has anyone figured out a way to modify the file so that web ...
0
votes
1answer
389 views
SSRS report font problem on deployed reports
I have created several reports for my SQL Server Reporting Services 2008 SP2 server, using Visual Studio 2008 on my machine.
The reports objects all use Arial as their font, in various sizes and ...
1
vote
3answers
851 views
How to make SSRS 2005 run fast in general?
Are there any general rules/tips which we can use to run Sql Server Reporting Services 2005 reports faster?
I have been tuning the Tsql behind the reports but does there exist any SSRS specific ...
0
votes
1answer
729 views
How do I automate the deployment of an SSRS 2008R2 server?
I’m trying to write an automated deployment script for SSRS, and I can’t seem to find any information on how to automate the process of configuring the server after a Files-Only installation. I have ...
1
vote
2answers
582 views
Transaction log shipping SQL Server 2005 to 2008
I have a reporting setup with SSRS on our SQL Server 2005 database. Because SQL Server 2008 is not supported by the main program which populates our database we are stuck with 2005 on our production ...
0
votes
1answer
2k views
Configure SSRS 2008 on Windows Server 2008 R2 - Blank Page
I think I have everything set up for reporting services to work.
But when I go to the report manager URL it just says "home" at the top, and there are no options to click properties,etc. The page is ...
3
votes
4answers
2k views
Windows Server 2008 R2 - How do I change IIS Settings?
I think I've looked through all the menus and control panel and I can't find anything to configure IIS.
I feel like IIS is already installed because SQL Server Reporting services has a webpage ...
0
votes
1answer
1k views
Can't find IIS manager on SQL Reporting Services 2008 machine to setup FQDN
I've got a machine that I inherited that runs SSRS 2008. I can't seem to find IIS anywhere on this machine, yet it's serving up content over port 80. I look under services and there is no WWW ...
0
votes
1answer
170 views
A different interface for the Sql Server Reporting Service?
I have a SQL Server 2005 SQL Reporting Services implementation. It seems that the only way to actually access the reports is for the users to use Internet Explorer. The web page uses an ActiveX ...
1
vote
2answers
497 views
How do I give a user permission to install Report Builder from Report Manager? (SQL Server 2008)
By default, users do not see the "Report Builder" button on the Report Manager toolbar in SQL Server 2008 (R1). How do I give the user permission to use the Report Builder?
0
votes
1answer
293 views
SSRS 2008 Resuming from Sleep
Does anyone know a way to prevent SSRS 2008 from sleeping, after not being used for a while (not sure of the time-out) it takes quite a while to wake up, which is causing a timeout issue?
0
votes
1answer
408 views
SSRS/Sharepoint - Reports made in Report Builder not being list in Sharepoint Web Part
I followed the steps here to integrate reporting services with sharepoint in native mode.
I made a page in Sharepoint with the report explorer web part and everything is working.
The issue is when I ...
1
vote
2answers
156 views
Configure SQL server reportign service to send email
I'm configuring SQL server 2005 reporting server to send emails outside the domain. I have followed the steps outlined at MS but have a question:
How can I supply a domain user to connect to the ...
1
vote
1answer
849 views
Sharepoint and SSRS Native Integration - Not seeing web parts after cabinet file install
I followed the steps here to set up Sharepoint integration with reporting services (SSRS) using native mode. (i.e., get a report explorer and viewer web parts)
However after adding the cabinet file ...
1
vote
1answer
1k views
How to Integrate Sharepoint with Reporting Services in Native Mode?
I'm trying to do something like this but with native mode (less integration).
All of the directions I can find tell you how to set up Sharepoint integrated mode but I need to find out what the steps ...
1
vote
1answer
4k views
SQL Server 2005 Reporting Services - Configuration Manager & Management Studio Problems
When I open Reporting Services Configuration Manager on my server, an error message appears that says:
Reporting Services Configuration Manager
An unknown error has occurred in the WMI Provider. ...
0
votes
2answers
452 views
Upgrade MS Sql Report Server 08 for Dundas charts
We have ms sql server 2008, however the new dundas charts are not available on the report server. How do I upgrade the report server so it gets the new dundas charts as well. Dundas charts are a part ...
0
votes
1answer
547 views
SQL Reporting Services with SSL exclusively
I know how to add an SSL cert to SSRS 2008. Is there a way to force SSRS to use SSL (port 443) exclusively? Right now it will respond to both encrypted and unencrypted requests.
IIS has the Require ...
