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)

0
votes
0answers
8 views

RSConfig utility not honoring instance parameter

Background: We are setting up a laptop image for new developers that contains SQL Server Express 2014 with Reporting Services. As a post imaging step, I tried using rsconfig to update the ...
2
votes
1answer
1k 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 ...
1
vote
1answer
926 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
14 views

SSRS 2012 Native Through Apache Proxy

I am trying to find a solution for getting MS SQL Reporting Services working through an Apache proxy. I have been at this about a week now and narrowed down what I can and cannot do quite a bit. I ...
0
votes
1answer
47 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
46 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
368 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
58 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. ...
0
votes
0answers
108 views

Configure Microsoft Sql Server Reporting services to redirect to ssl

I'm setting up an SSRS 2014 install, and I would like to make everything SSL by default. Getting SSL running isn't too hard, but for some reason there seems to be no easy way to redirect the http ...
1
vote
0answers
92 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
0answers
24 views

Reporting Services 2014 security configuration

I have some reports in SSRS 2014 that I would like to be available on demand as well as on subscription. Making them available on demand is easy to secure - just set the data source to Windows ...
0
votes
2answers
465 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
0answers
54 views

TFS 2013 Update3 Reporting Services Configuration

I'm trying to configure the reporting services on a TFS 2013 with Update3. I get this error: Create Analysis Database schema failed: Error generating Analysis Database: Systemfehler: Invalid ...
0
votes
0answers
84 views

SQL server reporting services Get user IP

USER -> Reporting server -> SQL Serve SELECT CONNECTIONPROPERTY('client_net_address') AS client_net_address return of course IP of reporting server In DOMAIN is this command return true IP of user ...
0
votes
0answers
42 views

SQL Reporting Denying Access to User After Move to New Group

We have a SQL Server 2008 server setup with reporting services so that users can log in and run certain reports. I have a user that was granted browse permissions to this as we had their initial ...
0
votes
1answer
3k 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 ...
1
vote
0answers
718 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 ...
0
votes
2answers
1k 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
770 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 : ...
0
votes
1answer
241 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 ...
1
vote
1answer
117 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
145 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
311 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
497 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
217 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
2k 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
360 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
2k 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
142 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
468 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
168 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
1k 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 ...
0
votes
1answer
798 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
3answers
850 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
191 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
745 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
423 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
49 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 ...
1
vote
1answer
1k views

SQL 2008 Reporting Service SSL certificate chain not trusted

I got a SQL Server 2008 Standard Edition installed on a Server 2008 R2, OS and SQL Server got newest Service Packs and updates installed. The SQL Server is up and running but I cant connect to the ...
7
votes
2answers
38k views

Install SQL CLR types & Report Viewer 2012 on Sql 2008 server

I'm in the process of installing a client's ASP.net site on a Windows Server 2003 box running Sql 2008. The site uses Report Viewer 2012, but when I attempted to install it on the server, I got the ...
1
vote
2answers
7k 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 ...
2
votes
2answers
10k views

Reporting Services Error 401: Unauthorized

I am trying to setup reporting services on a SQL server 2008 and get this error message when I try to connect to the http://localhost/reports The request failed with HTTP status 401: Unauthorized. ...
0
votes
1answer
442 views

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

Is it possible to mirror the SQL Reporting Services databases?

Is it possible to mirror the SQL Server (2005 or 2008) Reporting Services databases (ReportServer, ReportServerTemp)? I have a web site that uses a database that is already mirrored, and it also ...