Login failed for user. error 18456 when the user is not sysadmin. If I grant the user sysadmin previleges it's working fine.

The job executed a stored procedure with no parameters.

Thanks.

Thanks for quick help. It worked perfectly.

I found it under extension settings in subscription table.

Thanks.

I am looking for technical metadata.

The Result is always less than 1000 records. I guess its not the issue with the number of records it process/return.

It takes more time between 2 AM(after the job ran)...

Can I use the Stored procedure and other setting changes described in these articles on 2012 reporting services?

Thanks.

No. I can't create linked server.

I got the following result with the above query.

2012SP1Standard Edition (64-bit)11.0.3000.0

So can we confirm that it's not a evaluation edition?

Thanks.

Hi,

I was able to implement this with pivot and matrix report. I have all the row groups in the beginning and column groups in the end in the report. But...

I am able to implement with this data driven subscriptions.

Thanks.

Its not just one additional column. The report data comes from the stored procedure which accepts a date as an input parameter and the result will have 12 columns...

I need one more help with this task.I have a solution with 8 reports.

Can I run all the 8 reports as one job instead of running 8 reports as 8...

Thanks. It is a big help.