Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssrs]

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.

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.

244 questions
1
vote
0 answers

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 found exception. As it turns out, the report is…
R. Schreurs
  • 111
  • 3
1
vote
3 answers

SQL 2008 reporting services with SQL 2005 server

Is it a supported configuration to be run a SQL 2008 reporting services server with a SQL 2005 database server? Either way, where can I find supporting documentation?
Russ
  • 330
  • 3
  • 8
  • 17
1
vote
1 answer

Oracle Proc to SQL Reporting Services: character set name is not recognized

A few months ago Oracle queries stopped working on our reporting services server after a service pack on the reporting server. I ended up having to grant permissions on Oracle directories to eliminate the first error and then renamed the NLS_LANG…
Sam
  • 2,020
  • 1
  • 16
  • 22
1
vote
1 answer

What is the recommended practice for making Reporting Services available publicly?

We have a publicly available web server (although IP restricted, usernames / passwords etc) that we need to be able to present reports through. Our report server is located at a different site, so we need to be able to open ports for this. Our…
ck.
  • 162
  • 8
1
vote
3 answers

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. Now, I'm able to request this database to found any…
Dr I
  • 955
  • 17
  • 33
1
vote
1 answer

Sql Server Reporting Services stops working after changing service Logon account

Using Sql Server 2008. I am attempting to install Team Foundation Server as a dual server setup (due to one server being the DC.) Part of the installation requirements is that Sql Server Reporting Services (SSRS) can not use the local system account…
Chris Marisic
  • 1,424
  • 8
  • 33
  • 51
1
vote
2 answers

sql mail and ssrs

Is it possible to attach a report from SSRS as PDF and send using sql mail? the server is MSSQL 2000.
KellCOMnet
  • 245
  • 2
  • 11
1
vote
0 answers

Issue with Reporting Services - rsreportserver.config is denied

Error message is 'd:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.' I open SSRS configuration and I do see the service as started and running. I gave Network Services the necessary…
Gabe
  • 167
  • 8
1
vote
1 answer

Reporting Services: Cannot connect to Oracle using Integrated Security

Context I have an Oracle 11g database instance and a SQL Server 2012 instance installed on 2 different servers in the same domain. The Oracle database is configured to accept connection with Integrated Security (ie. Active Directory authentication).…
Ucodia
  • 89
  • 1
  • 2
  • 12
1
vote
0 answers

Disable Cache in SSRS 2008 R2

This is a problem that occurs for our IE 8 users (does not happen on IE 9). When rendering a reporting services report IE 8 caches the report so if the data is changed and the user re-runs the report stale data is displayed until the user restarts…
Benjamin Bryan
  • 197
  • 1
  • 9
1
vote
0 answers

Sharepoint Reports on Mac

When trying to view Sharepoint Reports, Mac users get the error "An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode." We tried both Safari and…
David
  • 439
  • 1
  • 5
  • 17
1
vote
1 answer

Sharepoint/WSS Reporting Services Integration woes

after a number of failed attempts i seem to have successfully installed the Reporting services add-in to my WSS farm. However, I seem to be missing most of the enhanced functionality eg no report library template, no report center site template. the…
mhollers
  • 11
  • 2
1
vote
1 answer

One Way Replication of Oracle 11g to MSSQL 2008R2

We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS. What is a good method to automate a one-way, read-only synchronization/replication/dump of a 400GB Oracle…
ScottBai
  • 293
  • 1
  • 7
1
vote
1 answer

SQL Reporting services for Microsoft SBS 2003 not working

I have a clean install of MS SBS 2003 Premium. I installed MSSQL 2000 with SP4. Now I am trying to install CRM 3.0 that requires SQL Reporting Services - but it says its not there. When I go to Add/Remove programs "Microsoft SQL Server 2000…
bMon
  • 253
  • 1
  • 9
1
vote
2 answers

Accessing SQL Server Reporting Services by Non-Admin Accounts

When accessing SQL Reporting Services Report Manager through Great Plains 2010, we're getting the following: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source…
Jason N. Gaylord
  • 223
  • 3
  • 11
1 2 3
…
16 17