Server Fault Stack Exchange
Server Fault Stack Exchange

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
1
vote
2 answers

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?
ScottStonehouse
  • 979
  • 4
  • 16
  • 25
1
vote
2 answers

Query Execution Failed in Reporting Services reports

I have some reporting services reports that talk to Analysis Services and at times they fail with the following error: An error occurred during client rendering. An error has occurred during report processing. Query execution failed for dataset…
Chris Herring
1
vote
2 answers

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 Exchange server in the same domain? I've tried…
Edoode
  • 183
  • 2
  • 7
1
vote
1 answer

SQL Server 2008 Express + Reporting Services on Windows 7

I'm trying to install SQL Server Express 2008 and Reporting Services on a x64 Windows 7 Machine for development purposes. I've installed SQL Server 2008 Express with the Microsoft Web Platform Installer I had to manually enable the SQL Server…
TimothyP
  • 299
  • 1
  • 5
  • 15
1
vote
1 answer

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 e.g., STSADM.EXE -o addwppack -filename "C:\…
Greg_the_Ant
  • 489
  • 7
  • 26
1
vote
1 answer

How to deploy SQL Server 2005 Reporting Services on a network without a domain server?

I have a small Windows network (~30 machines) and I need to deploy SQL Server 2005 Reporting Services. Because I use SQL Server Standard Edition and not Enterprise, I am forced to use Windows Authentication to the users. I am a Linux admin, and have…
ti2
1
vote
1 answer

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. Error Code 800706B3 This error appears before I can…
Nick
1
vote
1 answer

OpsMgr SDK Service Event ID 26219 - SCOM 2022

Every 5 minutes, the following log generates twice in the Operations Manager logs on the Management Server. It's definitely related to the reporting services. I uninstalled the reporting services entirely and deleted the database in SQL. Re-install…
Jessie
  • 182
  • 1
  • 13
1
vote
1 answer

How can I make a copy of an installed Report?

I have a working installation of SQL Server Reporting Services (2008) in which I've setup a DEV directory and successfully upload a number of report templates. I have now created a TEST directory. How can I copy the report templates from DEV to…
Chris Arnold
  • 213
  • 2
  • 7
0
votes
1 answer

SQL Server Express Reporting Services is accesible from another server?

I am thinking of installing a Sql Server 2017 Express with Advanced Services. All data will be stored in the local instance as well as the Reporting Services. The question is if someone in another server could see that reports or only users logged…
U. Busto
  • 141
  • 1
  • 8
0
votes
1 answer

Windows Memory Usage - Is something throttling available RAM

Can anyone tell by the images below if this machine is unnaturally throttling memory usage. The memory was upgraded from 32GB-64GB for SSRS report rendering, which is the only sizable process to run. SSRS went into panic mode. There was a log entry…
Ross Bush
  • 121
  • 1
  • 6
0
votes
0 answers

Configuring Second URL for Reporting Services to Respond on port 443

We have a web server hosting several websites. DNS is configured to point ..com to the web server. One of the sites acts a proxy and redirects https requests to a seperate SSRS server. We have a wildcard ssl certficate for *..com. Recently the…
RLBChrisBriant
  • 595
  • 1
  • 7
  • 22
0
votes
1 answer

Unable to upload reports to TFS 2018 Project Collection

I'm trying to add reports to my TFS 2018 installation following the tutorial here. When I get to the 'Upload reports to a team project' step, I execute the command TFSConfig addprojectreports /collection:"http://myServer:8080/tfs/DefaultCollection"…
HasaniH
  • 101
  • 2
0
votes
2 answers

Where is this hidden computer name coming from?

Environment: I am baking Amazon Machine Images with SQL Reporting Services (SSRS) installed. The Windows Server 2016 machine is joined to the domain and its computer name is changed AFTER install. Problem: When I open SSRS Configuration Manager it…
Jeremy Thompson
  • 143
  • 1
  • 8
0
votes
0 answers

Run SQL Server Standard 2017 Edition Together with SSRS 2017 Developer Edition

Has anybody ever tried running SQL Server 2017 Standard with SSRS Developer Edition and had it worked successfully? I'm setting up a client environment in Azure. This will be there production environment. We felt sql server 2017 standard made the…
jrd1989
  • 698
  • 15
  • 48
1 2 3
…
16 17