Solved

Report Manager URL Issue

Posted on 2013-11-27
4
443 Views
Last Modified: 2014-01-29
I am adding an additinal URL to Report Manager (SQL Server 2012) in addition to the locat address that is already there. If i click on the link to the local URL then the report directory comes right up. When i click on the link for new URL that i added it prompts me for credentials. No credentials that i try to include network administrator will get me in. I have searched the internet high and low and i have tried several configuration changes with different results but none have fixed my issue. Why would one work and not the other?

Thanks for you time.
0
Comment
Question by:drizzt34953
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 18

Expert Comment

by:x-men
ID: 39683808
register the SPN for the new URL
0
 

Author Comment

by:drizzt34953
ID: 39685265
Not familiar with this. How do i register the SPN for the new URL.

Thanks.
0
 
LVL 18

Accepted Solution

by:
x-men earned 500 total points
ID: 39713719
use "setspn.exe -L <domain>\<user>" (the domain user that runs the SSRS service) to check for something like:
HTTP/<the url you configured>:<port>

if not, use
setspn.exe -S HTTP/<the url you configured>:<port> <domain>\<user>

to register it.

more info at:http://technet.microsoft.com/en-us/library/ms191153.aspx
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

738 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