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
2 answers

How do I update the SSRS password configuration using a powershell script

I have about 60-70 machines that may or may not have SSRS. The password just expired for the service accounts that it runs under. Is there a way to script the update password for SSRS?
Eric
  • 115
  • 5
1
vote
1 answer

Report Server integration mode in SharePoint 2010 farm

I have a SharePoint 2010 farm that consists of four servers - two WFE servers and two app servers. The WFE servers are the only servers that serve requests to the portal (which is behind a load balancer). The app servers host CA and assorted service…
Matt Stratton
  • 78
  • 5
1
vote
1 answer

Any issues with a SSRS 2008 front-end going to a SQL 2005 cluster back-end

We want to install SQL Server Reporting Services 2008 on Server "A" which is not clustered. We want to use Server B to host the Reporting Services databases. Server B is a SQL 2005 cluster in Active/Passive mode. Any reason why this shouldn't…
matt
  • 113
  • 4
1
vote
2 answers

What would cause a 500 Internal Server Error when accessing the Report Manager url in SQL Server Reporting Services 2008 R2?

I'm very new to Reporting Services and I'm not even sure what to ask. I was given a server where it was installed. I can run the Reporting Services Configuration Manager and connect. However when I attempt to access the urls (web service and report…
Christopher Bennage
  • 121
  • 1
  • 1
  • 6
1
vote
2 answers

Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServerTempDB

The error log on my sql server throws this warning every 5 seconds 'Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServerTempDB.' From what I can tell this may be due to my environment having a mix of 2005 and 2008 SQL…
kscott
  • 123
  • 2
  • 10
1
vote
2 answers

Windows Service Log On Tab

I installed a product that said to set the "Log On" user (in the Log On tab in the Service Properties option) as the network user. The service would not start. I then changed the "Log On" user to Local System Account, and the service started. In…
user8160
  • 329
  • 5
  • 13
1
vote
1 answer

MSSSQL: SSRS, SSAS, SSIS edition

How can I know which edition of SSRS, SSAS and SSIS service is installed on a server? Finding database edition is easy but how to find edition for other SQL services? Any help please? Thanks in advance.
Manjot
  • 333
  • 1
  • 3
  • 17
1
vote
1 answer

how can I change the location of Log files for SQL Server Reporting Services in sql2008?

I tried to change the location of Log files for SQL Server by using these steps but it's not working because I can not find the RTrace in two web config files. There are three files you need to modify to change the location of the Reporting Services…
user47827
1
vote
3 answers

How to make SSRS 2005 run fast in general?

Are there any general rules/tips which we can use to run Sql Server Reporting Services 2005 reports faster? I have been tuning the Tsql behind the reports but does there exist any SSRS specific performance tuning? regards Manjot
Manjot
  • 333
  • 1
  • 3
  • 17
1
vote
3 answers

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 load off the primary server. Would it be possible…
John Keranos
1
vote
3 answers

Open source report framework

I'm looking for a open source report framework for statistics. A more detailed explanation is: We have a number of tests running on different servers collecting data (for example, login time) every 5min. What we need is a framework that collects…
Tiax
  • 11
  • 1
1
vote
2 answers

Transaction log shipping SQL Server 2005 to 2008

I have a reporting setup with SSRS on our SQL Server 2005 database. Because SQL Server 2008 is not supported by the main program which populates our database we are stuck with 2005 on our production database. Unfortunately, when I run our weekly…
Andrew Jahn
1
vote
1 answer

Accessing resources on localhost using domain credentials

I'm trying to set up Team Foundation Server 2010, Sharepoint Server 2010 and Report Server 2008R2. I apologize for how long my question/problem is but I'm really lost on where to even look so am being as descriptive as possible in hopes that I'm…
jas
  • 147
  • 2
  • 7
1
vote
1 answer

Can't find IIS manager on SQL Reporting Services 2008 machine to setup FQDN

I've got a machine that I inherited that runs SSRS 2008. I can't seem to find IIS anywhere on this machine, yet it's serving up content over port 80. I look under services and there is no WWW service running. I need to configure a fully…
NoCarrier
  • 329
  • 2
  • 6
  • 13
1
vote
2 answers

Authentication problem: can't bypass the login prompt when browsing to the SQL Reporing Services website

I'm having a hard time configuring Reporting services on one of our servers. I'm not uninitiated in the domain of IIS7 but I cannot get rid of the login prompt when I'm surfing to the Reporting services website. What I did: I made a windows and SQL…
laurens
  • 397
  • 4
  • 19
1 2 3
…
16 17