• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 38
  • Last Modified:

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

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
vbnetcoder
Asked:
vbnetcoder
  • 8
  • 7
1 Solution
 
LIONKINGCommented:
Are you using Kerberos to authenticate users in SSRS?
0
 
vbnetcoderAuthor Commented:
I don't think so ... my client set up mostly everything but I don't think so.
0
 
LIONKINGCommented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
vbnetcoderAuthor Commented:
Where would i look for that?
0
 
LIONKINGCommented:
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
 
LIONKINGCommented:
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
 
vbnetcoderAuthor Commented:
How do i log into SSRS service from Management Studio? sorry i am very new with this setup work....
0
 
LIONKINGCommented:
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
 
vbnetcoderAuthor Commented:
Where do i go to look for the  RSReportServer.config?
0
 
LIONKINGCommented:
That you will find on the server itself, most probably through remote desktop.
0
 
vbnetcoderAuthor Commented:
but where to look for the physical file?
0
 
LIONKINGCommented:
Usually you'll find it in:

C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer
0
 
vbnetcoderAuthor Commented:
This is what mine says

<Authentication>
            <AuthenticationTypes>
                  <RSWindowsNTLM/>
            </AuthenticationTypes>
            <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
            <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
            <EnableAuthPersistence>true</EnableAuthPersistence>
      </Authentication>
0
 
vbnetcoderAuthor Commented:
I don't see a reference to Kerberos
0
 
vbnetcoderAuthor Commented:
ty
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now