By your initial statement of you navigating to LocalHost, this tells me that either 1 - you are able to remote desktop into the box, or 2 - you are...

I agree. As long as the user executing the report has permission to the underlying objects such as the sys.columns table. We often lock the report user down to objects...

🙂

did you configure your rs using the reporting services configuration tool?

Sorry for the brevity. I'm on my iPone now! 🙂

We have a similar configuration, but I use a domain admin account to run the credentials. This domain admin account is also a sysadmin on ALL of our sql server...

Ahhhh.. I think I see your problem. You enabled anonymous authentication. It is not recommended that you enable this.

Disable that.

Apply the settings and then be sure you log...

Also, if there is a SQL Saturday near by, try to attend. If you are going to be in Orlando on October 17th, I'll be presenting SQL Server Reporting Services...

Gotcha!

So you can see the home page when you log in as the local admin. When you are logged in as the admin, do you see the Properties tab? See...

TIA,

Another option is to generate a temporary table on the fly based on what you are looking to do. The below may help with that.

/***************************************************

Author:Brian K. McDonald, MCDBA, MCSD

Date:9/3/2009

Purpose...

And you are logged in as the Administrator? You could also choose to "Run as Administrator" by right clicking the IE icon.

Beckham7_cq,

Yes you can send an email to distribution lists. You can just enter the distribution list name followed by @yourdomainname.com or whatever the extension is.

Good luck and take care,

Brian K....

JD,

Are you on a domain? Did you give yourself permissions to see the "Home" directory (ie. MACHINENAME\username)?

1. Log in as an administrator

2. Open the browser and navigate to http://localhost/reports

3. Click...

Thank you Andy! I look forward to writing more articles. I have what I feel are some pretty good ideas, now it is just MAKING the time to get them...

Puneet,

Unfortunately, your limitation will be on the SSRS side. The only thing that I can think of with the new details that you provided, would be to dynamically generate an...

If the amount of columns are reasonable to maintain, you may be able to hide individual columns should you wish to do so for a particular value and show only...