Reporting Services Subscriptions / Sharepoint question

I'm trying to create a subscription that places a file (excel or PDF) in sharepoint. I haven't been able to find a path that works. I was wondering if anyone else had had this issue and how they overcame it.

Thanks.Answered my own question.

http://technet.microsoft.com/en-us/library/bb326364.aspx

Reporting Services Subscription Table DataSettings field cut off at 256 characters!

Does anybody know why when i create a subscription using rs.CreateDataDrivenSubscription, the datasettings that is saved in the subscriptions table is cut off at 256 characters.

can anyone help?

Is the column defined as an ntext? If so then somehow your DB is corrupt. Otherwise, I have never seen this issue before.

-Daniel

Reporting Services Subscription Problem

I have a subscription set up in reporting services. When SQL Agent attempts to send out the subscription it reports
the following error:
[298] SQLServer Error: 8198, Could not obtain information about Windows NT group/user 'DOMAIN\MACHINE$'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
Where DOMAIN is the domain name and MACHINE is the name of the machine Reporting Service is running on.
Reporting services runs on a separate machine from SQL server. Both machine run Windows 2003 Server. Any suggestion about how to fix this?
--Tom
What is your sql server account running as? You may need to use sql auth to
connect to the report server database. You can use rsconfig.exe to change
this setting.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"tom777@.newsgroups.nospam" <anonymous@.discussions.microsoft.com> wrote in
message news:DF3DA2CA-BC34-471D-BDB0-E476CA043577@.microsoft.com...
> I have a subscription set up in reporting services. When SQL Agent
attempts to send out the subscription it reports
> the following error:
> [298] SQLServer Error: 8198, Could not obtain information about Windows NT
group/user 'DOMAIN\MACHINE$'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
> Where DOMAIN is the domain name and MACHINE is the name of the machine
Reporting Service is running on.
> Reporting services runs on a separate machine from SQL server. Both
machine run Windows 2003 Server. Any suggestion about how to fix this?
> --Tom
|||Look also to services MSSQLSERVER AND SQLSERVERAGENT... If they have been started with an other profile you can have this problem...when you try to use database Maintenance plan...

Reporting Services Subscription Problem

I have a subscription set up in reporting services. When SQL Agent attempts
to send out the subscription it reports
the following error:
[298] SQLServer Error: 8198, Could not obtain information about Windows
NT group/user 'DOMAIN\MACHINE$'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
Where DOMAIN is the domain name and MACHINE is the name of the machine Repor
ting Service is running on.
Reporting services runs on a separate machine from SQL server. Both machine
run Windows 2003 Server. Any suggestion about how to fix this?
--TomWhat is your sql server account running as? You may need to use sql auth to
connect to the report server database. You can use rsconfig.exe to change
this setting.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"tom777@.newsgroups.nospam" <anonymous@.discussions.microsoft.com> wrote in
message news:DF3DA2CA-BC34-471D-BDB0-E476CA043577@.microsoft.com...
> I have a subscription set up in reporting services. When SQL Agent
attempts to send out the subscription it reports
> the following error:
> [298] SQLServer Error: 8198, Could not obtain information about Windows NT[/co
lor]
group/user 'DOMAIN\MACHINE$'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
> Where DOMAIN is the domain name and MACHINE is the name of the machine
Reporting Service is running on.
> Reporting services runs on a separate machine from SQL server. Both
machine run Windows 2003 Server. Any suggestion about how to fix this?
> --Tom|||Look also to services MSSQLSERVER AND SQLSERVERAGENT... If they have been s
tarted with an other profile you can have this problem...when you try to use
database Maintenance plan...

Reporting Services subscription

Hi,
Is it possible to create new subscription for reporting services in sql 2005
standard edition? I get New subscription and New data driven subscription
greyed out.
GSMy understanding is that Data Driven Subscriptions are available only
in Enterprise edition (and up).sql

Reporting Services Scheduled Subscription Logon Error

Hi all,
For 8 months, I have had a set of Timed Subscriptions in use to generate
and email reports. In the last few days, they've failed.
The SQL Agent says success, but when you view the subscriptions in report
manager, they say Logon Failed.
There is nothing in Event viewewr, and I can say that the logon details
have not changed in the slightest! They are still valid. Exactly what
credentials is it picking from?
I'd appreciate suggestions.
Thx
PaulPaul,
Next thing you can do is to see whether the same report is running on the
preview of VS.
Amanarth
"Paul Buxton" wrote:
> Hi all,
> For 8 months, I have had a set of Timed Subscriptions in use to generate
> and email reports. In the last few days, they've failed.
> The SQL Agent says success, but when you view the subscriptions in report
> manager, they say Logon Failed.
> There is nothing in Event viewewr, and I can say that the logon details
> have not changed in the slightest! They are still valid. Exactly what
> credentials is it picking from?
> I'd appreciate suggestions.
> Thx
> Paul
>

Reporting Services Monthly Subscription

Hello,

I'm scheduling monthly subscriptions in reporting services. I would like to receive subscriptions every 2nd Monday of the month. For instance, if the 1st is a Friday, then report should be delivered Monday, the 11th.

So my question is: in reporting services:

if I set the subscription for Monday - 2nd week, and the first day of the month is a Friday

- does it consider the week from 4 -> 10 as the second week (because month began the week before)

- or as the first week (because it takes into account only full weeks)?

Thanks a lot for any help!

Best regards,

Tiago

Hello Tiago,

I just ran a test to check this out. I created a schedule to run on Monday - 2nd week, the next run will be February 12th. It will assume that 1-7 is the first week of any month, 8-14 is the second week, etc.

So, in your example of your subscription on Monday - 2nd week and the 1st is a Friday, it will run on the 11th. Setting a subscription for Monday - 2nd week will be the correct schedule for what you're trying to accomplish.

Hope this helps.

Jarret

|||Excellent, thanks a lot Jarret!