Questions tagged [ssrs-2012]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3 votes
1 answer
68k views

How to install SSL Certificate on Windows Server 2012 R2 without IIS

I have a Windows Server 2012 R2 server running SQL Server 2012 with Reporting Services. I want to be able to use the Reporting Services Report Manager over HTTPS instead of the default HTTP. How can ...
codingbadger's user avatar
2 votes
1 answer
762 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 ...
Granger's user avatar
  • 1,160
2 votes
2 answers
211 views

SSRS 2012 without SSL

We are writing a deployment package to install SSRS 2012 on client servers. Some of them may have a certificate installed, but in all cases we do not want the installation to force the SSL (https) ...
Mark Dynna's user avatar
2 votes
1 answer
1k 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 ...
Granger's user avatar
  • 1,160
2 votes
1 answer
743 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, ...
Xavier's user avatar
  • 269
1 vote
1 answer
9k views

How do I use a wildcard certificate with SSRS?

I am trying to setup SSRS access via SSL, and I have followed the instructions here; however, I do not receive a clickable url in the Configuration Manager to click on and test. The url shows as ...
Question Asker's user avatar
1 vote
1 answer
8k 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 ...
katit's user avatar
  • 213
1 vote
2 answers
9k views

SSRS-error about report server database version after hotfixing SQL. The found version is '164'. The expected version is '163'

After applying hotfix KB3194725 to our SQL server, the SSRS server throws the following exception when trying to generate a report: Exception type: InvalidReportServerDatabaseException ...
Henrik H's user avatar
  • 111
1 vote
1 answer
1k views

SSRS Report Builder Error: Target Principal name is incorrect

Here is our problem, when using SSRS Report Builder we are able to successfully connect to our data source with no errors, but when we try to connect to a data set we get the following error. ...
Gene's user avatar
  • 111
1 vote
1 answer
4k views

service account doesn't have rights to check domain user SIDs [ssrs]

Subscriptions that include reports, as oppose to just a link, are currently failing with "The report server has encountered a configuration error. Mail will not be resent." Reviewing the logs reveals ...
PrtScn's user avatar
  • 11
1 vote
1 answer
746 views

What is the maximum MS Reporting Services Instances allowed?

Let me explain my problem: I'm using an Amazon EC2 instance as a DB and Report Server, currently the server has 11 Reporting Services instances installed and around 40 databases (22 from Reporting ...
Alex's user avatar
  • 19
0 votes
1 answer
215 views

Unable to login to stand alone SSRS 2012 from domain joined computers

We have a non-domain joined SQL 2012 server running in Azure supporting several web sites, earlier this week an issue popped up where domain joined computers could not log in. There were no updates or ...
Matt Bear's user avatar
  • 874
0 votes
2 answers
2k views

How can I use a value returned from one dataset to build a query for a different dataset, in SSRS?

I'm using SQL Server Report Builder 3.0 to create a report. I have two tables and I want to look up a value in one table and then use that to select a value from the second table. Example as follows: ...
Potatan's user avatar
  • 13
0 votes
1 answer
368 views

SSRS 2012 ODBC Driver architecture 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 ...
dansh's user avatar
  • 11
0 votes
2 answers
611 views

Publish-AXReport Gives Error "Name cannot begin with the ' ' character"

Running the below PowerShell script (i.e. to deploy all SSRS reports for AX) gives an error: $axdllname = "Microsoft.Dynamics.AX.Framework.Management.dll" $gacfolder = join-path $env:windir "assembly\...
JohnLBevan's user avatar
  • 1,312
0 votes
1 answer
235 views

SSRS 2012 SharePoint-Integrated mode

We have a 2-server (web and app server plus a database server) SharePoint 2013 farm. We would like to add SharePoint-integrated mode SSRS 2012 to it. We were thinking of installing SSRS SharePoint ...
Ali_Abadani's user avatar