SSRS 2005: UnknownUserNameException

[fuzzyocelot]

Hi everyone!

We have a server that is dedicated to Reporting Services 2005 only. The databases are on a separate server. The SSRS server is running Windows Server 2003 SP2.

Let's call the SSRS server, ServerA. Not too long ago, it's name was changed to ServerB. It's on a domain and the domain name was changed as well, I believe. I'll have to verify that. Anyway, it uses RSA security along with SSL. Right now every user login is set up as a local administrator on ServerB (long story). Let's say user "User3" tries to create a subscription for ReportABC. The report was originally created by User1 and later modified by User2. This new subscription is to write the report to a file share that exists on ServerB and it's supposed to run once. The file share exists. "User3" gets an error when she clicks the OK button after filling out the info for a new fileshare subscription. The error is "The user or group 'ServerA\User3' is not recognized." Please note that it used "ServerA" instead of "ServerB". This isn't good. The reports run fine otherwise. We just get this error every time we try to set up a subscription.

I checked and every single account within Report Manager (via the Web browser) is set to use "ServerB\UserX". So for example, User3's account is "ServerB\User3".

I also noticed that in the Users table in the ReportServer database there are several entries for users with "ServerA\UserX" instead of "ServerB\UserX". There are a couple for ServerB. The entry for User3 is "ServerA\User3".

I checked the Reporting Service error logs. I didn’t see much except for the excerpts below:

From the ReportServer log:

w3wp!library!a!07/02/2007-14:02:30:: i INFO: Call to GetPermissions:/Test/ReportABC
w3wp!library!1!07/02/2007-14:02:30:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'SERVERA\User3' is not recognized., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'SERVERA\User3' is not recognized.

The header does show the right server name:

<SystemName>SERVERB</SystemName>

From the ReportServerWebApp log:

 w3wp!extensionfactory!1!7/2/2007-14:02:09:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!1!7/2/2007-14:02:09:: w WARN: The extension Report Server FileShare does not have a LocalizedNameAttribute.
w3wp!ui!b!7/2/2007-14:02:32:: e ERROR: System.Web.Services.Protocols.SoapException: The user or group name 'SERVERA\User3 is not recognized. ---> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'SERVERA\User3 is not recognized.
--- End of inner exception stack trace ---

I think the new users are fine because the last two people entered into the system have the new server name (i.e. ServerB\UserX).

Since I know what table in the ReportServer database contains the user names (i.e. the Users table), I thought about changing one name manually to see what happens. I'm not sure if I'm going to try that yet.

Does anyone know where the problem could be? I'm not sure what to check next.

Thanks!!!