Viewing 15 posts - 106 through 120 (of 1,187 total)
It says "physical structure" in the question - at least it does now, not sure if it was edited.
October 20, 2020 at 3:55 pm
Thank you! I'll check that link.
-- webrunner
October 5, 2020 at 1:40 pm
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.
https://www.sqlshack.com/troubleshooting-database-mail-failures/
https://stackoverflow.com/questions/14649685/check-if-sp-send-dbmail-was-successful/14652916
For this last link, this answer...
October 1, 2020 at 1:41 pm
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
September 29, 2020 at 4:24 pm
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
September 25, 2020 at 6:20 pm
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...
September 21, 2020 at 4:21 pm
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...
September 2, 2020 at 2:46 pm
Thank you, Jeffrey, for your speedy and helpful answer!
-- webrunner
August 28, 2020 at 4:39 pm
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
August 28, 2020 at 3:18 pm
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...
July 6, 2020 at 3:11 pm
Thanks both!!
-- webrunner
June 29, 2020 at 9:02 pm
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...
June 23, 2020 at 4:44 pm
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...
June 23, 2020 at 3:40 pm
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...
June 22, 2020 at 9:01 pm
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
June 22, 2020 at 6:47 pm
Viewing 15 posts - 106 through 120 (of 1,187 total)