Error 1389 (aka 0x80070576 or STATUS_TIME_DIFFERENCE_AT_DC or ERROR_TIME_SKEW)?

Hello
When executing a BULK INSERT sql statement from within a program one of our
clients gets:
SQL Server Error: SQL State: 42000, SQL Error Code: 4861
Could not bulk insert because file
'\\W2K3SRV2\DTASQL$\Xtb860_dv_salspec.TXT' could not be opened. Operating
system error code 1398(There is a time and/or date difference between the
client and server.).
I have looked around the MS Knowledgebase, Google groups, and the internet
in general and have come up with two articles
http://support.microsoft.com/?id=830619
http://www.myitforum.com/articles/8/view.asp?id=6853
but they do not seem to apply to SQL Server. Our app *is* running on a
W2003Server machine named W2K3SRV2 with SQL Server 2000 on another
W2003Server machine named W2K3SRV4, so SQL server is fetching the text file
from W2K3SRV2.
BITS (as mentioned in the first link) is running on W2K3SRV2 but has no
connection with our app.
What could be going on here?
TIA
JanHave you tried syncing the times on the client and server with the domain
controller? Although the article doesn't mention SQL Server specifically,
any application using the underlying Win32 API could get error code 1398 due
to the time difference.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Jan Doggen" <j.doggen@.BLOCKqsa.nl> wrote in message
news:%23nErEnaeGHA.3792@.TK2MSFTNGP03.phx.gbl...
> Hello
> When executing a BULK INSERT sql statement from within a program one of
> our
> clients gets:
> SQL Server Error: SQL State: 42000, SQL Error Code: 4861
> Could not bulk insert because file
> '\\W2K3SRV2\DTASQL$\Xtb860_dv_salspec.TXT' could not be opened. Operating
> system error code 1398(There is a time and/or date difference between the
> client and server.).
> I have looked around the MS Knowledgebase, Google groups, and the internet
> in general and have come up with two articles
> http://support.microsoft.com/?id=830619
> http://www.myitforum.com/articles/8/view.asp?id=6853
> but they do not seem to apply to SQL Server. Our app *is* running on a
> W2003Server machine named W2K3SRV2 with SQL Server 2000 on another
> W2003Server machine named W2K3SRV4, so SQL server is fetching the text
> file
> from W2K3SRV2.
> BITS (as mentioned in the first link) is running on W2K3SRV2 but has no
> connection with our app.
> What could be going on here?
> TIA
> Jan
>