Suddenly file share subscription doesn't work - logon error oc

Similar Threads:

1.Suddenly file share subscription doesn't work - logon error occurs

Dear fellows.

A very frustrating error keeps occuring for my report subsciption. Even 
though the supplied credentials are valid (have tried to use administrator 
credentials and all kinds of workarounds) the following error message is 
received:

"Failure writing file Tider.xls : A logon error occurred when attempting to 
access the file share. The user account or password is not valid."

The file share is on a server different from the one that runs the report 
server but even if I use a file share on the same server I get the same error.

Another curious fact is that there is no information in the event log, 
neither in the server that runs RS nor the one of the file share, at the time 
of failure. In the RS log file, however, the following is found:

.
.
.
.
ReportingServicesService!library!e!10/09/2006-19:24:17:: 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!e!10/09/2006-19:24:17:: 
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 data)
ReportingServicesService!subscription!e!10/09/2006-19:24:17:: Error writing 
file Export.xls to path \\SERVER01\reports\Company01
ReportingServicesService!dbpolling!e!10/09/2006-19:24:17:: 
NotificationPolling finished processing item 
4a2093ca-f34a-4f74-b16e-c0c358dee752
.
.
.

2.Subject: File share Subscription not working

This is a re-posted issue.
Could someone please help me on my issue? I have to fix this problem. Thanks.

I have created a File Share Subscription, it just not working. In the same 
env. with same report and subscription query, I created Email Subscription, 
it works fine. But File share subscription does not work, not file generated 
in the folder, which uncheck "Read Only" property. Not error message I can 
find. In the SQL Agent job, it tell me jobs run successfully.  In the Report 
Manager, the status of the Subscription is :Processing: 0 processed of 1 
total; 0 errors." Looks like it nevery finishing the processing. Even I 
restart the Report Server service.

Anybody know what is going on? Thanks.

Tony

3.File share Subscription not working

I have created a File Share Subscription, it just not working. In the same 
env. with same report and subscription query, I created Email Subscription, 
it works fine. But File share subscription does not work, not file generated 
in the folder, which uncheck "Read Only" property. Not error message I can 
find. In the SQL Agent job, it tell me jobs run successfully.  In the Report 
Manager, the status of the Subscription is :Processing: 0 processed of 1 
total; 0 errors." Looks like it nevery finishing the processing. Even I 
restart the Report Server service.

Anybody know what is going on? Thanks.

Tony

4.SOLVED linked server suddenly doesn't work!!!

SOLVED... apparently there was a DNS problem on the LAN yesterday afternoon
that made my app look at the wrong server. He who did that will hang.

Thanks,

Ray



"R. van Laake" < XXXX@XXXXX.COM > wrote in message
news:4200f16d$0$14124$ XXXX@XXXXX.COM ...
> Hi,
>
> I have an ASP page working with a database DBNL. There also is a linked
> server named OFFICE. Until an hour ago all worked fine; I could get data
> with a statement like "select name from office.custdata.dbo.customers".
>
> Suddenly, without **ANY** changes at all to either server it stopped
> working. Using the Query Analyzer, when I connect to DBNL and run the
> "select name from office.custdata.dbo.customers" statement, I get this
> message:
>
> Server: Msg 7314, Level 16, State 1, Line 1
> OLE DB provider 'office' does not contain table
> '"custdata"."dbo"."customers"'.  The table either does not exist or the
> current user does not have permissions on that table.
> OLE DB error trace [Non-interface error:  OLE DB provider does not contain
> the table: ProviderName='office',
TableName='"custdata"."dbo"."customers"'].
>
>
> (1) The customers table *does* exist on the OFFICE server, and works
> flawlessly (I can access it with the Enterprise Manager). According to
these
> messages, it must be a permissions issue
>
> (2) I can get into the customers table with the Query Analyzer, and
connect
> to the OFFICE server. I use the same username/password that I use for the
> Linked Server, so that is ok. But when I connect to the DBNL server and
try
> to get into the customers table thru the Linked Server I get the error.
>
> Who can help?? Stupid thing is it worked until an hour ago, and nothing
> whatsoever has changed on the servers.................
>
> Thanks,
>
> Ray
>
>
>

5.linked server suddenly doesn't work!!!

Hi,

I have an ASP page working with a database DBNL. There also is a linked
server named OFFICE. Until an hour ago all worked fine; I could get data
with a statement like "select name from office.custdata.dbo.customers".

Suddenly, without **ANY** changes at all to either server it stopped
working. Using the Query Analyzer, when I connect to DBNL and run the
"select name from office.custdata.dbo.customers" statement, I get this
message:

Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'office' does not contain table
'"custdata"."dbo"."customers"'.  The table either does not exist or the
current user does not have permissions on that table.
OLE DB error trace [Non-interface error:  OLE DB provider does not contain
the table: ProviderName='office', TableName='"custdata"."dbo"."customers"'].


(1) The customers table *does* exist on the OFFICE server, and works
flawlessly (I can access it with the Enterprise Manager). According to these
messages, it must be a permissions issue

(2) I can get into the customers table with the Query Analyzer, and connect
to the OFFICE server. I use the same username/password that I use for the
Linked Server, so that is ok. But when I connect to the DBNL server and try
to get into the customers table thru the Linked Server I get the error.

Who can help?? Stupid thing is it worked until an hour ago, and nothing
whatsoever has changed on the servers.................

Thanks,

Ray

6. Why SQL 7.0 Merge Replication suddenly doesn't work ?

7. Subscription suddenly stopped working

8. Date as a part of the file name in File Share subscription