Error file cleanup maintenance plan

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChielV - 12 Nov 2008 13:12 GMT

Hi,

I am using SQL2005 Enterprise Edition with mixed security and part of my
maintenance plan is the cleaning up of old backup, reports and logs. Owner of
the MP is the SA account.

What NTFS permissions does the SA account have?

I get the following error:

Event Type:    Warning
Event Source:    SQLSERVERAGENT
Event Category:    Job Engine
Event ID:    208
Date:        11/11/2008
Time:        2:10:15 PM
User:        N/A
Computer:    RTD-SQL2
Description:
SQL Server Scheduled Job 'Replication agents checkup'
(0x84EFB951FED8924B81F8D7416D5C4B6F) - Status: Failed - Invoked on:
2008-11-11 14:10:00 - Message: The job failed. Unable to determine if the
owner (sa) of job Replication agents checkup has server access (reason:
Unable to connect to server - check SQL Server and SQL Server Agent
errorlogs).

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Regards,
Chiel Varkevisser
The Netherlands

Reply to this Message

Erland Sommarskog - 12 Nov 2008 22:30 GMT

> I am using SQL2005 Enterprise Edition with mixed security and part of my
> maintenance plan is the cleaning up of old backup, reports and logs.
> Owner of the MP is the SA account.
>
> What NTFS permissions does the SA account have?

The SA account is an SQL Server entity and such it does not have any
NTFS permissions at all. Instead the permissions of the service account
for SQL Server applies.

> I get the following error:
>
[quoted text clipped - 13 lines]
> Unable to connect to server - check SQL Server and SQL Server Agent
> errorlogs).

But this error is about replication. It has nothing to do with
maintenance plans as far as I can see.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message

Jeetu - 13 Nov 2008 12:26 GMT

Hi Cheil,

SA account is the SQL Server Login account.
NTFS permissions defaults to all the windows account.
As far the error goes it looks like its an replication issue and nothing to
do with the NTFS permissions.

> Hi,
>
[quoted text clipped - 28 lines]
> Chiel Varkevisser
> The Netherlands

Reply to this Message

AGrigorof - 14 Nov 2008 19:11 GMT

> Hi,
>
[quoted text clipped - 27 lines]
> Chiel Varkevisser
> The Netherlands

Have you seen the comments here? -
http://www.eventid.net/display.asp?eventid=208&eventno=801&source=SQLSERVERAGENT
&phase=1

See if any of them applies to your case. As the other posters said,
NTFS permissions have nothing do do with it. Are there any other
events in the log that might be related?

Adrian

Reply to this Message