My report subscription got the following error. Before the subscription was
run, I changed the Reporting Service's Windows Service logon account from
local system account to a local user with adm rights.
I'm using developer editions for sql server and reporting service, running
everything from one single development machine of XP Pro.
I'd appreciate any help.
jf
************ log info *********************************
ReportingServicesService!crypto!1600!01/11/2005-17:27:03:: e ERROR:
DBUnProtectData failed: System.Runtime.InteropServices.COMException
(0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.DecryptData(Byte[] pCipherText)
at
Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
data)
ReportingServicesService!crypto!1600!01/11/2005-17:27:03:: i INFO: Current
user: jf\john
ReportingServicesService!notification!1600!01/11/2005-17:27:03:: e ERROR:
Error occured processing notification. Bad Data.
ReportingServicesService!notification!1600!01/11/2005-17:27:03::
Notification 882b52f3-40de-486e-a7ef-4e72e6efd6ea completed. Success: True,
Status: Bad Data., DeliveryExtension: Report Server FileShare, Report:
NWCustomers, Attempt 0
ReportingServicesService!dbpolling!1600!01/11/2005-17:27:03::
NotificationPolling finished processing item
882b52f3-40de-486e-a7ef-4e72e6efd6ea
***************** end of log info ***************************Hi, you can see the documentation (BOL) of reporting services about change
the account using rsconfig.exe
The problem is that the new user would be changed in the RSCONFIG file, but
trougth rsconfig.exe not over file directly
this is the command
RSConfig -c -s Server name -d Reporting Services database name -a
Sql|Windows -u User name -p User password
Best Regards
John Bocachica
Colombia
"John Fant" <JohnFant@.discussions.microsoft.com> wrote in message
news:3CE5CAEF-7553-457A-B072-70BA04EF84B2@.microsoft.com...
> My report subscription got the following error. Before the subscription
> was
> run, I changed the Reporting Service's Windows Service logon account from
> local system account to a local user with adm rights.
> I'm using developer editions for sql server and reporting service, running
> everything from one single development machine of XP Pro.
> I'd appreciate any help.
> jf
> ************ log info *********************************
> ReportingServicesService!crypto!1600!01/11/2005-17:27:03:: e ERROR:
> DBUnProtectData failed: System.Runtime.InteropServices.COMException
> (0x80090005): Bad Data.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.DecryptData(Byte[] pCipherText)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
> data)
> ReportingServicesService!crypto!1600!01/11/2005-17:27:03:: i INFO: Current
> user: jf\john
> ReportingServicesService!notification!1600!01/11/2005-17:27:03:: e ERROR:
> Error occured processing notification. Bad Data.
> ReportingServicesService!notification!1600!01/11/2005-17:27:03::
> Notification 882b52f3-40de-486e-a7ef-4e72e6efd6ea completed. Success:
> True,
> Status: Bad Data., DeliveryExtension: Report Server FileShare, Report:
> NWCustomers, Attempt 0
> ReportingServicesService!dbpolling!1600!01/11/2005-17:27:03::
> NotificationPolling finished processing item
> 882b52f3-40de-486e-a7ef-4e72e6efd6ea
> ***************** end of log info ***************************
Showing posts with label subscription. Show all posts
Showing posts with label subscription. Show all posts
Friday, March 23, 2012
Fileshare subscription
Hello
I have a problem where I set up a user subscription, putting in all the
required fields for this to run correctly. I schedule it to run Once. I
check in SQL Agent for the job and it exists, as expected. I check that the
job has been run in SQL Agent, which is says it has done, successfully
(succeeded with datetime). I then look at the Subscriptions tab (in Report
Manager) to see whether it has run, though it still displays "New
Subscription" for "Last Run Status". The file also does not exist within the
directory specified. I have also looked at the Application Log in Event
Viewer (on the sever), though there isn't anything to indicate a problem
with the subscription.
Is there anywhere I can see what the problem may be?
Thanks,
MarkLook in the log from Reporting Service Server.
Could be that this is a permission issue.
If you have any questions further post the last lines of the log
here.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hello
> I have a problem where I set up a user subscription, putting in all the
> required fields for this to run correctly. I schedule it to run Once. I
> check in SQL Agent for the job and it exists, as expected. I check that
> the
> job has been run in SQL Agent, which is says it has done, successfully
> (succeeded with datetime). I then look at the Subscriptions tab (in Report
> Manager) to see whether it has run, though it still displays "New
> Subscription" for "Last Run Status". The file also does not exist within
> the
> directory specified. I have also looked at the Application Log in Event
> Viewer (on the sever), though there isn't anything to indicate a problem
> with the subscription.
> Is there anywhere I can see what the problem may be?
> Thanks,
> Mark
>|||Thanks.
From the "ReportServer__04_14_2005_00_02_16.log" file:
aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
GetPermissions:/
aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
Thanks,
Mark
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
> Look in the log from Reporting Service Server.
> Could be that this is a permission issue.
> If you have any questions further post the last lines of the log
> here.
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> > Hello
> >
> > I have a problem where I set up a user subscription, putting in all the
> > required fields for this to run correctly. I schedule it to run Once. I
> > check in SQL Agent for the job and it exists, as expected. I check that
> > the
> > job has been run in SQL Agent, which is says it has done, successfully
> > (succeeded with datetime). I then look at the Subscriptions tab (in
Report
> > Manager) to see whether it has run, though it still displays "New
> > Subscription" for "Last Run Status". The file also does not exist within
> > the
> > directory specified. I have also looked at the Application Log in Event
> > Viewer (on the sever), though there isn't anything to indicate a problem
> > with the subscription.
> >
> > Is there anywhere I can see what the problem may be?
> >
> > Thanks,
> >
> > Mark
> >
> >
>|||Looks like an incomplete stack trace... of an exception block,
í don´t exactly know who is gonna pump out the file to the share, the
ReportServerService Account or the ASP.NET process the IIS is running on (I
guess the ASp.NET Account). Give him the appopiate permissions to access to
fileshare and you gotta be perhaps right.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
news:Op0SOSOQFHA.1396@.TK2MSFTNGP10.phx.gbl...
> Thanks.
> From the "ReportServer__04_14_2005_00_02_16.log" file:
> aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> GetPermissions:/
> aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> Thanks,
> Mark
>
> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
>> Look in the log from Reporting Service Server.
>> Could be that this is a permission issue.
>> If you have any questions further post the last lines of the log
>> here.
>> HTH, Jens Süßmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>
>> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
>> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
>> > Hello
>> >
>> > I have a problem where I set up a user subscription, putting in all the
>> > required fields for this to run correctly. I schedule it to run Once. I
>> > check in SQL Agent for the job and it exists, as expected. I check that
>> > the
>> > job has been run in SQL Agent, which is says it has done, successfully
>> > (succeeded with datetime). I then look at the Subscriptions tab (in
> Report
>> > Manager) to see whether it has run, though it still displays "New
>> > Subscription" for "Last Run Status". The file also does not exist
>> > within
>> > the
>> > directory specified. I have also looked at the Application Log in Event
>> > Viewer (on the sever), though there isn't anything to indicate a
>> > problem
>> > with the subscription.
>> >
>> > Is there anywhere I can see what the problem may be?
>> >
>> > Thanks,
>> >
>> > Mark
>> >
>> >
>>
>|||Hi Jens
Thanks for your reply, it pointed me in the right direction : ReportServer
service was, in fact, using the Local System account and not domain\svcSQL.
I also looked at the posting, below, for further information and loosely
followed the Solution #2 and now my fileshare is working fine. Now onto why
e-mails aren't... :-)
http://groups.google.co.uk/groups?q=%22My+problem+was+solved+by+calling%22&hl=en&lr=&safe=off&rls=GGLD,GGLD:2004-37,GGLD:en&selm=ODE70opMEHA.268%40TK2MSFTNGP11.phx.gbl&rnum=1
Thanks,
Mark
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:eWCSFYOQFHA.3384@.TK2MSFTNGP10.phx.gbl...
> Looks like an incomplete stack trace... of an exception block,
> í don´t exactly know who is gonna pump out the file to the share, the
> ReportServerService Account or the ASP.NET process the IIS is running on
(I
> guess the ASp.NET Account). Give him the appopiate permissions to access
to
> fileshare and you gotta be perhaps right.
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> news:Op0SOSOQFHA.1396@.TK2MSFTNGP10.phx.gbl...
> > Thanks.
> >
> > From the "ReportServer__04_14_2005_00_02_16.log" file:
> >
> > aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> > GetPermissions:/
> > aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks,
0
> > running jobs
> >
> > Thanks,
> >
> > Mark
> >
> >
> >
> > "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> > in
> > message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
> >> Look in the log from Reporting Service Server.
> >> Could be that this is a permission issue.
> >>
> >> If you have any questions further post the last lines of the log
> >> here.
> >>
> >> HTH, Jens Süßmeyer.
> >>
> >> --
> >> http://www.sqlserver2005.de
> >> --
> >>
> >>
> >> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> >> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> >> > Hello
> >> >
> >> > I have a problem where I set up a user subscription, putting in all
the
> >> > required fields for this to run correctly. I schedule it to run Once.
I
> >> > check in SQL Agent for the job and it exists, as expected. I check
that
> >> > the
> >> > job has been run in SQL Agent, which is says it has done,
successfully
> >> > (succeeded with datetime). I then look at the Subscriptions tab (in
> > Report
> >> > Manager) to see whether it has run, though it still displays "New
> >> > Subscription" for "Last Run Status". The file also does not exist
> >> > within
> >> > the
> >> > directory specified. I have also looked at the Application Log in
Event
> >> > Viewer (on the sever), though there isn't anything to indicate a
> >> > problem
> >> > with the subscription.
> >> >
> >> > Is there anywhere I can see what the problem may be?
> >> >
> >> > Thanks,
> >> >
> >> > Mark
> >> >
> >> >
> >>
> >>
> >
> >
>
I have a problem where I set up a user subscription, putting in all the
required fields for this to run correctly. I schedule it to run Once. I
check in SQL Agent for the job and it exists, as expected. I check that the
job has been run in SQL Agent, which is says it has done, successfully
(succeeded with datetime). I then look at the Subscriptions tab (in Report
Manager) to see whether it has run, though it still displays "New
Subscription" for "Last Run Status". The file also does not exist within the
directory specified. I have also looked at the Application Log in Event
Viewer (on the sever), though there isn't anything to indicate a problem
with the subscription.
Is there anywhere I can see what the problem may be?
Thanks,
MarkLook in the log from Reporting Service Server.
Could be that this is a permission issue.
If you have any questions further post the last lines of the log
here.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hello
> I have a problem where I set up a user subscription, putting in all the
> required fields for this to run correctly. I schedule it to run Once. I
> check in SQL Agent for the job and it exists, as expected. I check that
> the
> job has been run in SQL Agent, which is says it has done, successfully
> (succeeded with datetime). I then look at the Subscriptions tab (in Report
> Manager) to see whether it has run, though it still displays "New
> Subscription" for "Last Run Status". The file also does not exist within
> the
> directory specified. I have also looked at the Application Log in Event
> Viewer (on the sever), though there isn't anything to indicate a problem
> with the subscription.
> Is there anywhere I can see what the problem may be?
> Thanks,
> Mark
>|||Thanks.
From the "ReportServer__04_14_2005_00_02_16.log" file:
aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
GetPermissions:/
aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
Thanks,
Mark
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
> Look in the log from Reporting Service Server.
> Could be that this is a permission issue.
> If you have any questions further post the last lines of the log
> here.
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> > Hello
> >
> > I have a problem where I set up a user subscription, putting in all the
> > required fields for this to run correctly. I schedule it to run Once. I
> > check in SQL Agent for the job and it exists, as expected. I check that
> > the
> > job has been run in SQL Agent, which is says it has done, successfully
> > (succeeded with datetime). I then look at the Subscriptions tab (in
Report
> > Manager) to see whether it has run, though it still displays "New
> > Subscription" for "Last Run Status". The file also does not exist within
> > the
> > directory specified. I have also looked at the Application Log in Event
> > Viewer (on the sever), though there isn't anything to indicate a problem
> > with the subscription.
> >
> > Is there anywhere I can see what the problem may be?
> >
> > Thanks,
> >
> > Mark
> >
> >
>|||Looks like an incomplete stack trace... of an exception block,
í don´t exactly know who is gonna pump out the file to the share, the
ReportServerService Account or the ASP.NET process the IIS is running on (I
guess the ASp.NET Account). Give him the appopiate permissions to access to
fileshare and you gotta be perhaps right.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
news:Op0SOSOQFHA.1396@.TK2MSFTNGP10.phx.gbl...
> Thanks.
> From the "ReportServer__04_14_2005_00_02_16.log" file:
> aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> GetPermissions:/
> aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> Thanks,
> Mark
>
> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
>> Look in the log from Reporting Service Server.
>> Could be that this is a permission issue.
>> If you have any questions further post the last lines of the log
>> here.
>> HTH, Jens Süßmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>
>> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
>> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
>> > Hello
>> >
>> > I have a problem where I set up a user subscription, putting in all the
>> > required fields for this to run correctly. I schedule it to run Once. I
>> > check in SQL Agent for the job and it exists, as expected. I check that
>> > the
>> > job has been run in SQL Agent, which is says it has done, successfully
>> > (succeeded with datetime). I then look at the Subscriptions tab (in
> Report
>> > Manager) to see whether it has run, though it still displays "New
>> > Subscription" for "Last Run Status". The file also does not exist
>> > within
>> > the
>> > directory specified. I have also looked at the Application Log in Event
>> > Viewer (on the sever), though there isn't anything to indicate a
>> > problem
>> > with the subscription.
>> >
>> > Is there anywhere I can see what the problem may be?
>> >
>> > Thanks,
>> >
>> > Mark
>> >
>> >
>>
>|||Hi Jens
Thanks for your reply, it pointed me in the right direction : ReportServer
service was, in fact, using the Local System account and not domain\svcSQL.
I also looked at the posting, below, for further information and loosely
followed the Solution #2 and now my fileshare is working fine. Now onto why
e-mails aren't... :-)
http://groups.google.co.uk/groups?q=%22My+problem+was+solved+by+calling%22&hl=en&lr=&safe=off&rls=GGLD,GGLD:2004-37,GGLD:en&selm=ODE70opMEHA.268%40TK2MSFTNGP11.phx.gbl&rnum=1
Thanks,
Mark
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:eWCSFYOQFHA.3384@.TK2MSFTNGP10.phx.gbl...
> Looks like an incomplete stack trace... of an exception block,
> í don´t exactly know who is gonna pump out the file to the share, the
> ReportServerService Account or the ASP.NET process the IIS is running on
(I
> guess the ASp.NET Account). Give him the appopiate permissions to access
to
> fileshare and you gotta be perhaps right.
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> news:Op0SOSOQFHA.1396@.TK2MSFTNGP10.phx.gbl...
> > Thanks.
> >
> > From the "ReportServer__04_14_2005_00_02_16.log" file:
> >
> > aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> > GetPermissions:/
> > aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks,
0
> > running jobs
> >
> > Thanks,
> >
> > Mark
> >
> >
> >
> > "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> > in
> > message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
> >> Look in the log from Reporting Service Server.
> >> Could be that this is a permission issue.
> >>
> >> If you have any questions further post the last lines of the log
> >> here.
> >>
> >> HTH, Jens Süßmeyer.
> >>
> >> --
> >> http://www.sqlserver2005.de
> >> --
> >>
> >>
> >> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> >> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> >> > Hello
> >> >
> >> > I have a problem where I set up a user subscription, putting in all
the
> >> > required fields for this to run correctly. I schedule it to run Once.
I
> >> > check in SQL Agent for the job and it exists, as expected. I check
that
> >> > the
> >> > job has been run in SQL Agent, which is says it has done,
successfully
> >> > (succeeded with datetime). I then look at the Subscriptions tab (in
> > Report
> >> > Manager) to see whether it has run, though it still displays "New
> >> > Subscription" for "Last Run Status". The file also does not exist
> >> > within
> >> > the
> >> > directory specified. I have also looked at the Application Log in
Event
> >> > Viewer (on the sever), though there isn't anything to indicate a
> >> > problem
> >> > with the subscription.
> >> >
> >> > Is there anywhere I can see what the problem may be?
> >> >
> >> > Thanks,
> >> >
> >> > Mark
> >> >
> >> >
> >>
> >>
> >
> >
>
Fileshare Data Driven subscription - Setting up report manager fil
I am trying set up a data driven subscription that will render reports as
PDFs to specific folders in Report Manager. I have setup a fileshare to which
I am pushing reports, but I am having trouble relating specific Report
Manager folders to the fileshares and there is little documentation about
this. Is there a simple way to push PDFs to Report Manager folders via
fileshare subscriptions?
Also, on a data driven subscription, I am setting up the table that will
read the specifications for the data driven subscription. How do a refer to
the PDF rendering method in the table - as "PDF" or " Adobe (PDF) file" or
something else? Also, what is the bit I should use to increment the file if
it already exists? The documentation on data driven subsciptions is really
not adequate to answer these questions.Incidentally, this question relates to Reporting Services 2005
"Mark" wrote:
> I am trying set up a data driven subscription that will render reports as
> PDFs to specific folders in Report Manager. I have setup a fileshare to which
> I am pushing reports, but I am having trouble relating specific Report
> Manager folders to the fileshares and there is little documentation about
> this. Is there a simple way to push PDFs to Report Manager folders via
> fileshare subscriptions?
> Also, on a data driven subscription, I am setting up the table that will
> read the specifications for the data driven subscription. How do a refer to
> the PDF rendering method in the table - as "PDF" or " Adobe (PDF) file" or
> something else? Also, what is the bit I should use to increment the file if
> it already exists? The documentation on data driven subsciptions is really
> not adequate to answer these questions.
>|||Hi Mark,
Not sure I understand third question, but you must provide a different
FileName paramter to the DDS for each report. Whatever logic you want.
Answer to second question is: PDF
As to the first question - I don't think that is possible. DDS can
output to fileshares, but the folders and files in those folders in RM
are controlledby the RS catalog and not accessible outside RM.
As a quick test, I uploaded a PDF file using RM and then searched the
RS Server for the pdf and it was not found. (So RS must be storing it
away somewhere on the server in a secured spot).
Are you sure you really want to do that anyway? The folders may get a
little crowded if you start storing PDF's there. You can, as another
option, store data with the report by using Snapshots.
If you do find a solution for stroing PDF's though, please post it!!
As a workaround, maybe|||Matt - Regarding your last comment, can I arrange the snapshots for the
reports into different folders? My understanding is that you can create a new
snapshot under the history tab for each report, but you cannot move the
history "snapshots" to other folders. Or can you?
"Matt" wrote:
> Hi Mark,
> Not sure I understand third question, but you must provide a different
> FileName paramter to the DDS for each report. Whatever logic you want.
>
> Answer to second question is: PDF
> As to the first question - I don't think that is possible. DDS can
> output to fileshares, but the folders and files in those folders in RM
> are controlledby the RS catalog and not accessible outside RM.
> As a quick test, I uploaded a PDF file using RM and then searched the
> RS Server for the pdf and it was not found. (So RS must be storing it
> away somewhere on the server in a secured spot).
> Are you sure you really want to do that anyway? The folders may get a
> little crowded if you start storing PDF's there. You can, as another
> option, store data with the report by using Snapshots.
> If you do find a solution for stroing PDF's though, please post it!!
> As a workaround, maybe
>
PDFs to specific folders in Report Manager. I have setup a fileshare to which
I am pushing reports, but I am having trouble relating specific Report
Manager folders to the fileshares and there is little documentation about
this. Is there a simple way to push PDFs to Report Manager folders via
fileshare subscriptions?
Also, on a data driven subscription, I am setting up the table that will
read the specifications for the data driven subscription. How do a refer to
the PDF rendering method in the table - as "PDF" or " Adobe (PDF) file" or
something else? Also, what is the bit I should use to increment the file if
it already exists? The documentation on data driven subsciptions is really
not adequate to answer these questions.Incidentally, this question relates to Reporting Services 2005
"Mark" wrote:
> I am trying set up a data driven subscription that will render reports as
> PDFs to specific folders in Report Manager. I have setup a fileshare to which
> I am pushing reports, but I am having trouble relating specific Report
> Manager folders to the fileshares and there is little documentation about
> this. Is there a simple way to push PDFs to Report Manager folders via
> fileshare subscriptions?
> Also, on a data driven subscription, I am setting up the table that will
> read the specifications for the data driven subscription. How do a refer to
> the PDF rendering method in the table - as "PDF" or " Adobe (PDF) file" or
> something else? Also, what is the bit I should use to increment the file if
> it already exists? The documentation on data driven subsciptions is really
> not adequate to answer these questions.
>|||Hi Mark,
Not sure I understand third question, but you must provide a different
FileName paramter to the DDS for each report. Whatever logic you want.
Answer to second question is: PDF
As to the first question - I don't think that is possible. DDS can
output to fileshares, but the folders and files in those folders in RM
are controlledby the RS catalog and not accessible outside RM.
As a quick test, I uploaded a PDF file using RM and then searched the
RS Server for the pdf and it was not found. (So RS must be storing it
away somewhere on the server in a secured spot).
Are you sure you really want to do that anyway? The folders may get a
little crowded if you start storing PDF's there. You can, as another
option, store data with the report by using Snapshots.
If you do find a solution for stroing PDF's though, please post it!!
As a workaround, maybe|||Matt - Regarding your last comment, can I arrange the snapshots for the
reports into different folders? My understanding is that you can create a new
snapshot under the history tab for each report, but you cannot move the
history "snapshots" to other folders. Or can you?
"Matt" wrote:
> Hi Mark,
> Not sure I understand third question, but you must provide a different
> FileName paramter to the DDS for each report. Whatever logic you want.
>
> Answer to second question is: PDF
> As to the first question - I don't think that is possible. DDS can
> output to fileshares, but the folders and files in those folders in RM
> are controlledby the RS catalog and not accessible outside RM.
> As a quick test, I uploaded a PDF file using RM and then searched the
> RS Server for the pdf and it was not found. (So RS must be storing it
> away somewhere on the server in a secured spot).
> Are you sure you really want to do that anyway? The folders may get a
> little crowded if you start storing PDF's there. You can, as another
> option, store data with the report by using Snapshots.
> If you do find a solution for stroing PDF's though, please post it!!
> As a workaround, maybe
>
Wednesday, March 21, 2012
filename in Subscription
Hello,
I have a question regarding the report file which is included in an email, when a subscription is created:
Is it possible to programmatically add something to the name of the created file of the subscription? I want to have one parameter of the report, which is a date, added at the end of the filename to let the clients distinguish between different report files.
Thank you in advance.
Sandra Geisler
The way I'd reslove this situation is by using data-driven subscription where in step 3 you put a query such as
SELECT FN=CAST('Your file name-' + CONVERT(char(20),GETDATE(),105) AS CHAR(20));
and on step 4; for filename you pick get the value from database for FILENAME and select FN based on above query.
Thanks
filename in Subscription
Hello,
I have a question regarding the report file which is included in an email, when a subscription is created:
Is it possible to programmatically add something to the name of the created file of the subscription? I want to have one parameter of the report, which is a date, added at the end of the filename to let the clients distinguish between different report files.
Thank you in advance.
Sandra Geisler
The way I'd reslove this situation is by using data-driven subscription where in step 3 you put a query such as
SELECT FN=CAST('Your file name-' + CONVERT(char(20),GETDATE(),105) AS CHAR(20));
and on step 4; for filename you pick get the value from database for FILENAME and select FN based on above query.
Thanks
sqlSunday, February 26, 2012
file share subscription problem
I've setup a file share subscription to render a report to an AS/400
file system, but it is failing with Logon failure: unknown user name
or bad password --> System.Runtime.InteropServices.COMException
(0x8007052E):
I'm supplying the correct username and password to access the
directory, and I'm specifying the unc path for the AS/400 correctly
(\\myas400\root\qdls\ftp). The reason I know this is because I am
able to go into Windows Explorer and type in the exact same UNC path,
then supply the username and password when prompted, and I can get in
just fine. I can also copy files back and forth, etc.
Any ideas? This looks like a possible bug to me. My guess is that
nobody's tried rendering a file share subscription to an AS/400
before, so it's probably never been tested.
I guess as a workaround I can render the report to a microsoft file
system and then ftp it over to the AS/400, but I really think this
should work as advertised. That's a lot of extra hoop jumping.This sounds like a security permission issue. Can you try the following: the
RS windows service is running under a certain account. Make sure this
account also has permissions to access the AS/400 network share.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"dcp" <dcp12345678@.yahoo.com> wrote in message
news:1b8617a8.0501041353.60da6aa0@.posting.google.com...
> I've setup a file share subscription to render a report to an AS/400
> file system, but it is failing with Logon failure: unknown user name
> or bad password --> System.Runtime.InteropServices.COMException
> (0x8007052E):
> I'm supplying the correct username and password to access the
> directory, and I'm specifying the unc path for the AS/400 correctly
> (\\myas400\root\qdls\ftp). The reason I know this is because I am
> able to go into Windows Explorer and type in the exact same UNC path,
> then supply the username and password when prompted, and I can get in
> just fine. I can also copy files back and forth, etc.
> Any ideas? This looks like a possible bug to me. My guess is that
> nobody's tried rendering a file share subscription to an AS/400
> before, so it's probably never been tested.
> I guess as a workaround I can render the report to a microsoft file
> system and then ftp it over to the AS/400, but I really think this
> should work as advertised. That's a lot of extra hoop jumping.
file system, but it is failing with Logon failure: unknown user name
or bad password --> System.Runtime.InteropServices.COMException
(0x8007052E):
I'm supplying the correct username and password to access the
directory, and I'm specifying the unc path for the AS/400 correctly
(\\myas400\root\qdls\ftp). The reason I know this is because I am
able to go into Windows Explorer and type in the exact same UNC path,
then supply the username and password when prompted, and I can get in
just fine. I can also copy files back and forth, etc.
Any ideas? This looks like a possible bug to me. My guess is that
nobody's tried rendering a file share subscription to an AS/400
before, so it's probably never been tested.
I guess as a workaround I can render the report to a microsoft file
system and then ftp it over to the AS/400, but I really think this
should work as advertised. That's a lot of extra hoop jumping.This sounds like a security permission issue. Can you try the following: the
RS windows service is running under a certain account. Make sure this
account also has permissions to access the AS/400 network share.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"dcp" <dcp12345678@.yahoo.com> wrote in message
news:1b8617a8.0501041353.60da6aa0@.posting.google.com...
> I've setup a file share subscription to render a report to an AS/400
> file system, but it is failing with Logon failure: unknown user name
> or bad password --> System.Runtime.InteropServices.COMException
> (0x8007052E):
> I'm supplying the correct username and password to access the
> directory, and I'm specifying the unc path for the AS/400 correctly
> (\\myas400\root\qdls\ftp). The reason I know this is because I am
> able to go into Windows Explorer and type in the exact same UNC path,
> then supply the username and password when prompted, and I can get in
> just fine. I can also copy files back and forth, etc.
> Any ideas? This looks like a possible bug to me. My guess is that
> nobody's tried rendering a file share subscription to an AS/400
> before, so it's probably never been tested.
> I guess as a workaround I can render the report to a microsoft file
> system and then ftp it over to the AS/400, but I really think this
> should work as advertised. That's a lot of extra hoop jumping.
File Share Subscription
I have been trying, unsuccessfully, to set up a File Share Subscription. (The path is a location not on the report server.) On the destination server, the network permissions are set to full and the NTFS permissions are set to modify.
I found a post that said a Shared Schedule had to be used for this to work, so I tried that with no luck either. This is the error message I'm receiving:
"Logon failure: unknown user name or bad password. "
However, I can manually map a drive from my machine to that network drive.
And we've also been able to set up the File Share subscription to deliver to a different location on the network w/o issue.
I found something on a blog but I'm not sure that it is accurate. I can't find anything in the help files that indicate this is true. Can anyone confirm or deny?
"...if it fails using any account other than the account that the account Reporting Services is running under
just run your app pools and the reporting services windows service under the same account.
then change the Reports (Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager) and ReportServer (Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer) web.config files so the “impersonation” is to false."|||
In the file share subscription,use your login name and your password as stored credentials, and test the subscription.
Local server accounts may not be in Active Directory and they may not have permissions to write files on another share.
File share subscription
I have a report server in domain â'Aâ' that through a data driven subscription
tries to write to a UNC in domain â'Bâ'. In â'Step 4â' of the â'Create a data
driven subscriptionâ' wizard, you are asked to provide a username and
password. If I supply domain credentials from domain A (A\UserName), the
subscription appears to run but the report output does not appear in the file
share on domain B. If I supply domain credentials for domain B (B\username),
the subscription fails to run.
Iâ'm assuming that the credentials asked for in the wizard are those used to
access the file share, but it seems as if they also have some bearing on the
running of the subscription (report) itself.
Is there a way I can accomplish what I desire?Check and make sure that your domains have a two way trust between them since
this can cause authentication issues.
Also, make sure that the file share is not set to Read Only and that the
NTFS permissions on the folder do not prevent that user from writing to it.
--
SQL Server Developer Support Engineer
"Herman K" wrote:
> I have a report server in domain â'Aâ' that through a data driven subscription
> tries to write to a UNC in domain â'Bâ'. In â'Step 4â' of the â'Create a data
> driven subscriptionâ' wizard, you are asked to provide a username and
> password. If I supply domain credentials from domain A (A\UserName), the
> subscription appears to run but the report output does not appear in the file
> share on domain B. If I supply domain credentials for domain B (B\username),
> the subscription fails to run.
> Iâ'm assuming that the credentials asked for in the wizard are those used to
> access the file share, but it seems as if they also have some bearing on the
> running of the subscription (report) itself.
> Is there a way I can accomplish what I desire?
>|||Thanks Chris.
Ah. We do not (and cannot) have trusted domains due to security issues. I
ended up placing the subscription on a report server in domain B.
"Chris Alton [MS]" wrote:
> Check and make sure that your domains have a two way trust between them since
> this can cause authentication issues.
> Also, make sure that the file share is not set to Read Only and that the
> NTFS permissions on the folder do not prevent that user from writing to it.
> --
> SQL Server Developer Support Engineer
>
> "Herman K" wrote:
> > I have a report server in domain â'Aâ' that through a data driven subscription
> > tries to write to a UNC in domain â'Bâ'. In â'Step 4â' of the â'Create a data
> > driven subscriptionâ' wizard, you are asked to provide a username and
> > password. If I supply domain credentials from domain A (A\UserName), the
> > subscription appears to run but the report output does not appear in the file
> > share on domain B. If I supply domain credentials for domain B (B\username),
> > the subscription fails to run.
> >
> > Iâ'm assuming that the credentials asked for in the wizard are those used to
> > access the file share, but it seems as if they also have some bearing on the
> > running of the subscription (report) itself.
> >
> > Is there a way I can accomplish what I desire?
> >
tries to write to a UNC in domain â'Bâ'. In â'Step 4â' of the â'Create a data
driven subscriptionâ' wizard, you are asked to provide a username and
password. If I supply domain credentials from domain A (A\UserName), the
subscription appears to run but the report output does not appear in the file
share on domain B. If I supply domain credentials for domain B (B\username),
the subscription fails to run.
Iâ'm assuming that the credentials asked for in the wizard are those used to
access the file share, but it seems as if they also have some bearing on the
running of the subscription (report) itself.
Is there a way I can accomplish what I desire?Check and make sure that your domains have a two way trust between them since
this can cause authentication issues.
Also, make sure that the file share is not set to Read Only and that the
NTFS permissions on the folder do not prevent that user from writing to it.
--
SQL Server Developer Support Engineer
"Herman K" wrote:
> I have a report server in domain â'Aâ' that through a data driven subscription
> tries to write to a UNC in domain â'Bâ'. In â'Step 4â' of the â'Create a data
> driven subscriptionâ' wizard, you are asked to provide a username and
> password. If I supply domain credentials from domain A (A\UserName), the
> subscription appears to run but the report output does not appear in the file
> share on domain B. If I supply domain credentials for domain B (B\username),
> the subscription fails to run.
> Iâ'm assuming that the credentials asked for in the wizard are those used to
> access the file share, but it seems as if they also have some bearing on the
> running of the subscription (report) itself.
> Is there a way I can accomplish what I desire?
>|||Thanks Chris.
Ah. We do not (and cannot) have trusted domains due to security issues. I
ended up placing the subscription on a report server in domain B.
"Chris Alton [MS]" wrote:
> Check and make sure that your domains have a two way trust between them since
> this can cause authentication issues.
> Also, make sure that the file share is not set to Read Only and that the
> NTFS permissions on the folder do not prevent that user from writing to it.
> --
> SQL Server Developer Support Engineer
>
> "Herman K" wrote:
> > I have a report server in domain â'Aâ' that through a data driven subscription
> > tries to write to a UNC in domain â'Bâ'. In â'Step 4â' of the â'Create a data
> > driven subscriptionâ' wizard, you are asked to provide a username and
> > password. If I supply domain credentials from domain A (A\UserName), the
> > subscription appears to run but the report output does not appear in the file
> > share on domain B. If I supply domain credentials for domain B (B\username),
> > the subscription fails to run.
> >
> > Iâ'm assuming that the credentials asked for in the wizard are those used to
> > access the file share, but it seems as if they also have some bearing on the
> > running of the subscription (report) itself.
> >
> > Is there a way I can accomplish what I desire?
> >
File Share Delivery of subscription fails
I have a subscription that will not deliver to a file share. I've ensured
that the windows acct for share access for the subscription has read/write to
the share.
The error I get in report manager is:
Failure writing file <report name>: The Report Server has encountered a
configuration error; more details in the log files
The log file says:
ReportingServicesService!library!10ec!08/08/2005-12:26:05:: i INFO: Call to
RenderFirst( '/My Reports/<report name>)
ReportingServicesService!library!10ec!08/08/2005-12:26:06:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 234;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!10ec!08/08/2005-12:26:06:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!subscription!10ec!08/08/2005-12:26:06::
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log files
-->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.Deliver(Notification notification)
Any ideas?
TIA,
Berry Morgan
JSOAre the user who created the report subscription and the ReportServer in the
same domain (actually the ReportServerService service account). We have seen
this issue in our DEV + QA environments which are in different domains that
are not trusted by our prod domain (but do trust it). We have configured all
our Report Servers to run under prod domain service accounts to get around
this issue (because when testing subscriptions, developers will still be
using their prod accounts and it seems that it is the subscription owner
account that was failing to be resolved)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Berry at JSO" <6399bwmNOSPAM@.community.nospam> wrote in message
news:D735DEE3-F3E8-4250-9AAA-396D1B3742B2@.microsoft.com...
>I have a subscription that will not deliver to a file share. I've ensured
> that the windows acct for share access for the subscription has read/write
> to
> the share.
> The error I get in report manager is:
> Failure writing file <report name>: The Report Server has encountered a
> configuration error; more details in the log files
>
> The log file says:
> ReportingServicesService!library!10ec!08/08/2005-12:26:05:: i INFO: Call
> to
> RenderFirst( '/My Reports/<report name>)
> ReportingServicesService!library!10ec!08/08/2005-12:26:06:: e ERROR:
> Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
> the
> log files, AuthzInitializeContextFromSid: Win32 error: 234;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
> the
> log files
> ReportingServicesService!library!10ec!08/08/2005-12:26:06:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system
> properties.
> ReportingServicesService!subscription!10ec!08/08/2005-12:26:06::
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
> Server has encountered a configuration error; more details in the log
> files
> -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
> the
> log files
> at
> Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
> userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
> Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
> userName, IntPtr userToken)
> at
> Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation
> requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID,
> Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection
> values,
> DatasourceCredentialsCollection credentials)
> at
> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
> Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification
> notification, SubscriptionData data)
> at
> Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.Deliver(Notification
> notification)
>
> Any ideas?
> TIA,
> Berry Morgan
> JSO|||The subscription creator is a production domain account, but the
ReportServer service identity is NT AUTHORITY\Network Service.
If I change the ReportServer service identity to a domain account, won't
that require reactivation of the reporting server?
Also, email subscriptions currently work: wouldn't changing the service
identity require configuration changes for this subscription type as well?
My hunch is that subscription delivery to file shares is tied in with code
access security settings, but I'm not the MVP. :)
-Berry
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ewEcpyGnFHA.3304@.tk2msftngp13.phx.gbl...
> Are the user who created the report subscription and the ReportServer in
> the same domain (actually the ReportServerService service account). We
> have seen this issue in our DEV + QA environments which are in different
> domains that are not trusted by our prod domain (but do trust it). We have
> configured all our Report Servers to run under prod domain service
> accounts to get around this issue (because when testing subscriptions,
> developers will still be using their prod accounts and it seems that it is
> the subscription owner account that was failing to be resolved)
>|||Our issue was purely domain related however what I would suggest is that you
contact PSS. They'll be able to provide you with a utility that should help
pinpoint the issue. This is a common problem (the error message you are
seeing) and it's all related to being able to query AD and permissions
related to that (rather than specifically anything SQL related). PSS will be
able to help you track down the specific issue in your environment. Email
subscriptions don't suffer the same issue as far as I'm aware (we haven't
seen it but that doesn't mean it doesn't exist<g>)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Berry Morgan" <6399bwmNOSPAM@.community.nospam> wrote in message
news:uwK78DTnFHA.1372@.TK2MSFTNGP10.phx.gbl...
> The subscription creator is a production domain account, but the
> ReportServer service identity is NT AUTHORITY\Network Service.
> If I change the ReportServer service identity to a domain account, won't
> that require reactivation of the reporting server?
> Also, email subscriptions currently work: wouldn't changing the service
> identity require configuration changes for this subscription type as well?
> My hunch is that subscription delivery to file shares is tied in with code
> access security settings, but I'm not the MVP. :)
> -Berry
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:ewEcpyGnFHA.3304@.tk2msftngp13.phx.gbl...
>> Are the user who created the report subscription and the ReportServer in
>> the same domain (actually the ReportServerService service account). We
>> have seen this issue in our DEV + QA environments which are in different
>> domains that are not trusted by our prod domain (but do trust it). We
>> have configured all our Report Servers to run under prod domain service
>> accounts to get around this issue (because when testing subscriptions,
>> developers will still be using their prod accounts and it seems that it
>> is the subscription owner account that was failing to be resolved)
>
that the windows acct for share access for the subscription has read/write to
the share.
The error I get in report manager is:
Failure writing file <report name>: The Report Server has encountered a
configuration error; more details in the log files
The log file says:
ReportingServicesService!library!10ec!08/08/2005-12:26:05:: i INFO: Call to
RenderFirst( '/My Reports/<report name>)
ReportingServicesService!library!10ec!08/08/2005-12:26:06:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 234;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!10ec!08/08/2005-12:26:06:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!subscription!10ec!08/08/2005-12:26:06::
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log files
-->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.Deliver(Notification notification)
Any ideas?
TIA,
Berry Morgan
JSOAre the user who created the report subscription and the ReportServer in the
same domain (actually the ReportServerService service account). We have seen
this issue in our DEV + QA environments which are in different domains that
are not trusted by our prod domain (but do trust it). We have configured all
our Report Servers to run under prod domain service accounts to get around
this issue (because when testing subscriptions, developers will still be
using their prod accounts and it seems that it is the subscription owner
account that was failing to be resolved)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Berry at JSO" <6399bwmNOSPAM@.community.nospam> wrote in message
news:D735DEE3-F3E8-4250-9AAA-396D1B3742B2@.microsoft.com...
>I have a subscription that will not deliver to a file share. I've ensured
> that the windows acct for share access for the subscription has read/write
> to
> the share.
> The error I get in report manager is:
> Failure writing file <report name>: The Report Server has encountered a
> configuration error; more details in the log files
>
> The log file says:
> ReportingServicesService!library!10ec!08/08/2005-12:26:05:: i INFO: Call
> to
> RenderFirst( '/My Reports/<report name>)
> ReportingServicesService!library!10ec!08/08/2005-12:26:06:: e ERROR:
> Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
> the
> log files, AuthzInitializeContextFromSid: Win32 error: 234;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
> the
> log files
> ReportingServicesService!library!10ec!08/08/2005-12:26:06:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system
> properties.
> ReportingServicesService!subscription!10ec!08/08/2005-12:26:06::
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
> Server has encountered a configuration error; more details in the log
> files
> -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
> the
> log files
> at
> Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
> userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
> Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
> userName, IntPtr userToken)
> at
> Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation
> requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID,
> Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection
> values,
> DatasourceCredentialsCollection credentials)
> at
> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
> Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification
> notification, SubscriptionData data)
> at
> Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.Deliver(Notification
> notification)
>
> Any ideas?
> TIA,
> Berry Morgan
> JSO|||The subscription creator is a production domain account, but the
ReportServer service identity is NT AUTHORITY\Network Service.
If I change the ReportServer service identity to a domain account, won't
that require reactivation of the reporting server?
Also, email subscriptions currently work: wouldn't changing the service
identity require configuration changes for this subscription type as well?
My hunch is that subscription delivery to file shares is tied in with code
access security settings, but I'm not the MVP. :)
-Berry
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ewEcpyGnFHA.3304@.tk2msftngp13.phx.gbl...
> Are the user who created the report subscription and the ReportServer in
> the same domain (actually the ReportServerService service account). We
> have seen this issue in our DEV + QA environments which are in different
> domains that are not trusted by our prod domain (but do trust it). We have
> configured all our Report Servers to run under prod domain service
> accounts to get around this issue (because when testing subscriptions,
> developers will still be using their prod accounts and it seems that it is
> the subscription owner account that was failing to be resolved)
>|||Our issue was purely domain related however what I would suggest is that you
contact PSS. They'll be able to provide you with a utility that should help
pinpoint the issue. This is a common problem (the error message you are
seeing) and it's all related to being able to query AD and permissions
related to that (rather than specifically anything SQL related). PSS will be
able to help you track down the specific issue in your environment. Email
subscriptions don't suffer the same issue as far as I'm aware (we haven't
seen it but that doesn't mean it doesn't exist<g>)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Berry Morgan" <6399bwmNOSPAM@.community.nospam> wrote in message
news:uwK78DTnFHA.1372@.TK2MSFTNGP10.phx.gbl...
> The subscription creator is a production domain account, but the
> ReportServer service identity is NT AUTHORITY\Network Service.
> If I change the ReportServer service identity to a domain account, won't
> that require reactivation of the reporting server?
> Also, email subscriptions currently work: wouldn't changing the service
> identity require configuration changes for this subscription type as well?
> My hunch is that subscription delivery to file shares is tied in with code
> access security settings, but I'm not the MVP. :)
> -Berry
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:ewEcpyGnFHA.3304@.tk2msftngp13.phx.gbl...
>> Are the user who created the report subscription and the ReportServer in
>> the same domain (actually the ReportServerService service account). We
>> have seen this issue in our DEV + QA environments which are in different
>> domains that are not trusted by our prod domain (but do trust it). We
>> have configured all our Report Servers to run under prod domain service
>> accounts to get around this issue (because when testing subscriptions,
>> developers will still be using their prod accounts and it seems that it
>> is the subscription owner account that was failing to be resolved)
>
File Share Delivery Failing
I'm trying to deliver a report via the included File Share Delivery method. Every time the subscription fires, the delivery fails with this error in the interface:
An in ReportServerService<dateTime>.log, I find the following error:
I have tried using the <domain>\<user> username syntax. I have tried sending to multiple different machines. The only deployment that succeeded was to \\localhost\c$\test with administrator credentials entered into the Subscription (unacceptable, of course).
Failure writing file Test.pdf : A logon error occurred when attempting to access the file share. The user account or password is not valid.
An in ReportServerService<dateTime>.log, I find the following error:
ReportingServicesService!library!10!08/22/2007-16:17:08:: e ERROR: Throwing Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid., A logon error occurred when attempting to access the file share. The user account or password is not valid.;
Info: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
End of inner exception stack trace
ReportingServicesService!subscription!10!08/22/2007-16:17:08:: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
End of inner exception stack trace
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData d)
ReportingServicesService!subscription!10!08/22/2007-16:17:08:: i INFO: Error writing file Test.pdf to path \\mrhowell\SYS\junk\josh
I have tried using the <domain>\<user> username syntax. I have tried sending to multiple different machines. The only deployment that succeeded was to \\localhost\c$\test with administrator credentials entered into the Subscription (unacceptable, of course).
I've seen this issue raised on this forum at least twice, and neither was met with any ideas or answers. Has anyone encountered and overcome this issue?
I'm having the exact same issue...if you get any sort of response please let me know.
|||Are you using the development edition? I think you can only use localhost on that.
File Share Delivery Failing
I'm trying to deliver a report via the included File Share Delivery method. Every time the subscription fires, the delivery fails with this error in the interface:
An in ReportServerService<dateTime>.log, I find the following error:
I have tried using the <domain>\<user> username syntax. I have tried sending to multiple different machines. The only deployment that succeeded was to \\localhost\c$\test with administrator credentials entered into the Subscription (unacceptable, of course).
Failure writing file Test.pdf : A logon error occurred when attempting to access the file share. The user account or password is not valid.
An in ReportServerService<dateTime>.log, I find the following error:
ReportingServicesService!library!10!08/22/2007-16:17:08:: e ERROR: Throwing Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid., A logon error occurred when attempting to access the file share. The user account or password is not valid.;
Info: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
End of inner exception stack trace
ReportingServicesService!subscription!10!08/22/2007-16:17:08:: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
End of inner exception stack trace
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData d)
ReportingServicesService!subscription!10!08/22/2007-16:17:08:: i INFO: Error writing file Test.pdf to path \\mrhowell\SYS\junk\josh
I have tried using the <domain>\<user> username syntax. I have tried sending to multiple different machines. The only deployment that succeeded was to \\localhost\c$\test with administrator credentials entered into the Subscription (unacceptable, of course).
I've seen this issue raised on this forum at least twice, and neither was met with any ideas or answers. Has anyone encountered and overcome this issue?
I'm having the exact same issue...if you get any sort of response please let me know.
File Share Delivery Error
I have given subscription access to a domain group in reporting services.
Well when the users create a file share subscription and the subscription
launches they are getting the message "Failure writing file .pdf : Error
impersonating user." Thanks,
--
Andrew
MCSA,MCDBAThe error is stating that RS can not log on as the user that you configured
the subscription to use. It has nothing to do with the share permissions.
You should make sure that user can log onto the machine that RS is running
on.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew" <Andrew@.discussions.microsoft.com> wrote in message
news:6E473576-5F7A-430D-AB70-A0EB8A4C7C60@.microsoft.com...
>I have given subscription access to a domain group in reporting services.
> Well when the users create a file share subscription and the subscription
> launches they are getting the message "Failure writing file .pdf : Error
> impersonating user." Thanks,
> --
> Andrew
> MCSA,MCDBA|||Daniel,
Thanks for the advice I discovered the only group granted log on locally
rights was the administrators group. Thanks again,
--
Andrew
MCSA,MCDBA
"Daniel Reib [MSFT]" wrote:
> The error is stating that RS can not log on as the user that you configured
> the subscription to use. It has nothing to do with the share permissions.
> You should make sure that user can log onto the machine that RS is running
> on.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Andrew" <Andrew@.discussions.microsoft.com> wrote in message
> news:6E473576-5F7A-430D-AB70-A0EB8A4C7C60@.microsoft.com...
> >I have given subscription access to a domain group in reporting services.
> > Well when the users create a file share subscription and the subscription
> > launches they are getting the message "Failure writing file .pdf : Error
> > impersonating user." Thanks,
> >
> > --
> > Andrew
> > MCSA,MCDBA
>
>
Well when the users create a file share subscription and the subscription
launches they are getting the message "Failure writing file .pdf : Error
impersonating user." Thanks,
--
Andrew
MCSA,MCDBAThe error is stating that RS can not log on as the user that you configured
the subscription to use. It has nothing to do with the share permissions.
You should make sure that user can log onto the machine that RS is running
on.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew" <Andrew@.discussions.microsoft.com> wrote in message
news:6E473576-5F7A-430D-AB70-A0EB8A4C7C60@.microsoft.com...
>I have given subscription access to a domain group in reporting services.
> Well when the users create a file share subscription and the subscription
> launches they are getting the message "Failure writing file .pdf : Error
> impersonating user." Thanks,
> --
> Andrew
> MCSA,MCDBA|||Daniel,
Thanks for the advice I discovered the only group granted log on locally
rights was the administrators group. Thanks again,
--
Andrew
MCSA,MCDBA
"Daniel Reib [MSFT]" wrote:
> The error is stating that RS can not log on as the user that you configured
> the subscription to use. It has nothing to do with the share permissions.
> You should make sure that user can log onto the machine that RS is running
> on.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Andrew" <Andrew@.discussions.microsoft.com> wrote in message
> news:6E473576-5F7A-430D-AB70-A0EB8A4C7C60@.microsoft.com...
> >I have given subscription access to a domain group in reporting services.
> > Well when the users create a file share subscription and the subscription
> > launches they are getting the message "Failure writing file .pdf : Error
> > impersonating user." Thanks,
> >
> > --
> > Andrew
> > MCSA,MCDBA
>
>
File Share Data-Driven Subscription
Hi.
Iâ'm trying to create File Share Data-Driven Subscription. Everything work
right, but when I set User and Password to the position â'Get the value from
databaseâ' some problems begin: the subscription stops working immediately, it
doesnâ't even try to generate report.
Can anybody help me?Yes, this is a known issue with RS. The credentials do not get encrypted
when the notification is created from the DD subscription, causing the
notification to fail. There is a work around, but it is not pretty. :)
Basically it required creating a subscription for each username/password
combo, each time you create it, find the encrypted values in the database
for the user name and password. Store these values in your table where your
DD subscription query is getting it's values. Obviously this won't work if
you can't change the values in the DD queries table.
This issue will be fixed in the next release of RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Boris" <frolovBA@.trytoguessHM.com> wrote in message
news:A7EE6253-C8C5-41B9-B9B8-E97219F10946@.microsoft.com...
> Hi.
> I'm trying to create File Share Data-Driven Subscription. Everything work
> right, but when I set User and Password to the position "Get the value
> from
> database" some problems begin: the subscription stops working immediately,
> it
> doesn't even try to generate report.
> Can anybody help me?
>
Iâ'm trying to create File Share Data-Driven Subscription. Everything work
right, but when I set User and Password to the position â'Get the value from
databaseâ' some problems begin: the subscription stops working immediately, it
doesnâ't even try to generate report.
Can anybody help me?Yes, this is a known issue with RS. The credentials do not get encrypted
when the notification is created from the DD subscription, causing the
notification to fail. There is a work around, but it is not pretty. :)
Basically it required creating a subscription for each username/password
combo, each time you create it, find the encrypted values in the database
for the user name and password. Store these values in your table where your
DD subscription query is getting it's values. Obviously this won't work if
you can't change the values in the DD queries table.
This issue will be fixed in the next release of RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Boris" <frolovBA@.trytoguessHM.com> wrote in message
news:A7EE6253-C8C5-41B9-B9B8-E97219F10946@.microsoft.com...
> Hi.
> I'm trying to create File Share Data-Driven Subscription. Everything work
> right, but when I set User and Password to the position "Get the value
> from
> database" some problems begin: the subscription stops working immediately,
> it
> doesn't even try to generate report.
> Can anybody help me?
>
Subscribe to:
Posts (Atom)