Creating those SPNs worked and now the listener returns kerberos. I'm still getting the Operating system error code 5(Access is denied.) error when trying to bulk import so that is...

I downloaded the Kerberos Configuration Manager and the results were interesting. Either my set up is a little strange or my understanding of it is off. The SPNs it said...

The changes were put in as described and I still cannot get SQLC (listener) to use Kerberos. I should also mention that this is in effort to be able to...

Got it. SQL automatically created SPNs for the nodes using the example I gave above so I was trying to follow that for the listener. I'll remove the reference to...

Now I'm following along. Thanks for the clarification.

I do not see a ticket for the listener, but rather for the primary node. This doesn't really surprise me given that when...

I'm a quite confused about klist.exe tickets because when I run it, it returns all tickets assigned to my login - not the SQL Service account. I do see a...

I'm not a domain admin so I don't think I can do the klist that you are talking about. Would it be possible that the listener uses a different user...

The two differences that I can see are

1. The import built in SSIS uses the provider MSOLEDBSQL.1 while the import using the wizard uses MSOLEDBSQL. I don't think this is...

That part makes sense but what is still eluding me is that if I create the SSIS package from scratching using the OLE DB Driver then it still takes 20+...

I wanted to share a discovery I made regarding this subject. I used the import wizard to import a flat file into SQL using the Native Client and saved it...

My previous Google searches told me that the native client is deprecated and not recommended for use in new developments. I know that means it could function for many years...

I'm still having trouble following and maybe it's because I don't see how it will work for my situation. My setup is exactly like "Architectural Solution 2" in this article 

• This reply was modified 4 years, 4 months ago by  RonMexico.

The article you referenced is the one I followed to change the RegisterAllProvidersIP and HostRecordTTL settings. I'm a little confused what you mean by this part

Here, you have 1 name(listener) ...

• This reply was modified 4 years, 4 months ago by  RonMexico.

When I ping the DNS it will give a reply at first and then fail on the second attempt. I suspect that's because the first attempt returned the active IP...

That did the trick. I'll continue to monitor it to see if it gathers the data I'm looking for.