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

Similar Threads:

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

Yes. Or more correct, I have tried to type it both with and without the 
domain. As I mentioned, the whole thing worked until recently (using the 
format you mention).

"Kyle P" wrote:

> Are you using the domain_name\user_name format?

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