Questions tagged [ssrs-2012]
The ssrs-2012 tag has no usage guidance.
16
questions
0
votes
2
answers
3k
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:
...
- 13
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. ...
- 111
0
votes
1
answer
223
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 ...
- 874
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
...
- 111
2
votes
2
answers
219
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) ...
- 151
0
votes
1
answer
391
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 ...
- 11
0
votes
2
answers
632
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\...
- 1,366
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 ...
- 11
1
vote
1
answer
757
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 ...
- 19
1
vote
1
answer
10k
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 ...
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 ...
- 133
1
vote
1
answer
9k
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 ...
- 213
0
votes
1
answer
237
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 ...
- 123
2
votes
1
answer
789
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 ...
- 1,160
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 ...
- 1,160
2
votes
1
answer
757
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, ...
- 269