SQL Bulk Load Error from Delegation Issues

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 Active 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
#microsoft #registry #windows