It says "physical structure" in the question - at least it does now, not sure if it was edited.

Thank you! I'll check that link.

-- webrunner

Hello,

Not sure if these links can address your issue, but I found a couple of them useful while troubleshooting some email issues I ran into.

http://www.midnightdba.com/DBARant/complete-troubleshooting-guide-for-sql-server-databasemail-dbmail/

https://www.sqlshack.com/troubleshooting-database-mail-failures/

https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/check-the-status-of-e-mail-messages-sent-with-database-mail?view=sql-server-ver15

https://stackoverflow.com/questions/14649685/check-if-sp-send-dbmail-was-successful/14652916

For this last link, this answer...

• This reply was modified 5 years ago by webrunner.

Hello,

You could try some of the ideas mentioned here:

https://stackoverflow.com/questions/11866079/changing-properties-of-a-linked-server-in-sql-server

HTH.

-- webrunner

I know this is an old post, but figured I should add another approach that I found and will at least test out and may implement in production.

https://rcmtech.wordpress.com/2015/12/04/send-windows-event-logs-to-sql-database/

HTH

-- webrunner

Hello,

I would also suggest the following book, which gives a combination of technical and professional advice that I have found extremely helpful. Don't get me wrong - I am very...

Jeff,

I just love that quote. "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"  

It...

Thank you, Jeffrey, for your speedy and helpful answer!

-- webrunner

Many thanks for your responses.

I marked Frederico's response as the answer because it resolved the timeout issue. But thanks to both of you for your advice.

-- webrunner

Thanks Stephan,

The error I saw turned out to be due to a communication issue between the SQL Server and the domain controller. So it wasn't really a SQL issue. But...

Thanks both!!

-- webrunner

Thanks again, Jeffrey, much appreciate your additional advice.

Sorry for any confusion regaridng the secondaries. I don't think any of our secondaries are set to read-intent. They all look like they're...

Thanks again, Jeffrey,

You make excellent points. I tried asking the client about the connection string, but they use an application, so all I could get was the general info about...

Follow-up:

"If connecting to the listener - do you have a secondary in that AG set to read-intent?"

All of the secondaries I checked have these settings:

Connections in primary role: Allow all...

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

Thank you, Jeffrey!

Yes, the client reported this error using the listener name. I will investigate the read-intent setting as you advised.

Thanks again,

webrunner