Server Fault
Server Fault

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.

249 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
18
votes
5 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
  • 447
10
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.
  • 2,095
5
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,157
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
5
votes
7 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
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
  • 864
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
  • 201
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.
Greg_the_Ant
  • 479
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
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
  • 466
  • 2
  • 6
  • 17
4
votes
3 answers

How to grant 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
4
votes
2 answers

How to move a SQL Server Reporting Services installation to new server?

We just built a new cluster to replace to stand alone BI servers. Its running Windows 2003 x64 and SQL 2005. One instance is already running in production and we're getting ready to move another server's data onto a named instance of this…
sql_noob
  • 51
3
votes
1 answer

Can I use a gMSA for stored credentials in a SSRS data source?

I have an instance of SQL Server 2016 Reporting Services service running under DOMAIN\reporting$ containing a data source that needs to query a database using the stored credential DOMAIN\database$. Unfortunately when I store the gMSA credential and…
Mike
  • 1,303
1
2 3
…
16 17