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?
> >