Wrong Modified By User ID

[Larry]

I have a very bizarre issue occurring on my SQL Reporting Server
(Windows Server 2003 SP2). For some reason, I'm getting the wrong
User ID set in the "Modified By" field whenever I deploy new reports,
or even actually make any modification via the web administrator.
While logged into my development PC as my domain ID, let's call it
"MyDomain\Larry", I deploy a new report to the reporting server. When
I look at the Reports web page, a local user on the server, let's call
it "George", is in the Modified By value for my report I just
deployed. It's like it isn't picking up that I'm logged into my PC as
"MyDomain\Larry", which happens to be in the local administrators
group on the reporting server. For some reason "George" also is in
the local administrator group. While I am "A" administrator on the
server, I'm not "THE" administrator of the server, so I don't know why
this local user is set up as an administrator as well. In any case, it
shouldn't matter one way or another. It's not like I'm logging in as
"George" anywhere. At one point the "MyDomain\Larry" ID was being set
properly in the Modified By field when I deployed reports, or created
folders, etc. via the web admin, but at some point, which I hadn't
noticed until recently, it changed to always using "George" for any
change. It appears to be using "George" for anyone that is deploying
or editing something as well, since another user, who is not in the
local administrators group, also is ending up with a Modified By value
of "George". I've done a bunch of Google searches for this issue, but
have come up empty.

Any help provided would be greatly appreciated!

Thanks in advance,

Larry

[Larry]

Post by Larry
I have a very bizarre issue occurring on my SQL Reporting Server
(Windows Server 2003 SP2).  For some reason, I'm getting the wrong
User ID set in the "Modified By" field whenever I deploy new reports,
or even actually make any modification via the web administrator.
While logged into my development PC as my domain ID, let's call it
"MyDomain\Larry", I deploy a new report to the reporting server.  When
I look at the Reports web page, a local user on the server, let's call
it "George", is in the Modified By value for my report I just
deployed.  It's like it isn't picking up that I'm logged into my PC as
"MyDomain\Larry", which happens to be in the local administrators
group on the reporting server.  For some reason "George" also is in
the local administrator group.  While I am "A" administrator on the
server, I'm not "THE" administrator of the server, so I don't know why
this local user is set up as an administrator as well. In any case, it
shouldn't matter one way or another. It's not like I'm logging in as
"George" anywhere. At one point the "MyDomain\Larry" ID was being set
properly in the Modified By field when I deployed reports, or created
folders, etc. via the web admin, but at some point, which I hadn't
noticed until recently, it changed to always using "George" for any
change.  It appears to be using "George" for anyone that is deploying
or editing something as well, since another user, who is not in the
local administrators group, also is ending up with a Modified By value
of "George".  I've done a bunch of Google searches for this issue, but
have come up empty.
Any help provided would be greatly appreciated!
Thanks in advance,
Larry

I should probably state that it's SQL Reporting Services 2005...

[Larry]

Post by Larry
I have a very bizarre issue occurring on my SQL Reporting Server
(Windows Server 2003 SP2).  For some reason, I'm getting the wrong
User ID set in the "Modified By" field whenever I deploy new reports,
or even actually make any modification via the web administrator.
While logged into my development PC as my domain ID, let's call it
"MyDomain\Larry", I deploy a new report to the reporting server.  When
I look at the Reports web page, a local user on the server, let's call
it "George", is in the Modified By value for my report I just
deployed.  It's like it isn't picking up that I'm logged into my PC as
"MyDomain\Larry", which happens to be in the local administrators
group on the reporting server.  For some reason "George" also is in
the local administrator group.  While I am "A" administrator on the
server, I'm not "THE" administrator of the server, so I don't know why
this local user is set up as an administrator as well. In any case, it
shouldn't matter one way or another. It's not like I'm logging in as
"George" anywhere. At one point the "MyDomain\Larry" ID was being set
properly in the Modified By field when I deployed reports, or created
folders, etc. via the web admin, but at some point, which I hadn't
noticed until recently, it changed to always using "George" for any
change.  It appears to be using "George" for anyone that is deploying
or editing something as well, since another user, who is not in the
local administrators group, also is ending up with a Modified By value
of "George".  I've done a bunch of Google searches for this issue, but
have come up empty.
Any help provided would be greatly appreciated!
Thanks in advance,
Larry

I should probably state that it's SQL Reporting Services 2005...- Hide quoted text -
- Show quoted text -

In case anyone cares, I figured out why this was occurring. For some
reason, the "George" user was created for a specific application, and
that ID was set up in the IIS Reports and ReportServer virtual
directory security settings as the Anonymous user. Anonymous was
turned on and Integrated Windows security was turned off. This
certainly is not the best security scheme for Reporting Server since
any modifications or access to Reporting Services would run under this
one local ID. Fortunately the application related to "George" was
moved to it's own server, so I was able to disable Anonymous, and re-
enable Integrated Windows security on both virtual directories, and
that solved the problem. Now whenever I deploy a report from my PC
logged in as "MyDomain\Larry", or use the web admin to modify
something, my ID is what is stamped in the "Modified By" value.

Larry