Thanks everyone!

I discovered something so weird I had not even guessed it. At some point the public role of this database was assigned permissions. 🙁 As Ed B surmised, so...

• This reply was modified 2 years, 9 months ago by  webrunner.

PS Actually, I have one more question.

I am still in this situation where I can't open SQL Server Configuration Manager. The resolution appears to be to restart the Windows Management...

Thanks so much, Eddie. This is the information I needed.

-- webrunner

Intriguing scenario. However, as I understand it, a Nobel Prize can be awarded only to a living person. It can't be awarded posthumously. By extrapolation, I assume it cannot therefore...

• This reply was modified 3 years ago by  webrunner.

Many thanks, Michael. You've provided the info I needed.

-- webrunner

Thanks, Ant-Green! Much appreciated.

-- webrunner

Thanks, Ant-Green! That is the info I needed.

-- webrunner

Great idea, thanks for this. For some reason I'd always thought of SSRS as client only, but it obviously can be really useful for DBA reports.

I would add backup-related reports.

Failed...

Thank you, Sergiy, I will look into finding the expensive query that is eating up space in tempdb.

-- webrunner

My two cents depending on the kind of organization. I don't mean "mature" or "less mature" in any judgmental way; I just mean the level of automation that the organization...

Thanks for the headline alone. I have been muttering that to myself for years. Lol.

-- webrunner

• This reply was modified 3 years, 5 months ago by  webrunner.

Thanks all. I will check with the clients because it could be something with the connection string. Thanks again.

-- webrunner

Thanks, Phil.

I checked one of the logins and its DEFAULT_DATABASE is [master].

Do you know why a login would try to access the other database during login if it isn't the...

Seems like this is a firewall issue, just FYI. Although the Report Server web site connects from the report server, Report Builder needs its own access from whichever computer it...

• This reply was modified 3 years, 5 months ago by  webrunner.

Thanks! I think it was something else - for some reason the format picks day/month (European?) instead of the US month/day format in the CSV. So the following two examples...