FileShareProvider delivery extension credential encoding

I receive the following error when I try to provide a username and password
to the FileShareProvider delivery extension through the data-driven
subscription query:
ReportingServicesService!dbpolling!5d8!07/14/2004-17:20:23::
NotificationPolling processing item 951ca046-a4a7-4657-be85-04512f3e8787
ReportingServicesService!crypto!5d8!07/14/2004-17:20:23:: e ERROR:
DBUnProtectData failed: System.FormatException: Invalid character in a
Base-64 string.
at System.Convert.FromBase64String(String s)
at
Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(Strin
g data)
ReportingServicesService!crypto!5d8!07/14/2004-17:20:23:: i INFO: Current
user: secret
ReportingServicesService!notification!5d8!07/14/2004-17:20:23:: e ERROR:
Error occured processing notification. Invalid character in a Base-64
string.
ReportingServicesService!library!5d8!07/14/2004-17:20:23:: Data Driven
Notification for activation id c0eac265-fe46-4de5-9b13-4745be82bd25 was
saved.
ReportingServicesService!library!5d8!07/14/2004-17:20:23:: Status: Invalid
character in a Base-64 string.
ReportingServicesService!notification!5d8!07/14/2004-17:20:23:: Notification
951ca046-a4a7-4657-be85-04512f3e8787 completed. Success: True, Status:
Invalid character in a Base-64 string., DeliveryExtension: Report Server
FileShare, Report: Invoice, Attempt 0
ReportingServicesService!dbpolling!5d8!07/14/2004-17:20:24::
NotificationPolling finished processing item
951ca046-a4a7-4657-be85-04512f3e8787
It seems that the extension is trying to decode the username and password
from the query, but can't since they aren't encoded. If I hard-code the
username and password values in the subscription itself, everything works
fine.
I tried to use
Microsoft.ReportingServices.Diagnostics.DataProtection.DBProtectData to
encode the username and password before storing them in the database, but am
getting the following error:
System.Security.SecurityException: Request for the permission of type
System.Security.Permissions.StrongNameIdentityPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed..
What do I need to do to make the extension happy?
JayIt's a know issue, the user name and password are not supported by the file
share delivery extension, can you make them not data driven - i.e. constant?
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jay Hackney" <jayh@.nospam.intellinet.com> wrote in message
news:#wIsGe2aEHA.3804@.TK2MSFTNGP10.phx.gbl...
> I receive the following error when I try to provide a username and
password
> to the FileShareProvider delivery extension through the data-driven
> subscription query:
> ReportingServicesService!dbpolling!5d8!07/14/2004-17:20:23::
> NotificationPolling processing item 951ca046-a4a7-4657-be85-04512f3e8787
> ReportingServicesService!crypto!5d8!07/14/2004-17:20:23:: e ERROR:
> DBUnProtectData failed: System.FormatException: Invalid character in a
> Base-64 string.
> at System.Convert.FromBase64String(String s)
> at
>
Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(Strin
> g data)
> ReportingServicesService!crypto!5d8!07/14/2004-17:20:23:: i INFO: Current
> user: secret
> ReportingServicesService!notification!5d8!07/14/2004-17:20:23:: e ERROR:
> Error occured processing notification. Invalid character in a Base-64
> string.
> ReportingServicesService!library!5d8!07/14/2004-17:20:23:: Data Driven
> Notification for activation id c0eac265-fe46-4de5-9b13-4745be82bd25 was
> saved.
> ReportingServicesService!library!5d8!07/14/2004-17:20:23:: Status: Invalid
> character in a Base-64 string.
> ReportingServicesService!notification!5d8!07/14/2004-17:20:23::
Notification
> 951ca046-a4a7-4657-be85-04512f3e8787 completed. Success: True, Status:
> Invalid character in a Base-64 string., DeliveryExtension: Report Server
> FileShare, Report: Invoice, Attempt 0
> ReportingServicesService!dbpolling!5d8!07/14/2004-17:20:24::
> NotificationPolling finished processing item
> 951ca046-a4a7-4657-be85-04512f3e8787
> It seems that the extension is trying to decode the username and password
> from the query, but can't since they aren't encoded. If I hard-code the
> username and password values in the subscription itself, everything works
> fine.
> I tried to use
> Microsoft.ReportingServices.Diagnostics.DataProtection.DBProtectData to
> encode the username and password before storing them in the database, but
am
> getting the following error:
> System.Security.SecurityException: Request for the permission of type
> System.Security.Permissions.StrongNameIdentityPermission, mscorlib,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
> failed..
> What do I need to do to make the extension happy?
> Jay
>

FileShare doesn't work

at
Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetI
mpersonationToken(String userName, String domain, String userPwd)
at
Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.Save
Report(Notification notification, SubscriptionData data)
ReportingServicesService!subscription!cb0!12/15/2004-13:25:37:: Error
writing file Service.pdf to path \\Development1\shared\privatedata$\Jeffrey
ReportingServicesService!library!cb0!12/15/2004-13:25:37:: Data Driven
Notification for activation id 9883ba29-804f-45d8-b962-14ccd78ec476 was
saved.
ReportingServicesService!library!cb0!12/15/2004-13:25:37:: Status: Failure
writing file Service.pdf : Logon failure: unknown user name or bad password
ReportingServicesService!dbpolling!cb0!12/15/2004-13:25:37::
NotificationPolling finished processing item
69eaf064-cebf-428e-b1b4-c9f4b3a2386b
I try to create a subscription and write file to a network folder
\\Development1\shared\privatedata$\Jeffrey.King
It doesn't work. I guess I used the right user name and password. Because I
used the same user name and password through Windows Explore and it works.
I have to mention I am in the network, but I didn't login using domain user.
I map the network folder by providing user name and password.
Is there any way I can provide the domain infomaiton to Report Server?
Thanks any help!Did you pass in the user name as domain\username? Have you tried other
users? other shares?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"DotNetUser" <DotNetUser@.yahoo.com> wrote in message
news:OX3ISXt4EHA.1404@.TK2MSFTNGP11.phx.gbl...
> at
> Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetI
> mpersonationToken(String userName, String domain, String userPwd)
> at
> Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.Save
> Report(Notification notification, SubscriptionData data)
> ReportingServicesService!subscription!cb0!12/15/2004-13:25:37:: Error
> writing file Service.pdf to path
> \\Development1\shared\privatedata$\Jeffrey
> ReportingServicesService!library!cb0!12/15/2004-13:25:37:: Data Driven
> Notification for activation id 9883ba29-804f-45d8-b962-14ccd78ec476 was
> saved.
> ReportingServicesService!library!cb0!12/15/2004-13:25:37:: Status: Failure
> writing file Service.pdf : Logon failure: unknown user name or bad
> password
> ReportingServicesService!dbpolling!cb0!12/15/2004-13:25:37::
> NotificationPolling finished processing item
> 69eaf064-cebf-428e-b1b4-c9f4b3a2386b
>
> I try to create a subscription and write file to a network folder
> \\Development1\shared\privatedata$\Jeffrey.King
> It doesn't work. I guess I used the right user name and password. Because
> I
> used the same user name and password through Windows Explore and it works.
> I have to mention I am in the network, but I didn't login using domain
> user.
> I map the network folder by providing user name and password.
> Is there any way I can provide the domain infomaiton to Report Server?
>
> Thanks any help!
>
>|||I tried both Domain\username and username. Neither works. I tried my local
folder, it's ok.
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ODkkd$u4EHA.2676@.TK2MSFTNGP12.phx.gbl...
> Did you pass in the user name as domain\username? Have you tried other
> users? other shares?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "DotNetUser" <DotNetUser@.yahoo.com> wrote in message
> news:OX3ISXt4EHA.1404@.TK2MSFTNGP11.phx.gbl...
> > at
> >
Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetI
> > mpersonationToken(String userName, String domain, String userPwd)
> > at
> >
Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.Save
> > Report(Notification notification, SubscriptionData data)
> > ReportingServicesService!subscription!cb0!12/15/2004-13:25:37:: Error
> > writing file Service.pdf to path
> > \\Development1\shared\privatedata$\Jeffrey
> > ReportingServicesService!library!cb0!12/15/2004-13:25:37:: Data Driven
> > Notification for activation id 9883ba29-804f-45d8-b962-14ccd78ec476 was
> > saved.
> > ReportingServicesService!library!cb0!12/15/2004-13:25:37:: Status:
Failure
> > writing file Service.pdf : Logon failure: unknown user name or bad
> > password
> > ReportingServicesService!dbpolling!cb0!12/15/2004-13:25:37::
> > NotificationPolling finished processing item
> > 69eaf064-cebf-428e-b1b4-c9f4b3a2386b
> >
> >
> >
> > I try to create a subscription and write file to a network folder
> > \\Development1\shared\privatedata$\Jeffrey.King
> > It doesn't work. I guess I used the right user name and password.
Because
> > I
> > used the same user name and password through Windows Explore and it
works.
> >
> > I have to mention I am in the network, but I didn't login using domain
> > user.
> > I map the network folder by providing user name and password.
> >
> > Is there any way I can provide the domain infomaiton to Report Server?
> >
> >
> > Thanks any help!
> >
> >
> >
> >
>

File transfer

I have to make a process/stored procedure that will either send or receive from a specific location (parameters: ftp server, username, password, filename, etc). Ne direction/help in order to do this. Or if anyone has done this before please help.
thxCould you supply some more specifics?|||The specifies are:

I have to make a sp that will send/receive files to/from an ip address or ftp site.
The sp will query the information such as (filename, send_time, receive/send, servername, usernid, password, size_of_file, etc).
Once this info is queried, the script should transfer the file to respective location using, either exec xp_cmdshell or ne other way.

Since it's critical that the file being sent/received, must succesfully be sent/received. The script must also handle that.

This script will be running on SQL server. Any sample code?
thx|||I guess you're going to use ftp...

OK...build an ftp script...and execute it from a bat file with xp_cmdshell...don't forget to redirect the output...maybe load it to a log table...

I guess you'll interogate a directory..

Use xp_cmdshell 'DIR D;\whatever\*.*

and load that to a table to interogate that...

something like that?

file share

hi
i do not get any errors, but i do not see my reports in the shared folder.
here is my configuraiton table
title ext folder render username pwd write
param1 param2
19051, pdf, \\sqlrpt2\krbi ,NULL ,kr_net\pfuller, rewt, NULL, 19051 ,
12/31/2005
18629 ,pdf ,\\sqlrpt2\krbi ,NULL, kr_net\pfuller ,rewt , NULL , 18629 ,
12/31/2005
writemode is static at overwrite
render is static at acrobati have some more informatino.
here is the log message...
"eportingServicesService!crypto!178c!02/01/2006-16:09:04:: e ERROR:
DBUnProtectData failed: System.FormatException: Invalid character in a
Base-64 string.
at System.Convert.FromBase64String(String s)
at
Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
data)
ReportingServicesService!crypto!178c!02/01/2006-16:09:04:: i INFO: Current
user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!notification!178c!02/01/2006-16:09:04:: e ERROR:
Error occured processing notification. Invalid character in a Base-64
string.
ReportingServicesService!library!178c!02/01/2006-16:09:04:: Data Driven
Notification for activation id ddbec942-54ac-4709-b7f9-3bc73952f662 was
saved.
ReportingServicesService!library!178c!02/01/2006-16:09:04:: Status: Invalid
character in a Base-64 string.
"
"Pete Fuller" <pfuller@.kirbyrisk.com> wrote in message
news:ekaFpY0JGHA.3144@.TK2MSFTNGP11.phx.gbl...
> hi
> i do not get any errors, but i do not see my reports in the shared folder.
> here is my configuraiton table
> title ext folder render username pwd write
> param1 param2
> 19051, pdf, \\sqlrpt2\krbi ,NULL ,kr_net\pfuller, rewt, NULL, 19051 ,
> 12/31/2005
> 18629 ,pdf ,\\sqlrpt2\krbi ,NULL, kr_net\pfuller ,rewt , NULL , 18629 ,
> 12/31/2005
> writemode is static at overwrite
> render is static at acrobat
>