sql server reporting services: file share subscription problem -- sql server reporting services

file share subscription problem

dcp12345678 NO[at]SPAM yahoo.com
1/4/2005 1:53:54 PM

sql server reporting services:

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

Re: file share subscription problem

Robert Bruckner [MSFT]
1/15/2005 6:22:18 PM

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.

[quoted text, click to view]