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. Tech guy. Traveler. Runner. Guitar player. Scotch and beer enthusiast. Keybase GitHub Gists LinkedIn Twitter

Share this post


Comments powered by Disqus