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
1 answer

Installing SSRS add-in for MOSS 2007 keeps failing

I have a brand new MOSS install (MOSS 2007, Windows Server 2008 x64, SQL 2005 on separate server) and trying to install the add-in for SSRS but it keeps failing. During the install, I keep seeing application events such as these: Insufficient SQL…
Agent
  • 314
  • 4
  • 16
1
vote
1 answer

401: Unauthorized when connecting to Reporting Services

Ok, so here's the layout: We have our AppServer and our Database Server. Our AppServer is trying to connect to our Database Server which has Sql Reporting Services on it. However they are different machines with different domains. We have an Program…
user57862
1
vote
0 answers

SSRS Returning 401 Unauthorised Error when calling web service

We have two web servers that call the SSRS service to query the reports held there. Both servers are set up identically but while one works the other returns a 401 unauthorised exception when trying to query the list. The authentication type is NTLM…
ColinRobertson
  • 111
  • 2
1
vote
1 answer

TFS 2010 - Project Creation Fails

I am trying to create a new Project and I get the following Error: Error Insufficient Permissions to create a new SQL Server Report Services at mytfserver\DefaultCollection. Explanation The permissions granted your user name and ID on the SQL…
Vaccano
  • 1,027
  • 3
  • 16
  • 29
1
vote
1 answer

Security issues with Web Services and SSRS

I have a developer who would like to interact with the web services on the SSRS server. The way I understand it is that they would like to populate a list of reports in a folder so that the user can select which one they'd like to view. My initial…
jasoncrider
  • 134
  • 2
  • 13
1
vote
2 answers

Repeated Reporting Services Login issue when deploying through BIDS to a remote server

We are having a problem deploying a reporting services report to a sql reporting services computer that is configured in SharePoint Integrated mode. I can successfully deploy to the SharePoint document libraries set up for reports and data…
Richard Edwards
  • 121
  • 1
  • 5
1
vote
2 answers

SSRS 2008 Encryption Key reset after server reboot

I have a development XP (SP2) SQL 2008 box being actively used by developers. When this computer is restarted, the SSRS encryption keys become deactivated and the only way to get SSRS working again is to restore the encryption key with a current…
littlefuzz
  • 21
  • 7
1
vote
1 answer

SSRS Failing with error on App_global.asax

Our SSRS server has started failing. The Logs are currently showing the following error: System.BadImageFormatException: Could not load file or assembly 'file:///C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting…
Ben Jaguar Marshall
  • 131
  • 1
  • 6
1
vote
0 answers

Can SharePoint 2013 and Microsoft Dynamics GP 2013 run on the same server?

We have a new Windows 2012 server with SQL Server 2012 and Microsoft Dynamics GP 2013 running on it. I have been asked to install SharePoint 2013 on this server also. I know GP 2013 now uses SSRS for its reporting and we plan on integrating SSRS…
programmer
  • 155
  • 7
1
vote
1 answer

SQL Server Reporting Services Report Builder not starting as RemoteApp

A bunch of Users has been given access to a SQL Server 2008 R2 reporting services instance. Due to a policy the users only may access the services through a Remote Desktop instance. We have handed out Remote App links to the Internet Explorer…
the-wabbit
  • 40,737
  • 13
  • 111
  • 174
1
vote
1 answer

SQL Server 2012 Reporting Services need to repair

I had SQL 2012 installed with SSRS. Then I was playing with IIS and deleted (I think) ReportServer aliases and webs Now I need to work with SSRS but can't figure out how to return it back. Service is running, but I have no websites. I tried to start…
katit
  • 213
  • 4
  • 9
1
vote
1 answer

Configuring external SMTP server on Azure VM - messages staying in queue

I have an external SMTP provider: auth.smtp.1and1.co.uk I am trying to send SQL Server Reporting Services emails via this on an Windows 2012 Azure VM. It is configured sufficiently correctly for emails to be generated, but I've not configured…
Steph Locke
  • 127
  • 1
  • 8
1
vote
0 answers

SSRS reachable by FQDN on local computer, but not from a different computer

I am having trouble getting my SSRS server to successfully cohabitate with IIS, after having to move the server to a different subnet. I have 2 static IPs for that server: .242 is defined explicitly in IIS bindings, and .161 is for SSRS. I have my…
user171883
  • 45
  • 1
  • 6
1
vote
3 answers

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 installed SQL Server 2005 Express Advanced…
Oskar
  • 113
  • 1
  • 1
  • 4
1
vote
1 answer

SQL 2008 Reporting Service SSL certificate chain not trusted

I got a SQL Server 2008 Standard Edition installed on a Server 2008 R2, OS and SQL Server got newest Service Packs and updates installed. The SQL Server is up and running but I cant connect to the SSRS via Webinterface, every time i will get this…
hub
  • 342
  • 1
  • 4
  • 15
1 2 3
…
16 17