Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

need to enter Username/password when trying to view reports in report manager

Posted on 2015-02-13
15
Medium Priority
?
36 Views
Last Modified: 2015-07-10
some of my users are reporting that they need to enter a username and password when viewing reports in report manager.  Any reason why this would be happening?
0
Comment
Question by:vbnetcoder
[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
  • 8
  • 7
15 Comments
 
LVL 13

Expert Comment

by:LIONKING
ID: 40608562
Are you using Kerberos to authenticate users in SSRS?
0
 

Author Comment

by:vbnetcoder
ID: 40608567
I don't think so ... my client set up mostly everything but I don't think so.
0
 
LVL 13

Expert Comment

by:LIONKING
ID: 40608588
The reason why it would prompt for credentials is because the SSRS server isn't receiving the proper credentials from the client. It could be that you've specified Kerberos when you're not actually using it, or vice versa.
If you can, connect to the SSRS configuration and check the setting.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:vbnetcoder
ID: 40608624
Where would i look for that?
0
 
LVL 13

Expert Comment

by:LIONKING
ID: 40608657
Log in to the SSRS service from Management Studio, check to see if Windows Authentication is enabled. If all your users are domain users, then this should be enabled.
Kerberos is most likely set up and enabled, but that's a security setting that isn't up to you.

Are all your users being asked for credentials? Or just a subset of them?
0
 
LVL 13

Expert Comment

by:LIONKING
ID: 40608666
P.S. This is how you would check if Kerberos is the protocol that has been enabled.

Link: https://msdn.microsoft.com/en-us/library/cc281253(v=sql.110).aspx

By default, it's set to negotiate or NTLM. This setting should be good enough for most of the configurations.
0
 

Author Comment

by:vbnetcoder
ID: 40608670
How do i log into SSRS service from Management Studio? sorry i am very new with this setup work....
0
 
LVL 13

Expert Comment

by:LIONKING
ID: 40608679
In Management Studio, specifically in your object explorer, click on Connect, pick Reporting Services and connect to the server that hosts your SSRS installation.

It's pretty much like connecting to a normal SQL Database Server
0
 

Author Comment

by:vbnetcoder
ID: 40608736
Where do i go to look for the  RSReportServer.config?
0
 
LVL 13

Expert Comment

by:LIONKING
ID: 40608743
That you will find on the server itself, most probably through remote desktop.
0
 

Author Comment

by:vbnetcoder
ID: 40608756
but where to look for the physical file?
0
 
LVL 13

Accepted Solution

by:
LIONKING earned 2000 total points
ID: 40608782
Usually you'll find it in:

C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer
0
 

Author Comment

by:vbnetcoder
ID: 40614183
This is what mine says

<Authentication>
            <AuthenticationTypes>
                  <RSWindowsNTLM/>
            </AuthenticationTypes>
            <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
            <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
            <EnableAuthPersistence>true</EnableAuthPersistence>
      </Authentication>
0
 

Author Comment

by:vbnetcoder
ID: 40614191
I don't see a reference to Kerberos
0
 

Author Closing Comment

by:vbnetcoder
ID: 40876303
ty
0

Featured Post

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

604 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