Hi Johan,

Sorry for my delayed reply. Thanks! I'll check it out.

-- webrunner

Hi Ant-Green,

Thanks so much for this info! I'll test it out.

Thanks again,

-- webrunner

Hello experts,

Following up on this post, I found something interesting.

In the environment mentioned above, one of the AGs hangs with the connection timeout error, but another one connects successfully.

Does anyone...

• This reply was modified 3 months, 2 weeks ago by  webrunner.

Thanks, Brian.

I'll double-check the firewall (B) possibility. I also think it has to be that.

-- webrunner

I'm a little late to the party due to the repost. But I look forward to reading more on this topic. We had a really terrible EAV implementation, so I...

Found the solution here http://www.batenict.nl/2020/04/03/token-based-server-access-validation-failed-with-an-infrastructure-error-login-lacks-connect-sql-permission/%5B/quote%5D

Hi, thanks for posting that link. As of today, however, it leads to a 404 page. Does anyone have an updated or similar...

Thanks for the interesting question, Steve!

Also to anyone who knows - I guessed it right just based on my experience of never having seen a variable there. But what is...

I can work with just one screen if needed, although it's pretty annoying to have to switch windows back and forth. But practically speaking, as long as I have a...

Thanks for this great fundamental question. I can't believe I got the SQL Server NULL sort order wrong! Time to review the basics.

-- webrunner

I'm ready for the structure of going back to the office more days per week. But I dislike open office plans, so I'm glad to be able to work in...

• This reply was modified 7 months, 1 week ago by  webrunner.

EDIT: Actually, this thread seems to arrive at your conclusion (Error 19406 being all you need) but I suggest reading through those other articles too anyway. HTH

https://www.sqlservercentral.com/forums/topic/alwayson-availability-failover-

Hi,

You can...

• This reply was modified 7 months, 3 weeks ago by  webrunner.
• This reply was modified 7 months, 3 weeks ago by  webrunner.

Hi, are you looking for something like this?

https://www.mssqltips.com/sqlservertip/2235/creating-backups-and-copies-of-your-sql-azure-databases/

HTH

-- webrunner

Thanks for this fascinating info and for the book rec!

-- webrunner

Nice one, Steve. Thanks.

-- webrunner

Same here. I thought there were two viable answers here.

-- webrunner