upgrade ssrs 2008 to ssrs 2008 r2

Question

upgrade ssrs 2008 to ssrs 2008 r2

Chuck 17099

Ten Centuries

Points: 1067
More actions
December 7, 2011 at 9:28 am

#264419

I have two servers. One with SQL 2008 and one with IIS and SSRS 2008. I upgraded both SQL 2008 and SSRS 2008 to 2008 R2. Prior to the upgrade SSRS was working fine. After the upgrade my web site connection to SQL is still working fine but SSRS will not access SQL. I'm using Kerberos and I'm getting an error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'". I modified the authentication section of teh rsreportserver.config file to read as follows:
<Authentication>
<AuthenticationTypes>
<RSWindowsNegotiate />
<RSWindowsKerberos />
<RSWindowsNTLM />
</AuthenticationTypes>
<RSWindowsExtendedProtectionLevel>Allow</RSWindowsExtendedProtectionLevel>
<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>
This did not solve the problem. I would appreciate any suggestions on how to fix this.
Thanks
Chuck

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113563 More actions · Answer 1

just done a quick google and it brought back a few results, but i think the social section of MS is offline as I cant connect,

dont know if you want to give them a try

the url's are

http://www.google.co.uk/url?sa=t&rct=j&q=ssrs%20login%20failed%20for%20user%20%27nt%20authority%20anonymous%20logon%27&source=web&cd=1&ved=0CCUQrAIoADAA&url=http%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Fen-US%2Fsqlsecurity%2Fthread%2F91f656cb-4e11-4a02-8b08-5a4bc16a1ec7%2F&ei=MJjfToy2F4qc-waWtpyPDw&usg=AFQjCNENZtf7vOGu6y90d17L3gKQUh8Hhg&cad=rja

and

http://www.google.co.uk/url?sa=t&rct=j&q=ssrs%20login%20failed%20for%20user%20%27nt%20authority%20anonymous%20logon%27&source=web&cd=1&ved=0CCAQFjAA&url=http%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Fen-US%2Fsqlreportingservices%2Fthread%2F240124f5-a400-4443-be5a-6ca3e0a93d00%2F&ei=MJjfToy2F4qc-waWtpyPDw&usg=AFQjCNE9F0gfoWcKTkFhP1K19yVc3OAxmQ&cad=rja

On a different note, does your website run from the SSRS box?

The dependency on IIS for SSRS was removed in 2008 onwards so its not required any more.

Chuck 17099 Ten Centuries Points: 1067 More actions · Answer 2

Hi Anthony,

Both links indicated that the site was off line.

SSRS and IIS are on the same box. I did this not because it was necisary but because I needed to spread out resources. I'm working off of four old 32 bit windows 2003 servers and am limited to 4 gigs of ram per box. I don't want SSRS on the same box as SQL but I'll do it if I have to.

Chuck

Chuck 17099 Ten Centuries Points: 1067 More actions · Answer 3

I gave up and put SSRS on the same box as SQL. This is the third time I've had a problem with the linking them up after something changed. It's not worth keeping them seperate.

Ant-Green SSC Guru Points: 113563 More actions · Answer 4

did you backup and restore the encryption keys for SSRS as part of the upgrade?