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.

242 questions
25
votes
4 answers

Install SQL CLR types & Report Viewer 2012 on Sql 2008 server

I'm in the process of installing a client's ASP.net site on a Windows Server 2003 box running Sql 2008. The site uses Report Viewer 2012, but when I attempted to install it on the server, I got the message "CLR Types for Sql Server 2012" were…
Ted
  • 353
  • 1
  • 3
  • 8
15
votes
4 answers

Security Risk? Microsoft-HTTPAPI/2.0

Whilst security vetting our machines, I found that one host was exposing a Microsoft-HTTPAPI/2.0 service over port 80 to the internet. I'm not familiar with this, but after googling around, I found that SQL Server 2008 publishes SQL Server Reporting…
Cheekysoft
  • 397
  • 1
  • 4
  • 11
9
votes
2 answers

SQL Server Reporting Services (SSRS) IP Handling on Multi-Instance Servers

Tl;Dr I have a SQL Server instance (SQLSERVER01-i01) with a dedicated IP address and port (162.xxx.xxx.51:1433) on a multi-instance SQL Server (each SQL Server instance on the Windows Server has its own IP address) which are all running on one…
John K. N.
  • 1,955
  • 1
  • 16
  • 26
5
votes
1 answer

Sharepoint / SSRS subscriptions intermittently not emailing

I am running MOSS with SQL Server 2005 Reporting Services in integrated mode. There are a number of reports that are generated and then output emailed through SharePoint's subscriptions. Sporadically all subscriptions will fail to email with the…
Johnno Nolan
  • 266
  • 3
  • 9
5
votes
6 answers

Kerberos Configuration Manager for SQL Server error "unable to access user principal information from the system"

When I launch the Kerberos Configuration Manager for SQL Server and try to connect to the local machine it's on, I am getting the error "Kerberos Configuration Manager for SQL Server error "unable to access user principal information from the…
Geoff Dawdy
  • 213
  • 1
  • 2
  • 9
5
votes
1 answer

Why do I get prompted for "Data Source Credentials" when editing a SSRS report for SCCM?

When attempting to add a dataset in Report Builder I am prompted to "Enter Data Source Credentials." Choosing "Use the current Windows user" fails, and I don't have the password for the specified user. The environment is SCCM 2012. What…
Bin
  • 844
  • 5
  • 15
5
votes
0 answers

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 click the 'Create Report' button you get the…
user62491
5
votes
1 answer

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 I get the error "Unsufficient permissions". Then…
Aleksey Shubin
  • 191
  • 1
  • 1
  • 3
5
votes
4 answers

Windows Server 2008 R2 - How do I change IIS Settings?

I think I've looked through all the menus and control panel and I can't find anything to configure IIS. I feel like IIS is already installed because SQL Server Reporting services has a webpage running and a virtual directory.
4
votes
1 answer

Can I share one SPN between two service accounts?

I am running IIS and SQL Reporting Server on the same server. IIS runs as d\acct1 and SSRS is running as d\acct2. Initially, I registered an SPN HTTP/server.d.com for both d\acct1 and d\acct2 and configured both for unconstrained kerberos delegation…
Ryan Michela
  • 1,137
  • 3
  • 16
  • 23
4
votes
4 answers

Optimal SQL Server Reporting Services setup

I'd like to determine an optimal setup for SQL Server Reporting Services to use as the integrated reporting tool for SaaS web-based applications. All reports are pre-defined, so users pick a report and enter some parameters in a web-based front end.…
ddavis
  • 75
  • 1
  • 4
4
votes
3 answers

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 required permissions. Verify that sufficient…
Brandon Moore
  • 456
  • 2
  • 5
  • 17
4
votes
3 answers

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 Management Studio, but whenever a user tries to access…
triniMahn
  • 51
  • 1
  • 5
3
votes
2 answers

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. I asked the server administrator and the IIS should…
JJ
3
votes
1 answer

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 Configuration Manager Click Connect Clicked Web Services…
Andres Adhi
  • 41
  • 1
  • 4
1
2 3
16 17