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:

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:

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 Open

I wanted to find out how to open a file in a Trigger?
I have a need to open a file, write some information
when trigger fires and then close it.
Thank you,
-Me
"Me" <Me@.discussions.microsoft.com> wrote in message
news:09CD669D-4E60-44C6-AFD2-3F2385AEFDC2@.microsoft.com...
>I wanted to find out how to open a file in a Trigger?
> I have a need to open a file, write some information
> when trigger fires and then close it.
> Thank you,
> -Me
>
I'm not sure if this will work from within a Trigger, but you can take a
look at the xp_cmdshell stored procedure. Another option might be to create
a COM object (or .NET object in a COM wrapper) and use the sp_OA* stored
procedures to instantiate the object and call it's methods.
Rick Sawtell
MCT, MCSD, MCDBA
|||I don't recommend executing this type from triggers. The transaction is open and the rows are locked
while the trigger is executing, and the modification will fail if the code in the trigger fails. I
would insert relevant data in a table and then create a SQL Server Agent job that read rows off of
that table and does the necessary "external" processing.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Me" <Me@.discussions.microsoft.com> wrote in message
news:09CD669D-4E60-44C6-AFD2-3F2385AEFDC2@.microsoft.com...
>I wanted to find out how to open a file in a Trigger?
> I have a need to open a file, write some information
> when trigger fires and then close it.
> Thank you,
> -Me
>
|||Thank you Rick.
-Me
"Rick Sawtell" wrote:

> "Me" <Me@.discussions.microsoft.com> wrote in message
> news:09CD669D-4E60-44C6-AFD2-3F2385AEFDC2@.microsoft.com...
>
> I'm not sure if this will work from within a Trigger, but you can take a
> look at the xp_cmdshell stored procedure. Another option might be to create
> a COM object (or .NET object in a COM wrapper) and use the sp_OA* stored
> procedures to instantiate the object and call it's methods.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Tibor,
Thank you, I agree with you, we should adopt another approach.
-Me
"Tibor Karaszi" wrote:

> I don't recommend executing this type from triggers. The transaction is open and the rows are locked
> while the trigger is executing, and the modification will fail if the code in the trigger fails. I
> would insert relevant data in a table and then create a SQL Server Agent job that read rows off of
> that table and does the necessary "external" processing.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Me" <Me@.discussions.microsoft.com> wrote in message
> news:09CD669D-4E60-44C6-AFD2-3F2385AEFDC2@.microsoft.com...
>
>

File Open

I wanted to find out how to open a file in a Trigger?
I have a need to open a file, write some information
when trigger fires and then close it.
Thank you,
-Me"Me" <Me@.discussions.microsoft.com> wrote in message
news:09CD669D-4E60-44C6-AFD2-3F2385AEFDC2@.microsoft.com...
>I wanted to find out how to open a file in a Trigger?
> I have a need to open a file, write some information
> when trigger fires and then close it.
> Thank you,
> -Me
>
I'm not sure if this will work from within a Trigger, but you can take a
look at the xp_cmdshell stored procedure. Another option might be to create
a COM object (or .NET object in a COM wrapper) and use the sp_OA* stored
procedures to instantiate the object and call it's methods.
Rick Sawtell
MCT, MCSD, MCDBA|||I don't recommend executing this type from triggers. The transaction is open
and the rows are locked
while the trigger is executing, and the modification will fail if the code i
n the trigger fails. I
would insert relevant data in a table and then create a SQL Server Agent job
that read rows off of
that table and does the necessary "external" processing.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Me" <Me@.discussions.microsoft.com> wrote in message
news:09CD669D-4E60-44C6-AFD2-3F2385AEFDC2@.microsoft.com...
>I wanted to find out how to open a file in a Trigger?
> I have a need to open a file, write some information
> when trigger fires and then close it.
> Thank you,
> -Me
>|||Thank you Rick.
-Me
"Rick Sawtell" wrote:

> "Me" <Me@.discussions.microsoft.com> wrote in message
> news:09CD669D-4E60-44C6-AFD2-3F2385AEFDC2@.microsoft.com...
>
> I'm not sure if this will work from within a Trigger, but you can take a
> look at the xp_cmdshell stored procedure. Another option might be to crea
te
> a COM object (or .NET object in a COM wrapper) and use the sp_OA* stored
> procedures to instantiate the object and call it's methods.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Tibor,
Thank you, I agree with you, we should adopt another approach.
-Me
"Tibor Karaszi" wrote:

> I don't recommend executing this type from triggers. The transaction is op
en and the rows are locked
> while the trigger is executing, and the modification will fail if the code
in the trigger fails. I
> would insert relevant data in a table and then create a SQL Server Agent j
ob that read rows off of
> that table and does the necessary "external" processing.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Me" <Me@.discussions.microsoft.com> wrote in message
> news:09CD669D-4E60-44C6-AFD2-3F2385AEFDC2@.microsoft.com...
>
>

File Open

I wanted to find out how to open a file in a Trigger?
I have a need to open a file, write some information
when trigger fires and then close it.
Thank you,
-Me"Me" <Me@.discussions.microsoft.com> wrote in message
news:09CD669D-4E60-44C6-AFD2-3F2385AEFDC2@.microsoft.com...
>I wanted to find out how to open a file in a Trigger?
> I have a need to open a file, write some information
> when trigger fires and then close it.
> Thank you,
> -Me
>
I'm not sure if this will work from within a Trigger, but you can take a
look at the xp_cmdshell stored procedure. Another option might be to create
a COM object (or .NET object in a COM wrapper) and use the sp_OA* stored
procedures to instantiate the object and call it's methods.
Rick Sawtell
MCT, MCSD, MCDBA|||I don't recommend executing this type from triggers. The transaction is open and the rows are locked
while the trigger is executing, and the modification will fail if the code in the trigger fails. I
would insert relevant data in a table and then create a SQL Server Agent job that read rows off of
that table and does the necessary "external" processing.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Me" <Me@.discussions.microsoft.com> wrote in message
news:09CD669D-4E60-44C6-AFD2-3F2385AEFDC2@.microsoft.com...
>I wanted to find out how to open a file in a Trigger?
> I have a need to open a file, write some information
> when trigger fires and then close it.
> Thank you,
> -Me
>|||Thank you Rick.
-Me
"Rick Sawtell" wrote:
> "Me" <Me@.discussions.microsoft.com> wrote in message
> news:09CD669D-4E60-44C6-AFD2-3F2385AEFDC2@.microsoft.com...
> >I wanted to find out how to open a file in a Trigger?
> > I have a need to open a file, write some information
> > when trigger fires and then close it.
> >
> > Thank you,
> > -Me
> >
>
> I'm not sure if this will work from within a Trigger, but you can take a
> look at the xp_cmdshell stored procedure. Another option might be to create
> a COM object (or .NET object in a COM wrapper) and use the sp_OA* stored
> procedures to instantiate the object and call it's methods.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Tibor,
Thank you, I agree with you, we should adopt another approach.
-Me
"Tibor Karaszi" wrote:
> I don't recommend executing this type from triggers. The transaction is open and the rows are locked
> while the trigger is executing, and the modification will fail if the code in the trigger fails. I
> would insert relevant data in a table and then create a SQL Server Agent job that read rows off of
> that table and does the necessary "external" processing.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Me" <Me@.discussions.microsoft.com> wrote in message
> news:09CD669D-4E60-44C6-AFD2-3F2385AEFDC2@.microsoft.com...
> >I wanted to find out how to open a file in a Trigger?
> > I have a need to open a file, write some information
> > when trigger fires and then close it.
> >
> > Thank you,
> > -Me
> >
>
>