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
author image

About Joseph Spurrier

I'm passionate about building solutions to automate tasks and improve efficiency. I worked for a few companies in the digital healthcare space. My education is in forensics. Tech guy. Traveler. Runner. Guitar player. Scotch and beer enthusiast. GitHub LinkedIn Twitter Google+

Share this post


Comments powered by Disqus