Search

Beep Beep Barf

Throw up from my brain onto my computer

Month

August 2015

Bloggity Blog

So after many years of resisting, I’ve started a blog. Not because I believe I have anything interesting to say or I think I need to reach out to people, but because it will form part of my extended memory.

Being a programmer requires me to remember so many tidbits of information it is crazy. The amount of obscure parcels of info relating to coding, configuration and hacks I have floating around my brain is hard to manage. Invariably, when you need to do this, your brain at some point will spring a leak and as new information comes in, somewhere in the haze something fades out of memory.

This blog is an attempt to keep some of these tidbits of information where I can find them, since my brain won’t agree to store them forever.

SQL Server Reporting Services Prompting for Credentials

I’ve run into this problem a couple of times, so I figured I’d post it so that I will remember next time…

The issue is that on the local machine where SSRS is installed, when accessing the report server URL in IE I keep getting prompted for a domain username and password. This problem is usually unique to the local machine only, where accessing the report server URL from a different machine will not trigger the prompt for credentials.

After much stuffing around, I figured out the issue is not related to the credentials SSRS uses to access the database server or database. The issue is with Internet Explorer.

Here’s what fixed it:

  1. Go to Tools and then Internet Options.
  2. Under the Security tab, click on Trusted sites and click the Sites button and Add Report Manager/Report Server URL to the zone.
  3. Then click Custom Level, and check the option Automatic logon with current user name and password.
  4. if necessary (it wasn’t for me, but was suggested elsewhere), repeat steps 2 and 3 for local intranet.

After following these steps, I no longer was prompted for domain credentials on the local machine.

Create a free website or blog at WordPress.com.

Up ↑