I'd do this in my Query not in the report.

I'd do this in my Query not in the report.

If they are only gaining access via Builtin\Administrators then removing that access should stop them. Of course if your SQL Server is running under a Domain Account then they...

CirquedeSQLeil (2/4/2010)

---

Jack Corbett (2/4/2010)

---

How about this:

Select

domain,

Sum(Case when client = 1 then 1 else 0) as clients,

Sum(Case when client...

There are definitely some drawbacks here. You know what groups and individuals have access, but there is no way within SQL Server who are members of a Windows group....

Okay, here's a simple one:

SELECT

*

FROM

sys.server_principals AS SP

WHERE

type IN ('U','G')

To the best of my knowledge, and I don't have a link to point to (maybe I should blog about it, a hidden subreport will execute whether visible or...

I'm not sure exactly what you are asking. Do you want a list of Windows Logins and Groups that have access to the SQL Server or do you want...

In my opinion, this is the sort of thing that should be handled by your manager. Lowell is right that discussion needs to take place, but if your title...

How about this:

Select

domain,

Sum(Case when client = 1 then 1 else 0) as clients,

Sum(Case when client = o then...

I think today's featured article[/url] may help you.

I wish I knew the answer to this one. I don't because it looks like your setup is correct and should work.

I will say that I personally would not...

I'd suggest running a trace when you run the sp from SSMS and then from the SSRS Report. Verify that the issue is SQL Server. If you get...

Great article and useful information. As was shared earlier, by default SSRS only stores execution information for 60 days.

GilaMonster (2/4/2010)

---

Jack Corbett (2/3/2010)

---

Thanks for noticing. I was actually hoping to hit it in 2009, but...