Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

xp_cmdshell problem

Status
Not open for further replies.

DanC

Programmer
Jan 12, 2001
65
US
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
 
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.

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

Part and Inventory Search

Sponsor

Back
Top