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.

learn more… | top users | synonyms (1)

1
vote
1answer
1k 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 ...
2
votes
2answers
5k views

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

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 ...
0
votes
1answer
1k views

Configuring external SMTP server on Azure VM - messages staying in queue

I have an external SMTP provider: auth.smtp.1and1.co.uk I am trying to send SQL Server Reporting Services emails via this on an Windows 2012 Azure VM. It is configured sufficiently correctly for ...
1
vote
1answer
19 views

SQL Failover Cluster Clients not updating DNS

I have a multi-subnet SQL Server 2012 failover cluster running on 2 Windows 2012 R2 nodes. The cluster is located on 192.168.1.10 when on NODE A and 192.168.5.10 when running on NODE B. When I look at ...
0
votes
0answers
13 views

How can I change SSRS Service account without losing custom reports?

I have to change the service account for SQL Server Reporting Services (SSRS). However, when I change the service account to a new service account, I lose all the custom reports that were created ...
0
votes
1answer
8 views

SSRS 2012 ODBC Driver mismatch on remote computer, works locally

I have an SSRS 2012 server (Windows 2012) with Ingres ODBC drivers installed, ODBC entries have been configured in the 32 bit (SysWOW64) ODBC manager. Reports ran locally on the server run without a ...
0
votes
0answers
115 views

Install “Microsoft Report Viewer” on Windows Server 2012 R2

I am attempting to install Microsoft Report Viewer (2015) on a web server. The web server is a Windows Server 2012 R2 (x64) instance. The web server will be running a .NET application that uses the ...
1
vote
1answer
2k views

Kerberos Configuration Manager for SQL Server error “unable to access user principal information from the system”

When I launch the Kerberos Configuration Manager for SQL Server and try to connect to the local machine it's on, I am getting the error "Kerberos Configuration Manager for SQL Server error "unable to ...
1
vote
0answers
12 views

How do I stop SSRS from sending any missed reports when starting the service?

We fired up a test SSRS service that hasn't run for a couple of months. It appears that it has decided to send all reports where it has missed the schedule (so any report that didn't send since it was ...
0
votes
0answers
37 views

NTLM Authentication fails on SSRS 2008 R2 across trusted domains

I've got 2 domains that are fully trusted. SSRS is on domain1 and my users are on domain2. Can reach SSRS from D2 without an issue, and use my D1 credentials to authenticate. In SSRS\Reports I ...
0
votes
0answers
20 views

Adding a default front page to Reporting Services 2014

I have installed SSRS 2014 on a server, and it works fine. But when a client connects to the server on HTTP/HTTPS, they get a 404 unless they add /Reports to the url. Is there some way I can add a ...
0
votes
1answer
405 views

Clustered instance - kerberos double hop woes

We've recently migrated our virtualised SQL databases to a bare metal solution in an active/active cluster. Everything is working great except SQL Reports. Ok, so a rundown of our setup here as it ...
0
votes
0answers
46 views

SQL Report Server Subscription PDF Corrupted

I have a SQL Report Server 2012 with subscriptions that emails PDF reports to external users. The report runs once a week, and is about 100 pages long. However, the PDF the users get in their emails ...
0
votes
0answers
80 views

Error on opening SSRS System Setting in SharePoint 2013

I configured SSRS for SharePoint. After creating a Service Application when I opened it and tried to access System Setting or Manage Jobs then I am getting error- Application error when access /...
2
votes
0answers
87 views

Constrained Delegation between IIS, SQL Server, SSRS and File System

First of all, not sure which site is best suited for this question be it SO, SF or SU so please feel free to suggest migration! I have a requirement to constrain delegation between several machines ...
0
votes
2answers
5k views

Install RSClientPrint for Reporting Services 2012 using .bat file and still be able to use 2005

I have a Reporting Services 2005 server that when users accessed it and tried to print reports would get a message asking them to install the print control, which they could not do because of lack of ...
0
votes
0answers
55 views

Is it possible to redirect a virtual directory to another server but on the same domain?

I have huge problems with IE P3P policy and reporting services. The problem is, our web application runs on the domain https://www.companyname.com more exactly on in the virtual directory ...
0
votes
0answers
41 views

MDX run slower in SSRS than in Management Studio

I have an mdx dataset for a SSRS 2012 report. Running MDX in Management Studio takes 1 sec, but in report it takes 1 minute. This is a critical report and the user want it as fast as possible. I have ...
0
votes
1answer
2k views

Reporting Services 2008 Service Account error

I saved over the encryption key backup file when changing from one account to another. Now I can't see reports, change accounts, or use any of the Encryption key tools in the configuration manager. ...
0
votes
1answer
207 views

SSRS Report fails with conversion error but runs fine in ssms?

I have an issue with a report that was written before my time (I warn you it's got a lot of code and the error makes no sense). Basically its a stored procedure that creates a table variable and then ...
0
votes
1answer
901 views

401: Unauthorized when connecting to Reporting Services

Ok, so here's the layout: We have our AppServer and our Database Server. Our AppServer is trying to connect to our Database Server which has Sql Reporting Services on it. However they are different ...
0
votes
2answers
371 views

How do I change the Web Service Account for SQL Server Reporting Services?

I am trying to configure a Report Server on SQL Server 2005 and need to change the ASP.NET Web Service Account. Can anyone point me in the right direction of how to do this. Thanks Andy
0
votes
3answers
63 views

How can one use Reporting Services against a log shipped database?

Using MS SQL SERVER 2005. I have log shipped the ReportServer database to the secondary server in Standby/Readonly. I seem to be unable to use Reporting Services on the secondary database because it ...
1
vote
1answer
5k 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. ...
1
vote
0answers
172 views

SSRS Returning 401 Unauthorised Error when calling web service

We have two web servers that call the SSRS service to query the reports held there. Both servers are set up identically but while one works the other returns a 401 unauthorised exception when trying ...
0
votes
2answers
4k views

Enable anonymous access to report builder in reporting services 2008

I have a 2008 reporting services server installed on windows 2003 server. I am trying to allow anonymous access to the report builder folder so that my users do not have to select the remember ...
0
votes
2answers
2k views

Why isn't sql server using all of the available memory

I Have SQL server 2012 standard 64bit with 64GB RAM and 40 CPU cores. In the server properties, I can see that all the RAM is listed in the memory field on the general tab. Underneath the Memory tab, ...
0
votes
2answers
2k views

SQL Server 2012 Reporting Services to export CSV

I have an SQL Server 2012 Reporting Services instance, and by default, it can only export to PDF, Excel and Word. Users require CSV export as well. All I found is that there are different extensions, ...
0
votes
1answer
2k views

Sharepoint and SSRS report trust relationship ssl/tls secure channel remote certificate is invalid

I have no experience with sharepoint at all. but this is what I observed. I intermittently getting this error message on my sharepoint. could not establish trust relationship for the ssl/tls secure ...
3
votes
1answer
1k views

Reporting Services 2008 configuration for basic authentication using username and password

I want to configure Reporting Services 2008 to use a custom defined username and password for access. I read that I must set reporting services to do basic authentication : <AuthenticationTypes&...
1
vote
1answer
269 views

SSRS Failing with error on App_global.asax

Our SSRS server has started failing. The Logs are currently showing the following error: System.BadImageFormatException: Could not load file or assembly 'file:///C:\Program Files\Microsoft SQL ...
0
votes
1answer
199 views

SQL Reporting service unable to start after restoring on new hardware

I have a SQL server that the hardware is failing. As a solution we restored the image of the server on a multicore (more less new) server. The problem is that SQL 2000 cannot be started if number of ...
0
votes
1answer
718 views

Wildcard Domain with Google Analytics

Each user on our website has their own subdomain (e.g. bob.example.com, elephant.example.com) and they get paid for the traffic that they send to this subdomain. How can I wire up Google Analytics so ...
1
vote
2answers
1k views

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 ...
0
votes
1answer
972 views

Change SMTP server for SBS 2011 Self Monitoring Reports

SBS 2011 sends daily/weekly/instant reports from the account SBSMonAcct@. It uses localhost as the SMTP transport as being SBS Exchange is usually installed. I want to use an external SMTP server. ...
1
vote
0answers
369 views

Can SharePoint 2013 and Microsoft Dynamics GP 2013 run on the same server?

We have a new Windows 2012 server with SQL Server 2012 and Microsoft Dynamics GP 2013 running on it. I have been asked to install SharePoint 2013 on this server also. I know GP 2013 now uses SSRS for ...
0
votes
1answer
4k views

SQL Server Reporting Services Report Builder not starting as RemoteApp

A bunch of Users has been given access to a SQL Server 2008 R2 reporting services instance. Due to a policy the users only may access the services through a Remote Desktop instance. We have handed out ...
2
votes
1answer
557 views

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 ...
0
votes
1answer
4k views

SQL Server 2012 Reporting Services need to repair

I had SQL 2012 installed with SSRS. Then I was playing with IIS and deleted (I think) ReportServer aliases and webs Now I need to work with SSRS but can't figure out how to return it back. Service is ...
2
votes
1answer
235 views

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 ...
2
votes
1answer
545 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, ...
0
votes
1answer
234 views

Default error page in SSRS 2008

We are using SSRS 2008. Is there a way to show a default error page if there is an error in the Reporting Services? If so how do I go about doing this? Currently getting the following error..... ...
5
votes
1answer
2k views

Why do I get prompted for “Data Source Credentials” when editing a SSRS report for SCCM?

When attempting to add a dataset in Report Builder I am prompted to "Enter Data Source Credentials." Choosing "Use the current Windows user" fails, and I don't have the password for the specified ...
1
vote
3answers
864 views

Could SQL Server 2008 replication be used with NLB to allow unlimited scaling of reporting servers?

We are currently using transactional replication in SQL Server 2008 to keep a secondary reporting server synchronized with a primary database server. This has been working weel and keeps some of the ...
1
vote
0answers
314 views

SSRS reachable by FQDN on local computer, but not from a different computer

I am having trouble getting my SSRS server to successfully cohabitate with IIS, after having to move the server to a different subnet. I have 2 static IPs for that server: .242 is defined explicitly ...
5
votes
0answers
1k views

SCCM Reporting - “Report Builder click-once application does not exist on the report server”

I (and my manager) would like to be able to create custom reports in SCCM 2012 SP1 through the Configuration Manager Administrative Console from the comfort of our workstations. Unfortunately, if you ...
2
votes
1answer
487 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 ...
0
votes
1answer
66 views

Very extremely weird IIS\Reporting Services permission issue

Server 2012 Standard Reporting Services 2012 I have 2 URLs for my Reporting Services: http://MACHINE-NAME/reportserver https://domain.com/reportserver When using the local url locally everything ...
0
votes
1answer
2k views

SSRS Subscription Fails

Our SSRS server is not executing a subscription correctly. (Only subscription we have btw) We created a subscription to export a report as an excel file to the file system. Tried running the job ...