What do the Error logs show in MSSQL?

There are so, so many possible reasons for the issue; you will need to be a lot more specific. First though, carefully check...

"Have you never been called outside of working hours?"  I'm really intrigued to know if anyone can answer yes to this question!

With the modern flexible working, working-from-home, etc, plus the...

New physical nodes installed with Windows Server 2019, and hooked up to FiberChannel & SAN shared storage; setup MSSQL 2019...

We are still running a "classic" WSFC with a two-node FCI, sitting atop a rock-solid SAN, all on-prem.

MSSQL Server 2019 running perfectly, without issues.

Yes we have the admin overhead of...

If you have no file-sharing options (i.e. no SMB) and no FTP, then one alternative is WinRM (Powershell Remoting).  Enabled by default on modern Windows Servers, but of course might...

Good to know the AAD group is working now 🙂

I read somewhere recently, that Azure SQL Database can be configured to only accept AAD authentication; all SQL Logins would be...

hmm, interesting! You have probably read this already, but to summarise from MS docs:

"Each server in Azure (which hosts SQL Database or Azure Synapse) starts with a single server administrator...

Have you created a SQL Contained Database User?

When connecting as a contained database user, the connection string must always contain a parameter for the user database (you are not allowed...

and yet:  "The SQL login works when I remote to the SQL host and log in locally"

So probably not locked out.

Hi there webrunner,

Thanks for posting lots of detail! Really helps, and I learnt something too whilst reading 🙂

Assuming you have already checked the various endpoint permissions, and given the SQL...

I tend to configure a SQL Login on Server B (rather than Windows Login).  The Linked Server on Server A is configured with this SQL Login (simple username and password)...

Suggest you try a different configuration in your Linked Server Properties: link both of your "Local Login" names to the same "Remote User", with the same "Remote Password" configured for...

As far as I know: you can host the two Reporting Services databases on SQL MI; but as you say, this doesn't get you the Reporting Services themselves!

SSRS needs to...

We have a tag for "environment" which we use to specify the workload; typically "prod", "dev" or "test". These tags are then used to apply varying policies, backup retention, LAW,...

Could also be picky and say that 52.6 rounds to 53 minutes, not 52 minutes (and still not taking into account the variance for leap years; I think it is...