xp_cmdshell problem

[DanC]

I've had a dts package scheduled for about 2 months that runs every day with no problem. All of the sudden, it errors out today. In the job history, this is what's displayed:

The job failed. Unable to determine if the owner (LLC\dan) of job automated_clientv7_daily_pull has server access (reason: Could not obtain information about Windows NT group/user 'LLC\dan'. [SQLSTATE 42000] (Error 8198)).

Here is the xp_cmdshell statement I am running:

DECLARE @FileName varchar(50),
@Command1 varchar(2000)

SET @FileName = convert(varchar, getdate(), 112)

SET @Command1 = 'copy \\dan\projects\version7\clientname\daily_data_pulls\reports.xls \\Conus\Clients\clientname\daily\reports_' + @filename + '.xls'

EXEC master.dbo.xp_cmdshell @command1

as I said, it worked fine until this afternoon. Any insight would be appreciated.

thanks

-Dan

 

[Lezza]

Dan,

I've gotten this before. The SQL Server was unable to hit the PDC in order to verify the Domain User rights. Either there's been a change to your network security, local server security, or the PDC went down last night.

 

[DanC]

thanks for the response, that seems to be exactly what it is. It appears as if the domain controllers here are out of synch.