Home Forums SQL Server 2005 Administering Login failed for user 'NT AUTHORITY\SYSTEM', Very straing RE: Login failed for user 'NT AUTHORITY\SYSTEM', Very straing

  • 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