SQL Bulk Load Error from Delegation Issues· Windows Scripts
Previously, we received Bulk Load errors in SQL because they computers were not trusted to run a Bulk Load operation from another server. I had to enable “trust” in Activie Directory and then run the script below from a domain controller.
REM Fix a bulk load error in SQL REM I made the following changes: REM Set "Trust this computer for delegation to any service" in AD for SERVERNAME REM Set "Trust this user for delegation to any server" in AD for SQLServiceAccount REM Ran from Domain Controller in CMD REM I did not restart any of the services and I did not disable Named Pipes with the article asks. REM Source: http://msdn.microsoft.com/en-us/library/aa905162(SQL.80).aspx REM If the above steps did not work, we can try this: http://support.microsoft.com/kb/319723 @ECHO OFF setspn -A MSSQLSvc/SERVERNAME DOMAIN\SQLServiceAccount