SQLTeam.com | Weblogs | Forums

SSRS- How to default all jobs to be ran as BUILTIN\Administrators


#1

I'm receiving the following error when I run any of my reports: 'Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.'

When I use the following query, I noticed that all of my subscriptions for a report was being ran by the user's id. But when I updated the username to 'BUILTIN\Administrators'. and reran it worked.

So this is telling me that if anyone creates a report, it's going to run as their username and not 'BUILTIN\Administrator'. How can I default all reports to be ran as 'BUILTIN\Administrators'?


#2

you forgot to post the query. but generally it's how you configure the data source in Report Manager. You should select an account set up on the server for SSRS reports


#3

Oops,

USE ReportsServer
go

SELECT
d.SubscriptionID
,e.name AS ReportName
,e.path AS ReportPath
,d.LastStatus
,d.LastRunTime
,u.UserName
FROM
dbo.Subscriptions d
JOIN
dbo.Users AS u ON d.ownerid = u.UserID
JOIN
dbo.Catalog e ON itemid = report_oid


#4

OK -- how the report is run and the id used to connect to the database are two different things. Tell me, is Database mail configured?


#5

Yeah it's setup


#6

It's setup and being used by all my jobs I have setup in SQL Agent