E-Mail and automated Fileserver saving does not working

Hi All,
I have a serious problem with my Reporting Server installation. Neither the
e-mail subscription nor the automated file creation on a share does not
work. I have tried it several times (including re-installing !!) - no
success.
I have the following (TEST !!) environment:
Server: 200Mhz (I know... it's just for testing !!)
OS: Win2003 with latest patches
Reporting Services: Enterprise with SP1
DB: MS Sql 2K SP3
SMTP is enabled on the server and working properly.
I cannot see any errormessages in the log files nor in the eventviewer.
After I have scheduled an e-mail subscription NOTHING happens, I even don't
get an errormessage on the "My subscription" page under last run. It just
says nothing, meaning, there is no last run...
There is also a session of SharePoint Portal 2003 installed on this machine
(problem ?).
Who out there has some experience with this set-up and can help me... I
start to get mad ;-(
Thanks for help !
Regards
/MartinThe first thing to check is if the ReportServer service is running. If it
is, next check the Sql Agent Job that the report server creates when a
schedule is created. See if this job has any history and if they are
successful.
Let me know what you find out and we can proceed from there.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Martin Schlenker" <Martinschlenker@.web.de> wrote in message
news:ejgRR1ahEHA.644@.tk2msftngp13.phx.gbl...
> Hi All,
> I have a serious problem with my Reporting Server installation. Neither
the
> e-mail subscription nor the automated file creation on a share does not
> work. I have tried it several times (including re-installing !!) - no
> success.
> I have the following (TEST !!) environment:
> Server: 200Mhz (I know... it's just for testing !!)
> OS: Win2003 with latest patches
> Reporting Services: Enterprise with SP1
> DB: MS Sql 2K SP3
> SMTP is enabled on the server and working properly.
> I cannot see any errormessages in the log files nor in the eventviewer.
> After I have scheduled an e-mail subscription NOTHING happens, I even
don't
> get an errormessage on the "My subscription" page under last run. It just
> says nothing, meaning, there is no last run...
> There is also a session of SharePoint Portal 2003 installed on this
machine
> (problem ?).
> Who out there has some experience with this set-up and can help me... I
> start to get mad ;-(
> Thanks for help !
> Regards
> /Martin
>
>|||Hi Daniel,
looks like you're on the right way...
This is the erromessage that I found:
The job failed. Unable to determine if the owner (<domain>\<username>) of
job 1303EC62-A3C7-4A15-814E-422C13ECC91F has server access (reason: Could
not obtain information about Windows NT group/user '<domain>\<username>'.
[SQLSTATE 42000] (Error 8198)).
I've changed the domain name and the username to the generic description
<domain> and <username>
The mentioned user is also member of the local administrators at the
Reporting Services Server.
Any idea ?
Regards and thanks so far...
/Martin
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im Newsbeitrag
news:uJ8qdzghEHA.3988@.tk2msftngp13.phx.gbl...
> The first thing to check is if the ReportServer service is running. If it
> is, next check the Sql Agent Job that the report server creates when a
> schedule is created. See if this job has any history and if they are
> successful.
> Let me know what you find out and we can proceed from there.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> news:ejgRR1ahEHA.644@.tk2msftngp13.phx.gbl...
>> Hi All,
>> I have a serious problem with my Reporting Server installation. Neither
> the
>> e-mail subscription nor the automated file creation on a share does not
>> work. I have tried it several times (including re-installing !!) - no
>> success.
>> I have the following (TEST !!) environment:
>> Server: 200Mhz (I know... it's just for testing !!)
>> OS: Win2003 with latest patches
>> Reporting Services: Enterprise with SP1
>> DB: MS Sql 2K SP3
>> SMTP is enabled on the server and working properly.
>> I cannot see any errormessages in the log files nor in the eventviewer.
>> After I have scheduled an e-mail subscription NOTHING happens, I even
> don't
>> get an errormessage on the "My subscription" page under last run. It just
>> says nothing, meaning, there is no last run...
>> There is also a session of SharePoint Portal 2003 installed on this
> machine
>> (problem ?).
>> Who out there has some experience with this set-up and can help me... I
>> start to get mad ;-(
>> Thanks for help !
>> Regards
>> /Martin
>>
>|||Most likely SQL agent is running as a user which can not access Active
Directory. The easiest solution is to use RSConfig to have the report
server use SQL Auth to connect to the database. If that is not an option
you would need to run SQL Server as a domain user.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Martin Schlenker" <Martinschlenker@.web.de> wrote in message
news:#sXPoPihEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Hi Daniel,
> looks like you're on the right way...
> This is the erromessage that I found:
> The job failed. Unable to determine if the owner (<domain>\<username>) of
> job 1303EC62-A3C7-4A15-814E-422C13ECC91F has server access (reason: Could
> not obtain information about Windows NT group/user '<domain>\<username>'.
> [SQLSTATE 42000] (Error 8198)).
>
> I've changed the domain name and the username to the generic description
> <domain> and <username>
>
> The mentioned user is also member of the local administrators at the
> Reporting Services Server.
>
> Any idea ?
>
> Regards and thanks so far...
> /Martin
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im Newsbeitrag
> news:uJ8qdzghEHA.3988@.tk2msftngp13.phx.gbl...
> > The first thing to check is if the ReportServer service is running. If
it
> > is, next check the Sql Agent Job that the report server creates when a
> > schedule is created. See if this job has any history and if they are
> > successful.
> >
> > Let me know what you find out and we can proceed from there.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> > news:ejgRR1ahEHA.644@.tk2msftngp13.phx.gbl...
> >> Hi All,
> >> I have a serious problem with my Reporting Server installation. Neither
> > the
> >> e-mail subscription nor the automated file creation on a share does not
> >> work. I have tried it several times (including re-installing !!) - no
> >> success.
> >> I have the following (TEST !!) environment:
> >>
> >> Server: 200Mhz (I know... it's just for testing !!)
> >>
> >> OS: Win2003 with latest patches
> >> Reporting Services: Enterprise with SP1
> >> DB: MS Sql 2K SP3
> >> SMTP is enabled on the server and working properly.
> >>
> >> I cannot see any errormessages in the log files nor in the eventviewer.
> >> After I have scheduled an e-mail subscription NOTHING happens, I even
> > don't
> >> get an errormessage on the "My subscription" page under last run. It
just
> >> says nothing, meaning, there is no last run...
> >>
> >> There is also a session of SharePoint Portal 2003 installed on this
> > machine
> >> (problem ?).
> >>
> >> Who out there has some experience with this set-up and can help me...
I
> >> start to get mad ;-(
> >>
> >> Thanks for help !
> >>
> >> Regards
> >> /Martin
> >>
> >>
> >>
> >
> >
>|||Daniel,
yep, today I have played a bit and couldn't solve it out. Anyhow, I haven't
tried what you suggest. Can you explain it a bit more in detail ? How can I
use RSConfig '
Thnx and best regards
/Martin
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im Newsbeitrag
news:OKk6pSthEHA.2604@.TK2MSFTNGP09.phx.gbl...
> Most likely SQL agent is running as a user which can not access Active
> Directory. The easiest solution is to use RSConfig to have the report
> server use SQL Auth to connect to the database. If that is not an option
> you would need to run SQL Server as a domain user.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> news:#sXPoPihEHA.1652@.TK2MSFTNGP09.phx.gbl...
>> Hi Daniel,
>> looks like you're on the right way...
>> This is the erromessage that I found:
>> The job failed. Unable to determine if the owner (<domain>\<username>)
>> of
>> job 1303EC62-A3C7-4A15-814E-422C13ECC91F has server access (reason: Could
>> not obtain information about Windows NT group/user '<domain>\<username>'.
>> [SQLSTATE 42000] (Error 8198)).
>>
>> I've changed the domain name and the username to the generic description
>> <domain> and <username>
>>
>> The mentioned user is also member of the local administrators at the
>> Reporting Services Server.
>>
>> Any idea ?
>>
>> Regards and thanks so far...
>> /Martin
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
>> Newsbeitrag
>> news:uJ8qdzghEHA.3988@.tk2msftngp13.phx.gbl...
>> > The first thing to check is if the ReportServer service is running. If
> it
>> > is, next check the Sql Agent Job that the report server creates when a
>> > schedule is created. See if this job has any history and if they are
>> > successful.
>> >
>> > Let me know what you find out and we can proceed from there.
>> >
>> > --
>> > -Daniel
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> >
>> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
>> > news:ejgRR1ahEHA.644@.tk2msftngp13.phx.gbl...
>> >> Hi All,
>> >> I have a serious problem with my Reporting Server installation.
>> >> Neither
>> > the
>> >> e-mail subscription nor the automated file creation on a share does
>> >> not
>> >> work. I have tried it several times (including re-installing !!) - no
>> >> success.
>> >> I have the following (TEST !!) environment:
>> >>
>> >> Server: 200Mhz (I know... it's just for testing !!)
>> >>
>> >> OS: Win2003 with latest patches
>> >> Reporting Services: Enterprise with SP1
>> >> DB: MS Sql 2K SP3
>> >> SMTP is enabled on the server and working properly.
>> >>
>> >> I cannot see any errormessages in the log files nor in the
>> >> eventviewer.
>> >> After I have scheduled an e-mail subscription NOTHING happens, I even
>> > don't
>> >> get an errormessage on the "My subscription" page under last run. It
> just
>> >> says nothing, meaning, there is no last run...
>> >>
>> >> There is also a session of SharePoint Portal 2003 installed on this
>> > machine
>> >> (problem ?).
>> >>
>> >> Who out there has some experience with this set-up and can help me...
> I
>> >> start to get mad ;-(
>> >>
>> >> Thanks for help !
>> >>
>> >> Regards
>> >> /Martin
>> >>
>> >>
>> >>
>> >
>> >
>>
>|||rsconfig is an admin tool shipped with RS. It allows you to change the way
RS connects to it's catalog. You can find more information on it here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Martin Schlenker" <Martinschlenker@.web.de> wrote in message
news:Oz7m8VvhEHA.2540@.TK2MSFTNGP10.phx.gbl...
> Daniel,
> yep, today I have played a bit and couldn't solve it out. Anyhow, I
haven't
> tried what you suggest. Can you explain it a bit more in detail ? How can
I
> use RSConfig '
> Thnx and best regards
> /Martin
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im Newsbeitrag
> news:OKk6pSthEHA.2604@.TK2MSFTNGP09.phx.gbl...
> > Most likely SQL agent is running as a user which can not access Active
> > Directory. The easiest solution is to use RSConfig to have the report
> > server use SQL Auth to connect to the database. If that is not an
option
> > you would need to run SQL Server as a domain user.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> > news:#sXPoPihEHA.1652@.TK2MSFTNGP09.phx.gbl...
> >> Hi Daniel,
> >> looks like you're on the right way...
> >> This is the erromessage that I found:
> >>
> >> The job failed. Unable to determine if the owner (<domain>\<username>)
> >> of
> >> job 1303EC62-A3C7-4A15-814E-422C13ECC91F has server access (reason:
Could
> >> not obtain information about Windows NT group/user
'<domain>\<username>'.
> >> [SQLSTATE 42000] (Error 8198)).
> >>
> >>
> >>
> >> I've changed the domain name and the username to the generic
description
> >> <domain> and <username>
> >>
> >>
> >>
> >> The mentioned user is also member of the local administrators at the
> >> Reporting Services Server.
> >>
> >>
> >>
> >> Any idea ?
> >>
> >>
> >>
> >> Regards and thanks so far...
> >>
> >> /Martin
> >>
> >>
> >>
> >> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
> >> Newsbeitrag
> >> news:uJ8qdzghEHA.3988@.tk2msftngp13.phx.gbl...
> >> > The first thing to check is if the ReportServer service is running.
If
> > it
> >> > is, next check the Sql Agent Job that the report server creates when
a
> >> > schedule is created. See if this job has any history and if they are
> >> > successful.
> >> >
> >> > Let me know what you find out and we can proceed from there.
> >> >
> >> > --
> >> > -Daniel
> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> >
> >> >
> >> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> >> > news:ejgRR1ahEHA.644@.tk2msftngp13.phx.gbl...
> >> >> Hi All,
> >> >> I have a serious problem with my Reporting Server installation.
> >> >> Neither
> >> > the
> >> >> e-mail subscription nor the automated file creation on a share does
> >> >> not
> >> >> work. I have tried it several times (including re-installing !!) -
no
> >> >> success.
> >> >> I have the following (TEST !!) environment:
> >> >>
> >> >> Server: 200Mhz (I know... it's just for testing !!)
> >> >>
> >> >> OS: Win2003 with latest patches
> >> >> Reporting Services: Enterprise with SP1
> >> >> DB: MS Sql 2K SP3
> >> >> SMTP is enabled on the server and working properly.
> >> >>
> >> >> I cannot see any errormessages in the log files nor in the
> >> >> eventviewer.
> >> >> After I have scheduled an e-mail subscription NOTHING happens, I
even
> >> > don't
> >> >> get an errormessage on the "My subscription" page under last run. It
> > just
> >> >> says nothing, meaning, there is no last run...
> >> >>
> >> >> There is also a session of SharePoint Portal 2003 installed on this
> >> > machine
> >> >> (problem ?).
> >> >>
> >> >> Who out there has some experience with this set-up and can help
me...
> > I
> >> >> start to get mad ;-(
> >> >>
> >> >> Thanks for help !
> >> >>
> >> >> Regards
> >> >> /Martin
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||Daniel,
thnx for information...
Meanwhile I have found something about this tool but I haven't changed some
options of my reporting services. But I have changed the account of the SQL
Server service thru a domain account - no success. The service runs
afterwards but the errormessage is still the same...
I'll try the other option you mentioned earlier... unfortunatly I am at
home now... will keep you informed...
Thanks and best regards
/Martin
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im Newsbeitrag
news:%23hzuwFTiEHA.4020@.TK2MSFTNGP10.phx.gbl...
> rsconfig is an admin tool shipped with RS. It allows you to change the
> way
> RS connects to it's catalog. You can find more information on it here:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> news:Oz7m8VvhEHA.2540@.TK2MSFTNGP10.phx.gbl...
>> Daniel,
>> yep, today I have played a bit and couldn't solve it out. Anyhow, I
> haven't
>> tried what you suggest. Can you explain it a bit more in detail ? How can
> I
>> use RSConfig '
>> Thnx and best regards
>> /Martin
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
>> Newsbeitrag
>> news:OKk6pSthEHA.2604@.TK2MSFTNGP09.phx.gbl...
>> > Most likely SQL agent is running as a user which can not access Active
>> > Directory. The easiest solution is to use RSConfig to have the report
>> > server use SQL Auth to connect to the database. If that is not an
> option
>> > you would need to run SQL Server as a domain user.
>> >
>> > --
>> > -Daniel
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> >
>> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
>> > news:#sXPoPihEHA.1652@.TK2MSFTNGP09.phx.gbl...
>> >> Hi Daniel,
>> >> looks like you're on the right way...
>> >> This is the erromessage that I found:
>> >>
>> >> The job failed. Unable to determine if the owner
>> >> (<domain>\<username>)
>> >> of
>> >> job 1303EC62-A3C7-4A15-814E-422C13ECC91F has server access (reason:
> Could
>> >> not obtain information about Windows NT group/user
> '<domain>\<username>'.
>> >> [SQLSTATE 42000] (Error 8198)).
>> >>
>> >>
>> >>
>> >> I've changed the domain name and the username to the generic
> description
>> >> <domain> and <username>
>> >>
>> >>
>> >>
>> >> The mentioned user is also member of the local administrators at the
>> >> Reporting Services Server.
>> >>
>> >>
>> >>
>> >> Any idea ?
>> >>
>> >>
>> >>
>> >> Regards and thanks so far...
>> >>
>> >> /Martin
>> >>
>> >>
>> >>
>> >> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
>> >> Newsbeitrag
>> >> news:uJ8qdzghEHA.3988@.tk2msftngp13.phx.gbl...
>> >> > The first thing to check is if the ReportServer service is running.
> If
>> > it
>> >> > is, next check the Sql Agent Job that the report server creates when
> a
>> >> > schedule is created. See if this job has any history and if they
>> >> > are
>> >> > successful.
>> >> >
>> >> > Let me know what you find out and we can proceed from there.
>> >> >
>> >> > --
>> >> > -Daniel
>> >> > This posting is provided "AS IS" with no warranties, and confers no
>> >> > rights.
>> >> >
>> >> >
>> >> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
>> >> > news:ejgRR1ahEHA.644@.tk2msftngp13.phx.gbl...
>> >> >> Hi All,
>> >> >> I have a serious problem with my Reporting Server installation.
>> >> >> Neither
>> >> > the
>> >> >> e-mail subscription nor the automated file creation on a share does
>> >> >> not
>> >> >> work. I have tried it several times (including re-installing !!) -
> no
>> >> >> success.
>> >> >> I have the following (TEST !!) environment:
>> >> >>
>> >> >> Server: 200Mhz (I know... it's just for testing !!)
>> >> >>
>> >> >> OS: Win2003 with latest patches
>> >> >> Reporting Services: Enterprise with SP1
>> >> >> DB: MS Sql 2K SP3
>> >> >> SMTP is enabled on the server and working properly.
>> >> >>
>> >> >> I cannot see any errormessages in the log files nor in the
>> >> >> eventviewer.
>> >> >> After I have scheduled an e-mail subscription NOTHING happens, I
> even
>> >> > don't
>> >> >> get an errormessage on the "My subscription" page under last run.
>> >> >> It
>> > just
>> >> >> says nothing, meaning, there is no last run...
>> >> >>
>> >> >> There is also a session of SharePoint Portal 2003 installed on this
>> >> > machine
>> >> >> (problem ?).
>> >> >>
>> >> >> Who out there has some experience with this set-up and can help
> me...
>> > I
>> >> >> start to get mad ;-(
>> >> >>
>> >> >> Thanks for help !
>> >> >>
>> >> >> Regards
>> >> >> /Martin
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>|||Daniel,
as pointed out in my other mail. I now have changed the account via RSconfig
to run report server to use SQL Auth. --> no success
I also changed the user account for SQL Server to an administrative account
from the domain --> no success
It really starts to bother me... ;-(
Any other idea ?
Thanks and best regards
/Martin
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im Newsbeitrag
news:%23hzuwFTiEHA.4020@.TK2MSFTNGP10.phx.gbl...
> rsconfig is an admin tool shipped with RS. It allows you to change the
> way
> RS connects to it's catalog. You can find more information on it here:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> news:Oz7m8VvhEHA.2540@.TK2MSFTNGP10.phx.gbl...
>> Daniel,
>> yep, today I have played a bit and couldn't solve it out. Anyhow, I
> haven't
>> tried what you suggest. Can you explain it a bit more in detail ? How can
> I
>> use RSConfig '
>> Thnx and best regards
>> /Martin
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
>> Newsbeitrag
>> news:OKk6pSthEHA.2604@.TK2MSFTNGP09.phx.gbl...
>> > Most likely SQL agent is running as a user which can not access Active
>> > Directory. The easiest solution is to use RSConfig to have the report
>> > server use SQL Auth to connect to the database. If that is not an
> option
>> > you would need to run SQL Server as a domain user.
>> >
>> > --
>> > -Daniel
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> >
>> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
>> > news:#sXPoPihEHA.1652@.TK2MSFTNGP09.phx.gbl...
>> >> Hi Daniel,
>> >> looks like you're on the right way...
>> >> This is the erromessage that I found:
>> >>
>> >> The job failed. Unable to determine if the owner
>> >> (<domain>\<username>)
>> >> of
>> >> job 1303EC62-A3C7-4A15-814E-422C13ECC91F has server access (reason:
> Could
>> >> not obtain information about Windows NT group/user
> '<domain>\<username>'.
>> >> [SQLSTATE 42000] (Error 8198)).
>> >>
>> >>
>> >>
>> >> I've changed the domain name and the username to the generic
> description
>> >> <domain> and <username>
>> >>
>> >>
>> >>
>> >> The mentioned user is also member of the local administrators at the
>> >> Reporting Services Server.
>> >>
>> >>
>> >>
>> >> Any idea ?
>> >>
>> >>
>> >>
>> >> Regards and thanks so far...
>> >>
>> >> /Martin
>> >>
>> >>
>> >>
>> >> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
>> >> Newsbeitrag
>> >> news:uJ8qdzghEHA.3988@.tk2msftngp13.phx.gbl...
>> >> > The first thing to check is if the ReportServer service is running.
> If
>> > it
>> >> > is, next check the Sql Agent Job that the report server creates when
> a
>> >> > schedule is created. See if this job has any history and if they
>> >> > are
>> >> > successful.
>> >> >
>> >> > Let me know what you find out and we can proceed from there.
>> >> >
>> >> > --
>> >> > -Daniel
>> >> > This posting is provided "AS IS" with no warranties, and confers no
>> >> > rights.
>> >> >
>> >> >
>> >> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
>> >> > news:ejgRR1ahEHA.644@.tk2msftngp13.phx.gbl...
>> >> >> Hi All,
>> >> >> I have a serious problem with my Reporting Server installation.
>> >> >> Neither
>> >> > the
>> >> >> e-mail subscription nor the automated file creation on a share does
>> >> >> not
>> >> >> work. I have tried it several times (including re-installing !!) -
> no
>> >> >> success.
>> >> >> I have the following (TEST !!) environment:
>> >> >>
>> >> >> Server: 200Mhz (I know... it's just for testing !!)
>> >> >>
>> >> >> OS: Win2003 with latest patches
>> >> >> Reporting Services: Enterprise with SP1
>> >> >> DB: MS Sql 2K SP3
>> >> >> SMTP is enabled on the server and working properly.
>> >> >>
>> >> >> I cannot see any errormessages in the log files nor in the
>> >> >> eventviewer.
>> >> >> After I have scheduled an e-mail subscription NOTHING happens, I
> even
>> >> > don't
>> >> >> get an errormessage on the "My subscription" page under last run.
>> >> >> It
>> > just
>> >> >> says nothing, meaning, there is no last run...
>> >> >>
>> >> >> There is also a session of SharePoint Portal 2003 installed on this
>> >> > machine
>> >> >> (problem ?).
>> >> >>
>> >> >> Who out there has some experience with this set-up and can help
> me...
>> > I
>> >> >> start to get mad ;-(
>> >> >>
>> >> >> Thanks for help !
>> >> >>
>> >> >> Regards
>> >> >> /Martin
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>|||When you changed the account to sql auth did you recreate the subscriptions
(I know I forgot to mention that). If so were you getting the same error?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Martin Schlenker" <Martinschlenker@.web.de> wrote in message
news:eNuLc8fiEHA.396@.TK2MSFTNGP12.phx.gbl...
> Daniel,
> as pointed out in my other mail. I now have changed the account via
RSconfig
> to run report server to use SQL Auth. --> no success
> I also changed the user account for SQL Server to an administrative
account
> from the domain --> no success
> It really starts to bother me... ;-(
> Any other idea ?
> Thanks and best regards
> /Martin
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im Newsbeitrag
> news:%23hzuwFTiEHA.4020@.TK2MSFTNGP10.phx.gbl...
> > rsconfig is an admin tool shipped with RS. It allows you to change the
> > way
> > RS connects to it's catalog. You can find more information on it here:
> >
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> > news:Oz7m8VvhEHA.2540@.TK2MSFTNGP10.phx.gbl...
> >> Daniel,
> >> yep, today I have played a bit and couldn't solve it out. Anyhow, I
> > haven't
> >> tried what you suggest. Can you explain it a bit more in detail ? How
can
> > I
> >> use RSConfig '
> >>
> >> Thnx and best regards
> >> /Martin
> >>
> >> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
> >> Newsbeitrag
> >> news:OKk6pSthEHA.2604@.TK2MSFTNGP09.phx.gbl...
> >> > Most likely SQL agent is running as a user which can not access
Active
> >> > Directory. The easiest solution is to use RSConfig to have the
report
> >> > server use SQL Auth to connect to the database. If that is not an
> > option
> >> > you would need to run SQL Server as a domain user.
> >> >
> >> > --
> >> > -Daniel
> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> >
> >> >
> >> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> >> > news:#sXPoPihEHA.1652@.TK2MSFTNGP09.phx.gbl...
> >> >> Hi Daniel,
> >> >> looks like you're on the right way...
> >> >> This is the erromessage that I found:
> >> >>
> >> >> The job failed. Unable to determine if the owner
> >> >> (<domain>\<username>)
> >> >> of
> >> >> job 1303EC62-A3C7-4A15-814E-422C13ECC91F has server access (reason:
> > Could
> >> >> not obtain information about Windows NT group/user
> > '<domain>\<username>'.
> >> >> [SQLSTATE 42000] (Error 8198)).
> >> >>
> >> >>
> >> >>
> >> >> I've changed the domain name and the username to the generic
> > description
> >> >> <domain> and <username>
> >> >>
> >> >>
> >> >>
> >> >> The mentioned user is also member of the local administrators at the
> >> >> Reporting Services Server.
> >> >>
> >> >>
> >> >>
> >> >> Any idea ?
> >> >>
> >> >>
> >> >>
> >> >> Regards and thanks so far...
> >> >>
> >> >> /Martin
> >> >>
> >> >>
> >> >>
> >> >> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
> >> >> Newsbeitrag
> >> >> news:uJ8qdzghEHA.3988@.tk2msftngp13.phx.gbl...
> >> >> > The first thing to check is if the ReportServer service is
running.
> > If
> >> > it
> >> >> > is, next check the Sql Agent Job that the report server creates
when
> > a
> >> >> > schedule is created. See if this job has any history and if they
> >> >> > are
> >> >> > successful.
> >> >> >
> >> >> > Let me know what you find out and we can proceed from there.
> >> >> >
> >> >> > --
> >> >> > -Daniel
> >> >> > This posting is provided "AS IS" with no warranties, and confers
no
> >> >> > rights.
> >> >> >
> >> >> >
> >> >> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> >> >> > news:ejgRR1ahEHA.644@.tk2msftngp13.phx.gbl...
> >> >> >> Hi All,
> >> >> >> I have a serious problem with my Reporting Server installation.
> >> >> >> Neither
> >> >> > the
> >> >> >> e-mail subscription nor the automated file creation on a share
does
> >> >> >> not
> >> >> >> work. I have tried it several times (including re-installing
!!) -
> > no
> >> >> >> success.
> >> >> >> I have the following (TEST !!) environment:
> >> >> >>
> >> >> >> Server: 200Mhz (I know... it's just for testing !!)
> >> >> >>
> >> >> >> OS: Win2003 with latest patches
> >> >> >> Reporting Services: Enterprise with SP1
> >> >> >> DB: MS Sql 2K SP3
> >> >> >> SMTP is enabled on the server and working properly.
> >> >> >>
> >> >> >> I cannot see any errormessages in the log files nor in the
> >> >> >> eventviewer.
> >> >> >> After I have scheduled an e-mail subscription NOTHING happens, I
> > even
> >> >> > don't
> >> >> >> get an errormessage on the "My subscription" page under last run.
> >> >> >> It
> >> > just
> >> >> >> says nothing, meaning, there is no last run...
> >> >> >>
> >> >> >> There is also a session of SharePoint Portal 2003 installed on
this
> >> >> > machine
> >> >> >> (problem ?).
> >> >> >>
> >> >> >> Who out there has some experience with this set-up and can help
> > me...
> >> > I
> >> >> >> start to get mad ;-(
> >> >> >>
> >> >> >> Thanks for help !
> >> >> >>
> >> >> >> Regards
> >> >> >> /Martin
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||Daniel,
sorry for the delay and thanks for your enthusiastic effort !
Well, I am not sure if I've done this. So far I've some timing problems to
work with the Report Server at the moment as I've other things with higher
priority to do. I will try it out again within the next week an will let you
know - hope this works...
Kind regards
/Martin
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im Newsbeitrag
news:uJvRkasiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> When you changed the account to sql auth did you recreate the
> subscriptions
> (I know I forgot to mention that). If so were you getting the same error?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> news:eNuLc8fiEHA.396@.TK2MSFTNGP12.phx.gbl...
>> Daniel,
>> as pointed out in my other mail. I now have changed the account via
> RSconfig
>> to run report server to use SQL Auth. --> no success
>> I also changed the user account for SQL Server to an administrative
> account
>> from the domain --> no success
>> It really starts to bother me... ;-(
>> Any other idea ?
>> Thanks and best regards
>> /Martin
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
>> Newsbeitrag
>> news:%23hzuwFTiEHA.4020@.TK2MSFTNGP10.phx.gbl...
>> > rsconfig is an admin tool shipped with RS. It allows you to change the
>> > way
>> > RS connects to it's catalog. You can find more information on it here:
>> >
>> >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
>> >
>> > --
>> > -Daniel
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> >
>> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
>> > news:Oz7m8VvhEHA.2540@.TK2MSFTNGP10.phx.gbl...
>> >> Daniel,
>> >> yep, today I have played a bit and couldn't solve it out. Anyhow, I
>> > haven't
>> >> tried what you suggest. Can you explain it a bit more in detail ? How
> can
>> > I
>> >> use RSConfig '
>> >>
>> >> Thnx and best regards
>> >> /Martin
>> >>
>> >> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
>> >> Newsbeitrag
>> >> news:OKk6pSthEHA.2604@.TK2MSFTNGP09.phx.gbl...
>> >> > Most likely SQL agent is running as a user which can not access
> Active
>> >> > Directory. The easiest solution is to use RSConfig to have the
> report
>> >> > server use SQL Auth to connect to the database. If that is not an
>> > option
>> >> > you would need to run SQL Server as a domain user.
>> >> >
>> >> > --
>> >> > -Daniel
>> >> > This posting is provided "AS IS" with no warranties, and confers no
>> >> > rights.
>> >> >
>> >> >
>> >> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
>> >> > news:#sXPoPihEHA.1652@.TK2MSFTNGP09.phx.gbl...
>> >> >> Hi Daniel,
>> >> >> looks like you're on the right way...
>> >> >> This is the erromessage that I found:
>> >> >>
>> >> >> The job failed. Unable to determine if the owner
>> >> >> (<domain>\<username>)
>> >> >> of
>> >> >> job 1303EC62-A3C7-4A15-814E-422C13ECC91F has server access (reason:
>> > Could
>> >> >> not obtain information about Windows NT group/user
>> > '<domain>\<username>'.
>> >> >> [SQLSTATE 42000] (Error 8198)).
>> >> >>
>> >> >>
>> >> >>
>> >> >> I've changed the domain name and the username to the generic
>> > description
>> >> >> <domain> and <username>
>> >> >>
>> >> >>
>> >> >>
>> >> >> The mentioned user is also member of the local administrators at
>> >> >> the
>> >> >> Reporting Services Server.
>> >> >>
>> >> >>
>> >> >>
>> >> >> Any idea ?
>> >> >>
>> >> >>
>> >> >>
>> >> >> Regards and thanks so far...
>> >> >>
>> >> >> /Martin
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
>> >> >> Newsbeitrag
>> >> >> news:uJ8qdzghEHA.3988@.tk2msftngp13.phx.gbl...
>> >> >> > The first thing to check is if the ReportServer service is
> running.
>> > If
>> >> > it
>> >> >> > is, next check the Sql Agent Job that the report server creates
> when
>> > a
>> >> >> > schedule is created. See if this job has any history and if they
>> >> >> > are
>> >> >> > successful.
>> >> >> >
>> >> >> > Let me know what you find out and we can proceed from there.
>> >> >> >
>> >> >> > --
>> >> >> > -Daniel
>> >> >> > This posting is provided "AS IS" with no warranties, and confers
> no
>> >> >> > rights.
>> >> >> >
>> >> >> >
>> >> >> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
>> >> >> > news:ejgRR1ahEHA.644@.tk2msftngp13.phx.gbl...
>> >> >> >> Hi All,
>> >> >> >> I have a serious problem with my Reporting Server installation.
>> >> >> >> Neither
>> >> >> > the
>> >> >> >> e-mail subscription nor the automated file creation on a share
> does
>> >> >> >> not
>> >> >> >> work. I have tried it several times (including re-installing
> !!) -
>> > no
>> >> >> >> success.
>> >> >> >> I have the following (TEST !!) environment:
>> >> >> >>
>> >> >> >> Server: 200Mhz (I know... it's just for testing !!)
>> >> >> >>
>> >> >> >> OS: Win2003 with latest patches
>> >> >> >> Reporting Services: Enterprise with SP1
>> >> >> >> DB: MS Sql 2K SP3
>> >> >> >> SMTP is enabled on the server and working properly.
>> >> >> >>
>> >> >> >> I cannot see any errormessages in the log files nor in the
>> >> >> >> eventviewer.
>> >> >> >> After I have scheduled an e-mail subscription NOTHING happens, I
>> > even
>> >> >> > don't
>> >> >> >> get an errormessage on the "My subscription" page under last
>> >> >> >> run.
>> >> >> >> It
>> >> > just
>> >> >> >> says nothing, meaning, there is no last run...
>> >> >> >>
>> >> >> >> There is also a session of SharePoint Portal 2003 installed on
> this
>> >> >> > machine
>> >> >> >> (problem ?).
>> >> >> >>
>> >> >> >> Who out there has some experience with this set-up and can help
>> > me...
>> >> > I
>> >> >> >> start to get mad ;-(
>> >> >> >>
>> >> >> >> Thanks for help !
>> >> >> >>
>> >> >> >> Regards
>> >> >> >> /Martin
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>|||You said:
When I run it as a local user the Job on the SQL Server runs fine but I then
get an error on the reportserver service (to find in the log) where it says
that the user has no rights to query SIDs from the domain...
When you run what? The job? The report server service? The connection to
the report server catalog? The error looks to be that the user that the
ReportServer service is running as does not have permission to query SIDs
from the domain. This should be a domain account with sufficient
privileges. If it is not running as a domain account, before you switch,
make sure to run rskeymgmt to export the symmetric key, after you change the
user run rskeymgmt again to reimport the symmetric key.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Martin Schlenker" <Martin Schlenker@.discussions.microsoft.com> wrote in
message news:70B106ED-1B1E-4DA1-843E-BAB3BA4CD889@.microsoft.com...
> Daniel,
> ok, I've tried a couple of combinations...
> When I run the service with a domain account I got the error message that
> the Job itself cannot verify if the user has domain acces rights
> (SQLSTATE(error 42000)).
> When I run it as a local user the Job on the SQL Server runs fine but I
then
> get an error on the reportserver service (to find in the log) where it
says
> that the user has no rights to query SIDs from the domain...
> What other options do I have then '
> Kind regards
> /Martin
> "Daniel Reib [MSFT]" wrote:
> > When you changed the account to sql auth did you recreate the
subscriptions
> > (I know I forgot to mention that). If so were you getting the same
error?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> > news:eNuLc8fiEHA.396@.TK2MSFTNGP12.phx.gbl...
> > > Daniel,
> > > as pointed out in my other mail. I now have changed the account via
> > RSconfig
> > > to run report server to use SQL Auth. --> no success
> > > I also changed the user account for SQL Server to an administrative
> > account
> > > from the domain --> no success
> > >
> > > It really starts to bother me... ;-(
> > >
> > > Any other idea ?
> > >
> > > Thanks and best regards
> > > /Martin
> > >
> > >
> > > "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
Newsbeitrag
> > > news:%23hzuwFTiEHA.4020@.TK2MSFTNGP10.phx.gbl...
> > > > rsconfig is an admin tool shipped with RS. It allows you to change
the
> > > > way
> > > > RS connects to it's catalog. You can find more information on it
here:
> > > >
> > > >
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > > rights.
> > > >
> > > >
> > > > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> > > > news:Oz7m8VvhEHA.2540@.TK2MSFTNGP10.phx.gbl...
> > > >> Daniel,
> > > >> yep, today I have played a bit and couldn't solve it out. Anyhow, I
> > > > haven't
> > > >> tried what you suggest. Can you explain it a bit more in detail ?
How
> > can
> > > > I
> > > >> use RSConfig '
> > > >>
> > > >> Thnx and best regards
> > > >> /Martin
> > > >>
> > > >> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
> > > >> Newsbeitrag
> > > >> news:OKk6pSthEHA.2604@.TK2MSFTNGP09.phx.gbl...
> > > >> > Most likely SQL agent is running as a user which can not access
> > Active
> > > >> > Directory. The easiest solution is to use RSConfig to have the
> > report
> > > >> > server use SQL Auth to connect to the database. If that is not
an
> > > > option
> > > >> > you would need to run SQL Server as a domain user.
> > > >> >
> > > >> > --
> > > >> > -Daniel
> > > >> > This posting is provided "AS IS" with no warranties, and confers
no
> > > >> > rights.
> > > >> >
> > > >> >
> > > >> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> > > >> > news:#sXPoPihEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > > >> >> Hi Daniel,
> > > >> >> looks like you're on the right way...
> > > >> >> This is the erromessage that I found:
> > > >> >>
> > > >> >> The job failed. Unable to determine if the owner
> > > >> >> (<domain>\<username>)
> > > >> >> of
> > > >> >> job 1303EC62-A3C7-4A15-814E-422C13ECC91F has server access
(reason:
> > > > Could
> > > >> >> not obtain information about Windows NT group/user
> > > > '<domain>\<username>'.
> > > >> >> [SQLSTATE 42000] (Error 8198)).
> > > >> >>
> > > >> >>
> > > >> >>
> > > >> >> I've changed the domain name and the username to the generic
> > > > description
> > > >> >> <domain> and <username>
> > > >> >>
> > > >> >>
> > > >> >>
> > > >> >> The mentioned user is also member of the local administrators at
the
> > > >> >> Reporting Services Server.
> > > >> >>
> > > >> >>
> > > >> >>
> > > >> >> Any idea ?
> > > >> >>
> > > >> >>
> > > >> >>
> > > >> >> Regards and thanks so far...
> > > >> >>
> > > >> >> /Martin
> > > >> >>
> > > >> >>
> > > >> >>
> > > >> >> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
> > > >> >> Newsbeitrag
> > > >> >> news:uJ8qdzghEHA.3988@.tk2msftngp13.phx.gbl...
> > > >> >> > The first thing to check is if the ReportServer service is
> > running.
> > > > If
> > > >> > it
> > > >> >> > is, next check the Sql Agent Job that the report server
creates
> > when
> > > > a
> > > >> >> > schedule is created. See if this job has any history and if
they
> > > >> >> > are
> > > >> >> > successful.
> > > >> >> >
> > > >> >> > Let me know what you find out and we can proceed from there.
> > > >> >> >
> > > >> >> > --
> > > >> >> > -Daniel
> > > >> >> > This posting is provided "AS IS" with no warranties, and
confers
> > no
> > > >> >> > rights.
> > > >> >> >
> > > >> >> >
> > > >> >> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
> > > >> >> > news:ejgRR1ahEHA.644@.tk2msftngp13.phx.gbl...
> > > >> >> >> Hi All,
> > > >> >> >> I have a serious problem with my Reporting Server
installation.
> > > >> >> >> Neither
> > > >> >> > the
> > > >> >> >> e-mail subscription nor the automated file creation on a
share
> > does
> > > >> >> >> not
> > > >> >> >> work. I have tried it several times (including re-installing
> > !!) -
> > > > no
> > > >> >> >> success.
> > > >> >> >> I have the following (TEST !!) environment:
> > > >> >> >>
> > > >> >> >> Server: 200Mhz (I know... it's just for testing !!)
> > > >> >> >>
> > > >> >> >> OS: Win2003 with latest patches
> > > >> >> >> Reporting Services: Enterprise with SP1
> > > >> >> >> DB: MS Sql 2K SP3
> > > >> >> >> SMTP is enabled on the server and working properly.
> > > >> >> >>
> > > >> >> >> I cannot see any errormessages in the log files nor in the
> > > >> >> >> eventviewer.
> > > >> >> >> After I have scheduled an e-mail subscription NOTHING
happens, I
> > > > even
> > > >> >> > don't
> > > >> >> >> get an errormessage on the "My subscription" page under last
run.
> > > >> >> >> It
> > > >> > just
> > > >> >> >> says nothing, meaning, there is no last run...
> > > >> >> >>
> > > >> >> >> There is also a session of SharePoint Portal 2003 installed
on
> > this
> > > >> >> > machine
> > > >> >> >> (problem ?).
> > > >> >> >>
> > > >> >> >> Who out there has some experience with this set-up and can
help
> > > > me...
> > > >> > I
> > > >> >> >> start to get mad ;-(
> > > >> >> >>
> > > >> >> >> Thanks for help !
> > > >> >> >>
> > > >> >> >> Regards
> > > >> >> >> /Martin
> > > >> >> >>
> > > >> >> >>
> > > >> >> >>
> > > >> >> >
> > > >> >> >
> > > >> >>
> > > >> >>
> > > >> >
> > > >> >
> > > >>
> > > >>
> > > >
> > > >
> > >
> > >
> >
> >
> >|||Daniel,
...valid question... ;-)
I have changed the account for Report Server local account to domain
account. Afterwards I have deleted the crypto info by using rskeymgmt -d.
Then I have restarted the whole server to make sure that everything runs
fine. Until then I got no errormessage neither in eventlog nor in report
server log files.
Then I have changed the job owner in SQL Server Enterprise Manager from
Domain account to local/server account. Result was that the job itself runs
fine but I get an errormessage in the report service log that says that the
used account has probably no rights to retrive Domain SID's. After this I
have changed the job owner for the job back to a domain account. Result now
is that the job itself does not run successful (SQLSTATE(error 42000)).
Is this a bit more clear ?
Can you give me a tip which services need what type of accounts?
MSSQLSERVER
SQLserveragent
Report Service
For me it is not clear what account need what kind of access rights to what
ressources (local or domain).
Regards and thanks again
/Martin
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im Newsbeitrag
news:%23yaUS62jEHA.3476@.tk2msftngp13.phx.gbl...
> You said:
> When I run it as a local user the Job on the SQL Server runs fine but I
> then
> get an error on the reportserver service (to find in the log) where it
> says
> that the user has no rights to query SIDs from the domain...
> When you run what? The job? The report server service? The connection
> to
> the report server catalog? The error looks to be that the user that the
> ReportServer service is running as does not have permission to query SIDs
> from the domain. This should be a domain account with sufficient
> privileges. If it is not running as a domain account, before you switch,
> make sure to run rskeymgmt to export the symmetric key, after you change
> the
> user run rskeymgmt again to reimport the symmetric key.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Martin Schlenker" <Martin Schlenker@.discussions.microsoft.com> wrote in
> message news:70B106ED-1B1E-4DA1-843E-BAB3BA4CD889@.microsoft.com...
>> Daniel,
>> ok, I've tried a couple of combinations...
>> When I run the service with a domain account I got the error message that
>> the Job itself cannot verify if the user has domain acces rights
>> (SQLSTATE(error 42000)).
>> When I run it as a local user the Job on the SQL Server runs fine but I
> then
>> get an error on the reportserver service (to find in the log) where it
> says
>> that the user has no rights to query SIDs from the domain...
>> What other options do I have then '
>> Kind regards
>> /Martin
>> "Daniel Reib [MSFT]" wrote:
>> > When you changed the account to sql auth did you recreate the
> subscriptions
>> > (I know I forgot to mention that). If so were you getting the same
> error?
>> >
>> > --
>> > -Daniel
>> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> >
>> >
>> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
>> > news:eNuLc8fiEHA.396@.TK2MSFTNGP12.phx.gbl...
>> > > Daniel,
>> > > as pointed out in my other mail. I now have changed the account via
>> > RSconfig
>> > > to run report server to use SQL Auth. --> no success
>> > > I also changed the user account for SQL Server to an administrative
>> > account
>> > > from the domain --> no success
>> > >
>> > > It really starts to bother me... ;-(
>> > >
>> > > Any other idea ?
>> > >
>> > > Thanks and best regards
>> > > /Martin
>> > >
>> > >
>> > > "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
> Newsbeitrag
>> > > news:%23hzuwFTiEHA.4020@.TK2MSFTNGP10.phx.gbl...
>> > > > rsconfig is an admin tool shipped with RS. It allows you to change
> the
>> > > > way
>> > > > RS connects to it's catalog. You can find more information on it
> here:
>> > > >
>> > > >
>> >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
>> > > >
>> > > > --
>> > > > -Daniel
>> > > > This posting is provided "AS IS" with no warranties, and confers no
>> > > > rights.
>> > > >
>> > > >
>> > > > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
>> > > > news:Oz7m8VvhEHA.2540@.TK2MSFTNGP10.phx.gbl...
>> > > >> Daniel,
>> > > >> yep, today I have played a bit and couldn't solve it out. Anyhow,
>> > > >> I
>> > > > haven't
>> > > >> tried what you suggest. Can you explain it a bit more in detail ?
> How
>> > can
>> > > > I
>> > > >> use RSConfig '
>> > > >>
>> > > >> Thnx and best regards
>> > > >> /Martin
>> > > >>
>> > > >> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
>> > > >> Newsbeitrag
>> > > >> news:OKk6pSthEHA.2604@.TK2MSFTNGP09.phx.gbl...
>> > > >> > Most likely SQL agent is running as a user which can not access
>> > Active
>> > > >> > Directory. The easiest solution is to use RSConfig to have the
>> > report
>> > > >> > server use SQL Auth to connect to the database. If that is not
> an
>> > > > option
>> > > >> > you would need to run SQL Server as a domain user.
>> > > >> >
>> > > >> > --
>> > > >> > -Daniel
>> > > >> > This posting is provided "AS IS" with no warranties, and confers
> no
>> > > >> > rights.
>> > > >> >
>> > > >> >
>> > > >> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
>> > > >> > news:#sXPoPihEHA.1652@.TK2MSFTNGP09.phx.gbl...
>> > > >> >> Hi Daniel,
>> > > >> >> looks like you're on the right way...
>> > > >> >> This is the erromessage that I found:
>> > > >> >>
>> > > >> >> The job failed. Unable to determine if the owner
>> > > >> >> (<domain>\<username>)
>> > > >> >> of
>> > > >> >> job 1303EC62-A3C7-4A15-814E-422C13ECC91F has server access
> (reason:
>> > > > Could
>> > > >> >> not obtain information about Windows NT group/user
>> > > > '<domain>\<username>'.
>> > > >> >> [SQLSTATE 42000] (Error 8198)).
>> > > >> >>
>> > > >> >>
>> > > >> >>
>> > > >> >> I've changed the domain name and the username to the generic
>> > > > description
>> > > >> >> <domain> and <username>
>> > > >> >>
>> > > >> >>
>> > > >> >>
>> > > >> >> The mentioned user is also member of the local administrators
>> > > >> >> at
> the
>> > > >> >> Reporting Services Server.
>> > > >> >>
>> > > >> >>
>> > > >> >>
>> > > >> >> Any idea ?
>> > > >> >>
>> > > >> >>
>> > > >> >>
>> > > >> >> Regards and thanks so far...
>> > > >> >>
>> > > >> >> /Martin
>> > > >> >>
>> > > >> >>
>> > > >> >>
>> > > >> >> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> schrieb im
>> > > >> >> Newsbeitrag
>> > > >> >> news:uJ8qdzghEHA.3988@.tk2msftngp13.phx.gbl...
>> > > >> >> > The first thing to check is if the ReportServer service is
>> > running.
>> > > > If
>> > > >> > it
>> > > >> >> > is, next check the Sql Agent Job that the report server
> creates
>> > when
>> > > > a
>> > > >> >> > schedule is created. See if this job has any history and if
> they
>> > > >> >> > are
>> > > >> >> > successful.
>> > > >> >> >
>> > > >> >> > Let me know what you find out and we can proceed from there.
>> > > >> >> >
>> > > >> >> > --
>> > > >> >> > -Daniel
>> > > >> >> > This posting is provided "AS IS" with no warranties, and
> confers
>> > no
>> > > >> >> > rights.
>> > > >> >> >
>> > > >> >> >
>> > > >> >> > "Martin Schlenker" <Martinschlenker@.web.de> wrote in message
>> > > >> >> > news:ejgRR1ahEHA.644@.tk2msftngp13.phx.gbl...
>> > > >> >> >> Hi All,
>> > > >> >> >> I have a serious problem with my Reporting Server
> installation.
>> > > >> >> >> Neither
>> > > >> >> > the
>> > > >> >> >> e-mail subscription nor the automated file creation on a
> share
>> > does
>> > > >> >> >> not
>> > > >> >> >> work. I have tried it several times (including re-installing
>> > !!) -
>> > > > no
>> > > >> >> >> success.
>> > > >> >> >> I have the following (TEST !!) environment:
>> > > >> >> >>
>> > > >> >> >> Server: 200Mhz (I know... it's just for testing !!)
>> > > >> >> >>
>> > > >> >> >> OS: Win2003 with latest patches
>> > > >> >> >> Reporting Services: Enterprise with SP1
>> > > >> >> >> DB: MS Sql 2K SP3
>> > > >> >> >> SMTP is enabled on the server and working properly.
>> > > >> >> >>
>> > > >> >> >> I cannot see any errormessages in the log files nor in the
>> > > >> >> >> eventviewer.
>> > > >> >> >> After I have scheduled an e-mail subscription NOTHING
> happens, I
>> > > > even
>> > > >> >> > don't
>> > > >> >> >> get an errormessage on the "My subscription" page under last
> run.
>> > > >> >> >> It
>> > > >> > just
>> > > >> >> >> says nothing, meaning, there is no last run...
>> > > >> >> >>
>> > > >> >> >> There is also a session of SharePoint Portal 2003 installed
> on
>> > this
>> > > >> >> > machine
>> > > >> >> >> (problem ?).
>> > > >> >> >>
>> > > >> >> >> Who out there has some experience with this set-up and can
> help
>> > > > me...
>> > > >> > I
>> > > >> >> >> start to get mad ;-(
>> > > >> >> >>
>> > > >> >> >> Thanks for help !
>> > > >> >> >>
>> > > >> >> >> Regards
>> > > >> >> >> /Martin
>> > > >> >> >>
>> > > >> >> >>
>> > > >> >> >>
>> > > >> >> >
>> > > >> >> >
>> > > >> >>
>> > > >> >>
>> > > >> >
>> > > >> >
>> > > >>
>> > > >>
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>> >
>