Questions tagged [ssrs]

Microsoft's SQL Server Reporting Services (SSRS), which provide "tools and services to help you create, deploy, and manage reports", usually querying MS SQL Server.

Microsoft's SQL Server Reporting Services (SSRS), which provide "tools and services to help you create, deploy, and manage reports", usually querying MS SQL Server.

244 questions
0
votes
1 answer

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 Services) Integration Services is also heavily…
equasar
  • 101
0
votes
1 answer

SQL Error When Running My "Find All Unused Packages" in SCCM 2007 Report Console

SQL Error When Running My "Find All Unused Packages" in SCCM 2007 Report Console Asked by: the_ratzenator I am trying to run an SCCM 2007 Report to find all unused Pacakges in my environment and I keep getting this error: An error occurred when the…
The_Ratzenator
  • 150
  • 1
  • 2
  • 12
0
votes
1 answer

TFS2012 - Reporting Services Permissions?

I'm currently working through an upgrade of TFS2010 to TFS2012. In our old configuration, TFS, Sharepoint, and Reporting Services were on the same server, with the rest of the DBs on a separate SQL server. During the upgrade, we put Reporting…
Jared
  • 71
  • 1
  • 1
  • 3
0
votes
1 answer

Configuring SQL Report Server to work with Team Foundation Server using Internet URLs

Currently we have SQL 2012 with Reporting Services, Team Foundation Server 2012 and SharePoint Server 2013 on our single Windows Server 2012 machine. We are a small company and we have some developers who work from home. We do not have VPN nor…
JustAMartin
  • 231
  • 1
  • 18
0
votes
1 answer

Install SQL Report Server on a separate server using remote instance for dbs

I have been googling a lot to find the installation guide on how to install Reporting Services on a application server, but couldn't find anything. I already have an SQL server on another machine and want to use this server to host the reporting…
Oliver Nilsen
  • 205
  • 2
  • 8
0
votes
4 answers

Automated email reports

I have a VPS with a high loaded website. Are there any automated solutions to send me an email or SMS if my site is not working correctly (for example, web server does not respond or DDoS)?
romvlads
  • 17
  • 3
0
votes
1 answer

SQL Server Reporting Services 2008 Subscription is sent to incorrect email address

When using a data driven subscription to return a list of recipients the emails sent out are addressed to username@mail.domain.com instead of username@domain.com. The query in the data driven subscription picks up the username. How can this be…
0
votes
1 answer

SSRS Security Scheme

I have an SSRS 2008 installation on top of IIS 7 and I need to limit the visibility of certain reports. The reports are deployed under several different folders in the SSRS 2008 instance. Each folder in SSRS is setup with an Active Directory…
λ Jonas Gorauskas
  • 373
  • 1
  • 4
  • 9
0
votes
1 answer

How to configure Reporting server on SQL Server 2008, Windows 7

I want to configure reporting server on sql server 2008.I m using Windows 7 Operating System . I configure reporting manager using Reporting Services Configuration Manager and provide Service Account , Web Service Url, Execution Account and…
Attri
0
votes
2 answers

Reporting Services 2008 & 2012 side by side

I have installed Sql Server 2008 & 2012 side by side on the same machine, and that's includes the reporting service for each. Both are instances are named instances: MSSQLSERVER2008 and MSSQLSERVER2012. I didn't configure the 2008 one but configured…
0
votes
2 answers

Installing SSRS in SharePoint Integrated Mode requires another license?

We have a box whit SQL Server 2005 and another with Microsoft Office SharePoint Services 2007. If we install SQL Server Reporting Services in the MOSS box, in Sharepoint Integrated Mode, does it require another license, or it only counts the…
Nelson Reis
  • 149
  • 3
  • 10
0
votes
1 answer

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 get access to the reports because it keeps asking…
Neil Knight
  • 207
  • 3
  • 10
0
votes
1 answer

Can Reporting Services 2008 be installed on an existing web farm?

I have a question regarding whether Reporting Services can be installed on an existing web farm, at least the front end portion. The situation is that we have a limited number of servers available to work with (4). We currently have two web farms…
0
votes
1 answer

Cannot get to configure Kerberos for Reporting Services

Context I am trying to configure Kerberos in the domain for double-hop authentication. So here are the machines and their respective roles: client01: Windows 7 as client dc01: Windows Server 2008 R2 as domain controller and dns server01: Windows…
Ucodia
  • 89
  • 1
  • 2
  • 12
0
votes
1 answer

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 0.05% out of 100.00% of a CPU. The waits for responses…
jerry
  • 111
  • 1