The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
3answers
2k views

Risks involved in setting up Kerberos authentication for WSS Reporting Services

We have an established Intranet based on WSS with two front ends and a database. Currently all authentication is NTLM. We have installed Reporting Services In Integration Mode. RS works as long as ...
3
votes
3answers
1k views

Domain User Access to SQL Server Reporting Services 2005 on IIS7

What are the required steps to properly allow domain users access to reports via the Reporting Services web site? I've tried to give domain users access both through the site itself and through ...
3
votes
1answer
1k views

Reporting Services 2008 configuration for basic authentication using username and password

I want to configure Reporting Services 2008 to use a custom defined username and password for access. I read that I must set reporting services to do basic authentication : ...
2
votes
4answers
3k views

Is it possible to mirror the SQL Reporting Services databases?

Is it possible to mirror the SQL Server (2005 or 2008) Reporting Services databases (ReportServer, ReportServerTemp)? I have a web site that uses a database that is already mirrored, and it also ...
2
votes
3answers
5k views

Error configuring SQL Reporting Services 2005 on Windows 7

I've installed SQL Server 2005 with Reporting Services on Windows 7 Ultimate x64 and when I try to configure it when clicking on "Windows Service Identity" I get this error message: There was an ...
2
votes
2answers
299 views

reporting servcies 0x7 KDC_ERR_S_PRINCIPAL_UNKNOWN only on server

I have Reporting Services configured on Windows Server 2008 R2. The reporting services is running under domain account and so its AppPool. I am accessing the site through a custom domain. The ...
2
votes
1answer
94 views

I dont qualify for Junk Mail Reporting Program. Alternatives?

I am on shared hosting and therefore does not qualify for MSN Junk Mail Reporting Program. I am concerned about people who want to unsubscribe, instead clicking the "report as junk" button in ...
2
votes
2answers
12k views

Reporting Services 2008: Virtual directories not visible in IIS7

I'm having some problems with Reporting Services on Windows Server 2008 Standard. I've installed server 2008 as a standalone webserver (with roles/features of an web application server). On top of ...
2
votes
0answers
165 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 ...
2
votes
1answer
69 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 ...
2
votes
1answer
502 views

Change to RS 2008R2 configuration stopped IIS site receiving traffic through load balancer (and its still not working after backing it out)

Background We are testing a pair of Windows 2008 R2 (IIS 7.5) web servers in conjunction with a hardware load balancer (external device) that splits port 80 traffic coming into a Virtual IP between ...
2
votes
1answer
259 views

SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created

I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on ...
2
votes
1answer
538 views

How to uninstall SQL 2008R2 Reporting Services via the command line?

I am running SSRS 2008R2 x64 on a Windows Server Core 2008 R2 instance. I need to fully uninstall the SSRS instance leaving the DB's in tact. I know this is normally done through the Programs and ...
1
vote
2answers
348 views

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 ...
1
vote
3answers
231 views

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 ...
1
vote
1answer
82 views

Can't add reporting service component for MS SQL Server 2005

Can't add reporting service component for MS SQL Server 2005 I want to reinstall sql server 2005, all components are disabled when i uninstall sql server 2005. It was bad than before now.
1
vote
2answers
3k views

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 ...
1
vote
3answers
24k views

How to get Business Intelligence Development Studio?

I need Business Intelligence Development Studio (BIDS) installed on my workstation (Win XP/x86). I don't need the SQL server itself since I will be developing and deploying against another server. I ...
1
vote
3answers
204 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. ...
1
vote
1answer
994 views

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 ...
1
vote
1answer
125 views

SQL Server 2008 Reporting Services on Windows 2003

Will SQL Server 2008 Reporting services work if it is install on Windows 2003? Anyone have any experience with this?
1
vote
2answers
5k views

rsAccessDenied - SQL server 2008 reporting services

I am running SQL server 2008 developer edition on windows vista home premium. I created a reporting services project that was built successfully in BIDS. When I try to deploy it it gives the following ...
1
vote
2answers
532 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 ...
1
vote
1answer
2k views

Allow anonymous access to SSRS

How could I allow anonymous access to SSRS so that all user can access the reports without asking for a user name and password?
1
vote
1answer
131 views

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

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 ...
1
vote
1answer
431 views

Report Server w/ SQL 2008 R2 Express - Can't login to Manager URL

I just installed Report Servicing addon (Advanced Services) to a local SQL Express 2008 R2 server. I have the configuration tool and setup the proper URLs but when I connect to them I get permissions ...
1
vote
1answer
141 views

configure the reporting services and/or IIS to give access permission

how to configure the reporting services and/or IIS to give access permission: Reporting Services
1
vote
2answers
925 views

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 ...
1
vote
3answers
803 views

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 ...
1
vote
1answer
2k views

SQL Server 2008 Express + Reporting Services on Windows 7

I'm trying to install SQL Server Express 2008 and Reporting Services on a x64 Windows 7 Machine for development purposes. I've installed SQL Server 2008 Express with the Microsoft Web Platform ...
1
vote
1answer
168 views

How to deploy SQL Server 2005 Reporting Services on a network without a domain server?

I have a small Windows network (~30 machines) and I need to deploy SQL Server 2005 Reporting Services. Because I use SQL Server Standard Edition and not Enterprise, I am forced to use Windows ...
1
vote
1answer
212 views

How can I make a copy of an installed Report?

I have a working installation of SQL Server Reporting Services (2008) in which I've setup a DEV directory and successfully upload a number of report templates. I have now created a TEST directory. How ...
1
vote
2answers
2k views

SQL 2008 Reporting Services Report Manager blank on Win 7

I have installed SQL Server 2008 Reporting Services on my development laptop running windows 7. When I browse to the report manager, only the header is shown. The content pane is blank, and there is ...
1
vote
1answer
137 views

Managing Reporting Services

We're expanding our reporting services usage and are trying to set up some guidelines for developers and admins on managing and developing for the system. Do you have any advice on keeping a ...
1
vote
3answers
8k views

Reporting Services Error 401: Unauthorized

I am trying to setup reporting services on a SQL server 2008 and get this error message when I try to connect to the http://localhost/reports The request failed with HTTP status 401: Unauthorized. ...
1
vote
1answer
539 views

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 ...
1
vote
1answer
148 views

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 ...
1
vote
1answer
4k views

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 ...
1
vote
0answers
21 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 ...
1
vote
0answers
100 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
290 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
294 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 ...
1
vote
0answers
87 views

Deploying reports to report server

I posted this question on stackoverflow, but I think it would be better here. I configured SSRS 2008 on a remote server running under Network Service. I can access the report manager from my local ...
1
vote
1answer
430 views

Asterisk Call Center Report - Inbound and Outbound Calls

We currently use Asterisk to run our call center which handles incoming calls (both direct dial to extension and queues) as well as a bunch of outbound calls. Up until now, we've used a custom report ...
1
vote
0answers
859 views

reporting services 2008 R2 shows UAC for printing ActiveX after .NET 4.0 installation

Installed the latest updates on the server. Now every time I try to print from a reporting service website the UAC opens.. I already tried to reduce security within IE9 to the minimum, but with no ...
1
vote
0answers
540 views

TFS Reporting Services Configuration Error - The RPC Server is Unavailable

I'm trying to configure Team Foundation Reporting but without any success. The App Tier and the Data Tier are in separate servers. I guess it's not a port/firewall problem, because I opened port ...
1
vote
0answers
429 views

Problems with Apache Mod_Proxy and Microsoft's ReportViewer's Reserved.ReportViewerWebControl.axd

I've configured an Apache httpd server (v2.2) as a reverse proxy (with SSL) to a Microsoft IIS website running an ASP.NET application with SQL Server Report Services. The proxy mostly works but ...
1
vote
1answer
413 views

Finding what the report subscription error is in SSRS

I've created a simple report in SSRS, and then tried my hand out with a data driven subscription. I can verify that the subscription runs on the 'My Subscriptions' page, but under status it says ...
1
vote
1answer
432 views

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