I want to setup datapump through IIS by using setspn commands.

Question

I had setup datapump on a server "uat1" with "europe\autd1" account. For that we had also executed 4 setspn commands using same server and same account, it worked fine.
But then the requirement changed and we now need to set up on the same server i.e. "uat1" but with different account - "europe\olapd1" . For this we had to execute the setspn commands again as the account has changed and so we had to delete the previous setspn commands where we had used "europe\autd1". The setspn commands got executed but then we got error while connecting to the database saying "Authentication failed" using "europe\autd1" account.

So want to understand what went wrong and or what needs to be done.

Answer 1

Hello, Thank you for posting in Q&A forum. This error could be related to the removal of SPN for previous account europe\autd1. Here are some steps we can try to resolve the issue:

1. Check Existing SPNs by command: setspn -L uat1 Make sure there are no related SPNs remained first.
2. Add SPNs for the new accound by command and double check: setspn -S HTTP/uat1 europe\olapd1 setspn -S HTTP/uat1.domain.com europe\olapd1 setspn -L uat1
3. Check if the issue is still here. REF: https://learn.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2012-r2-and-2012/cc731241(v=ws.11) Best Regards,
   Shujun

---If the Answer is helpful, please click "Accept Answer" and upvote it.