I am seeing this also. I granted owner permission to the NTAUTHORITY account for the first database it tries to hit. It run this batch twice:
SET NOCOUNT ON
SELECT size / 128.0 as fileSize,
FILEPROPERTY(name, 'SpaceUsed') / 128.0 as fileUsed,
CASE WHEN max_size = -1 OR max_size = 268435456 THEN -1 ELSE max_size / 128 END as fileMaxSize,
CASE WHEN growth = 0 THEN 0 ELSE 1 END as IsAutoGrow,
is_percent_growth as isPercentGrowth,
growth as fileGrowth,
physical_name
FROM sys.master_files WITH (NOLOCK)
WHERE type = 0 AND is_read_only = 0
AND database_id = 36
Then this batch:
SET NOCOUNT ON
SELECT fg.name as fileGroupName,
fg.data_space_id as fileGroupId,
fg.is_read_only as fileGroupReadOnly
FROM sys.filegroups fg WHERE type = 'FG' AND fg.is_read_only = 0
Then is tries to open another db and fails and goes back and runs the first batch on the first db again.
Anyone figured this out yet?
barry