Try in a testing environment before using it in production, as long as you follow procedures, create it on Development\QA environment, leave it there for a couple of days and...

We have been using logon triggers to detect the users trying to connect to a database from a specific application and server in production for more than 10 years.

I don't...

There's a blog post made by Will Assaf regarding this issue.

take a look.

https://www.sqlservercentral.com/blogs/a-connection-timeout-has-occurred-on-a-previously-established-connection-to-availability-replica

Hello,

At the end of the article you posted from Microsoft he wrote to enable a trace flag to dig deeper into the issue, have you tried that?

If none of the...

It's ok,R no worries.

Lets remove the files

Alter database tempdb remove file temp3

Not the mdf and ldf but the ndfs.

Restart again and you should only have these two.

If you are locked...

Updating you guys.

Today we've registered SPNs to the listeners.

setspn -A MSSQLSvc/AGListener.domain.com domain\serviceaccount

setspn -A MSSQLSvc/AGListener.domain.com:1433 domain\serviceaccount   (or whatever port you used for the listener)

so far.. no timeouts or...

Thanks Sue!, we'll be taking a look and making some tests.

oh lord if its the SPNs im gonna hang myselffffff.

I found it on the SQL Server error log today, earlier dates don't have the message.

Thanks for the URL.

And... effectively, you have to register SPN for the Listener, i'll keep...

Now i got to see some error of after the whole past week searching and didn't find anything on the logs..

SSPI handshake failed with error code 0x80090304, state 14 while...

It's cool, you are trying to help and thats more than welcome!, also i know it's hard to help when you don't have the issue in your hands.

Actually, sql server...

Sure,

Most combinations work.

AD Account to Instance itself works fine

AD Account to Listener timesout or takes too long to connect, or connects.

SQL Account connecting to listener works fast and fine

SQL Account...

When you change between an AD account and a local SQL instance are you using the same Windows login on the same machine? I'm guessing you already checked but...

• This reply was modified 4 years, 10 months ago by  Alejandro Santana.

What kind of encryption were you using?

backup encryption by certificate?

is it a VLDB? if it isn't you could try seeding, i'll try to re-create your environment and see if i get the same error.

The database restored in the secondary...

• This reply was modified 4 years, 11 months ago by  Alejandro Santana. Reason: added 2nd paragraph