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
5 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
12 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
0answers
13 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
62 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
38 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
55 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
27 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 ...
1
vote
0answers
415 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
1answer
447 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 ...
1
vote
1answer
59 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
92 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
174 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
1answer
169 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 ...
0
votes
1answer
2k 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
160 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
2answers
722 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
322 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. ...
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 ...
0
votes
1answer
945 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
110 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 ...
4
votes
1answer
958 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
672 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
0answers
154 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 ...
4
votes
0answers
529 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 ...
0
votes
1answer
43 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
130 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..... ...
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 ...
2
votes
1answer
268 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
50 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 ...
0
votes
1answer
371 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 ...
1
vote
0answers
25 views

Can I run sharepoint 2007 native report viewer in synchonous mode?

We are hosting a SharePoint MOSS 2007 environment and installed and use the Native Report Viewer with SSRS 2005. All works fine from the LAN, but from internet, the report viewer displayes a page not ...
0
votes
1answer
629 views

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

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

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 ...
5
votes
2answers
26k 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 ...
0
votes
4answers
73 views

Automated email reports [closed]

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)?
0
votes
1answer
97 views

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 ...
1
vote
0answers
118 views

Problems with SSRS and IIS

I'm really not sure where this question would be best asked, so I'm posting this here in an IIS-specific forum, and also over in SQL Server Central for an SSRS-specific audience. The problem that I'm ...
1
vote
1answer
740 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 ...
1
vote
0answers
575 views

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

SQL Server Report Services Not Configuring

This is kind of Frustrating as I know I am doing everything right, however SQL Server Reporting Services are not configured: To Configure I did these following steps Opened Reporting Services ...
0
votes
2answers
263 views

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

Licensing SQL Server 2012 Reporting Services w/ SharePoint 2010 [duplicate]

Possible Duplicate: Can you help me with my software licensing issue? Here's my situation: I have 1 VM that is running SharePoint 2010 SP1. I have a different physical server that is ...
1
vote
3answers
215 views

Logs reporting in a human way

I'm currently working on our IT System to improve it a little bit. I've install set and run a rsyslogd on our servers (Physicals and virtuals), all of them now sending their logs into a database. ...
0
votes
1answer
47 views

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

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

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 ...
2
votes
1answer
422 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, ...
2
votes
3answers
1k views

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 ...