Looks like this thread has taken a few turns from the title :).  I agree - I remember something about that in the past when reading about this.  On this...

Here's what I've got in AD (image attached).  Left side is the service account, right side is the SQL Server.

Entries on the left are the SQL servers that use this...

I believe so. I’m using the same service account as the old server. I’ve used the PowerShell dbatools module to migrate the database, logins, agent jobs and lined servers.

I’ve registered...

Technically, the access database is located on an SMB share on our internal network.

If I am logged on to the new SQL server via RDP or VM console, I can...

• This reply was modified 1 year ago by  stephenmbell.

Thanks for this response.  I'm only looking at it because it opens fine on my older server and not on the new one I am building.

I also have a linked...

Thanks for the reply @william.  I've got that installed already.

S

I must really be crossing some wires here.  I created an SPN for CIFS:

setspn -A CIFS/fileserverver svc_sql
setspn -A CIFS/fileserverver.domain.local svc_sql

Restarted the SQL Service on my sql server. ...

Ok so now I've got the SPN setup:

I've got the delegation setup:

I've got the permissions set on the Temp folder for the SVC_SQL user:

@frederico_fonseca - Thank you for the reply.

I've done a bit of reading on the Kerberos constrained delegation / SPN.  And I have seen the access to the temp...

UPDATE -

I rolled the new server into production - and had the same issue for 2 days. After some searching and reading blog posts - I found the...

Thank you for the responses. After looking through the event log, I see that the SQL service had been dying long before I moved this server into production. ...

I hadn't cleared the cache first, but I just did by running:

checkpoint;

go

dbcc dropcleanbuffers;

go

Then ran the query again. Completed in 5:25.

I did not update statistics, I will do this...

Here is some data - modified to protect the innocent.

INSERT [dbo].[MyTable] ([Candidate First Name], [Candidate Middle Name], [Candidate Last Name], [Candidate Name Prefix],

[Candidate Name Suffix], [Candidate Email], [Candidate Address...

My apologies:

Here is the table that I have created, and I have populated with data--

CREATE TABLE [dbo].[MyTable](

[Candidate First Name] [nvarchar](50) NULL,

[Candidate Middle Name] [nvarchar](25) NULL,

[Candidate Last Name] [nvarchar](50) NULL,

[Candidate...

Thanks for the reply.

I will give this a shot in my development environment and see how it works out.

As far as duplicate criteria - yes amount should be...