this is a repeated attempt to get an explanation for a hopefully simple
problem.
The question: What causes RS to mark an user account as "unknown" as
described below and what has to be done in order to get rid of this?
Here the problem description:
<snip>
I got a clue what might be wrong on my server machines which do not allow
eMail subscription due to a "configuration error"
I have an XP machine here with a local SQL server and a local RS client and
server. If I look at the property page of a given report there is always
something like that (I have to translate it from german, so maybe it is a
bit different in english versions):
changed at: (datetime)
changed by: SPONGEBOB\roland
created at: (datetime)
created by: SPONGEBOB\roland
size: 8kb
SPONGEBOB is the name of the machine; roland the user account.
Whereas my server machines show up the following:
changed at: (datetime)
changed by: TACCO\Administrator (unknown)
created at: (datetime)
created by: TACCO\Administrator (unknown)
size: 8kb
TACCO is the server name; administrator the user account. My concern is the
"unknown", what exactly causes the problem with eMail subscription. What
does cause RS to print "unknown" there and how to come over it?
</snip>
TIA
roland
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roland" <roland....@gmx.de> wrote in message
news:execmMdV...@TK2MSFTNGP09.phx.gbl...
Hello Brian,
thanks for your answer. All of our observations point into the direction of
a policy or user rights problem. Besides the fact, that the SPONGEBOB
machine has the SQL server locally and the TACCO had a previous Sharepoint
installation (currently deinstalled) this "unknown" trace seems to be the
only difference between both setups for RS.
We have three problems with TACCO:
1) The "unknown" remark
2) Sometimes we get an error which complains about an "unknown user", mostly
on attempts to setup role properties for a given and correct user
3) The eMail subscription does not work.
Here is the log for 2)
aspnet_wp!library!918!05/24/2004-14:30:07:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
Der Benutzer- oder Gruppenname 'roland.klabunde[Unbekannt]' wird nicht
erkannt., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
Der Benutzer- oder Gruppenname 'roland.klabunde[Unbekannt]' wird nicht
erkannt.
Means: User or groupname roland.klabunde has not been recognized
Here is the log for 3)
ReportingServicesService!library!c20!05/24/2004-14:26:02:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files, AuthzInitializeContextFromSid: Win32 error: 87;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files
ReportingServicesService!emailextension!c20!05/24/2004-14:26:02:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files --->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files
Because I already made eMail subscription run on SPONGEBOB I'm currently
having no idea what might be wrong. As said the latest clue was that
"unknown" remark...
Hoping to finally overcome this problem
roland
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roland" <roland....@gmx.de> wrote in message
news:ucIk$9uVEH...@TK2MSFTNGP09.phx.gbl...
r.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roland" <roland....@gmx.net> wrote in message
news:OhFFPD3...@TK2MSFTNGP10.phx.gbl...
The answers to both of your questions is NO. Does this cause any problem?
r
* Windows 2000 Advanced Server German out of the box, SP 4, latest security
patches.
* No domain, no active directory, standard web server
* IIS 5
* RS eval
* RS running under System
* Websites under ASPNET
Same result: Administrator marked as unknown, eMail subscription fails.
r.
i have a similar or identical problem,
i have a virtual machine with windows 2003 server, sharepoint and active directory. I've installed reporting services runnings as domain user and I can't get a subscription (file shared or email) working.
If a put domain user I get this error in event viewer:
SQL Server Scheduled Job 'CD339E50-B023-428B-8FD8-41E2C9E68A22'
(0xAD0027F1F92BAB48BFC39DBE28FB0231) - Status: Failed - Invoked on: 2004-06-22
12:04:13 - Message: The job failed. Unable to determine if the owner
(TERRA\Administrator) of job CD339E50-B023-428B-8FD8-41E2C9E68A22 has server access
(reason: Could not obtain information about Windows NT group/user
'TERRA\Administrator'. [SQLSTATE 42000] (Error 8198)).
If I switch to NT Security I get this error on reporting services:
Failure writing file gráficos e listas: the Report Server has encountered a
configuration error; more details in the log files
I could use help on this one
The SQL is from memory so the exact syntax may be slightly different.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roland" <roland....@gmx.net> wrote in message
news:uaPVZaGW...@tk2msftngp13.phx.gbl...
> Here is the log. The OS is an english Win2k Advanced Server.
>
> I'm near to surrender. Five machines and one with OK eMail only...
>
> r
>
>
>
>
>
Thanks
roland