Solved

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

Posted on 2013-10-29
1
628 Views
Last Modified: 2013-10-29
Hello,

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 SSRS Web Service URL set to "All Assigned", and the Report Manager URL set to http://appreports.domain.com:80/reports & https://+:443/reports. DNS is pointing to .161. Also, SSRS points to an external database server.

What I am seeing is strange to me. I can browse to http://appreports.domain.com:80/reports on that server, and it looks great - I am at the SSRS Report Manager page, and all is well. When I call http://appreports.domain.com:80/reports from a different computer, I get an IIS error:

HTTP Error 404 - File or directory not found.
Internet Information Services (IIS)

I am not sure why IIS intercepts the call when accessed remotely. In the System log, I see this:

A Kerberos Error Message was received:
 on logon session
 Client Time:
 Server Time: 17:10:4.0000 10/29/2013 Z
 Error Code: 0x7  KDC_ERR_S_PRINCIPAL_UNKNOWN
 Extended Error: 0xc0000035 KLIN(0)
 Client Realm:
 Client Name:
 Server Realm: DOMAIN.LOCAL
 Server Name: MSSQLSvc/VM-db.domain.local:1433
 Target Name: MSSQLSvc/VM-db.domain.local:1433@Domain.LOCAL
 Error Text:
 File: 9
 Line: f09

In the ReportServerService log, there are no errors - it is the picture of health. I should also say that we are just trying to access http://appreports.domain.com:80/reports from within the local network.

I suspect there is an SPN issue, but I don't understand it well enough to comment. Thoughts most welcome! Naturally, max points on this one.
0
Comment
Question by:Ash_embers
1 Comment
 

Accepted Solution

by:
Ash_embers earned 0 total points
ID: 39610105
Never mind on this - turns out networking was messed up. Adding a new NIC and putting the IP there fixed everything.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question