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
2
votes
1 answer

What is the difference between the Verbose and Normal setting for ExecutionLogLevel in SSRS 2012?

I cannot find any real documentation on the ExecutionLogLevel setting in SSRS 2012 (which is expected to be the same as it was in SSRS 2008). What changes when you set the setting to "Verbose"? Do you get more data in the same amount of rows? Do you…
Granger
  • 1,160
  • 2
  • 10
  • 26
2
votes
2 answers

Reporting Services 2008: Virtual directories not visible in IIS7

I'm having some problems with Reporting Services on Windows Server 2008 Standard. I've installed server 2008 as a standalone webserver (with roles/features of an web application server). On top of that, I've installed Sql Server 2008 Standard with…
user16996
2
votes
1 answer

How can ReportManager use a different port externally than from behind the firewall?

I'm on SSRS 2012 in Native mode. The configuration doesn't seem to have changed much from SSRS 2008, which I upgraded from, so the issue applies to both versions (however, if there's a solution, it may or may not apply to both). I am in a situation…
Granger
  • 1,160
  • 2
  • 10
  • 26
2
votes
0 answers

SQL Reporting Services Report Manager cannot be accessed by IP on the local computer

I have set up SQL Express 2012 with Advanced Services on a test machine. The requirements are that ReportServer should run on a dedicated IP address and port. So I went to Reporting Services Configuration and set both Web Service and Report Manager…
JustAMartin
  • 231
  • 1
  • 18
2
votes
2 answers

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 built-in account or another account. The dropdown…
System.Data
  • 183
  • 1
  • 6
2
votes
1 answer

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, however I am unable to log in to it using any…
Xavier
  • 269
  • 3
  • 9
2
votes
3 answers

Error running Report in SQL Server Reporting Services (SQL Server 2005)

I get an error message " An error has occurred during report processing. Query execution failed for dataset [sprocs name]" when running SSRS report. The stored procedures for this report can be executed without error in the SQL server. It has a CTE…
iamceeceecarter
  • 81
  • 1
  • 3
2
votes
1 answer

Change to RS 2008R2 configuration stopped IIS site receiving traffic through load balancer (and its still not working after backing it out)

Background We are testing a pair of Windows 2008 R2 (IIS 7.5) web servers in conjunction with a hardware load balancer (external device) that splits port 80 traffic coming into a Virtual IP between the 2 servers. There is a test website set up on…
Laurence
  • 241
  • 2
  • 9
2
votes
1 answer

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 other servers and I cannot get it to fail in the…
jwnace
  • 163
  • 1
  • 4
2
votes
1 answer

How to uninstall SQL 2008R2 Reporting Services via the command line?

I am running SSRS 2008R2 x64 on a Windows Server Core 2008 R2 instance. I need to fully uninstall the SSRS instance leaving the DB's in tact. I know this is normally done through the Programs and Features control panel applet, however this does not…
Brett A.
  • 156
  • 9
2
votes
2 answers

reporting servcies 0x7 KDC_ERR_S_PRINCIPAL_UNKNOWN only on server

I have Reporting Services configured on Windows Server 2008 R2. The reporting services is running under domain account and so its AppPool. I am accessing the site through a custom domain. The problem is when I access the site through a custom…
ajay_whiz
  • 131
  • 6
2
votes
2 answers

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 report server is available and configured for…
David
  • 439
  • 1
  • 5
  • 17
2
votes
2 answers

Can Microsoft SQL Server Reporting Services connect to an LDAP server other then Active Directory

Can MS SSRS use an LDAP server other then AD for authentication? Is this an easy configuration or is it digging ones self into a hole?
oneself
  • 397
  • 1
  • 5
  • 15
2
votes
4 answers

SSRS 2008: Unable to restore encryption key

I have migrated SQL server 2005 database to sql server 2008 using side by side upgrade. I have copied Reportserver and reportservertempdb database across and configured SQl server Reporting services 2008 to use this new database. I am not able to…
Manjot
  • 333
  • 1
  • 3
  • 17
2
votes
1 answer

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 are for setting up native mode? Has anyone done…
Greg_the_Ant
  • 489
  • 7
  • 26
1 2
3
…
16 17