I would strongly encourage you to edit your post and take out the passwords you put in there... you should never post a password in plain text on any forum,...

When you say "brought into single user mode but no hope" what do you mean?  You got errors?

Now, like Jeff said, I am a bit curious about the licensing on...

• This reply was modified 3 years, 4 months ago by Mr. Brian Gale.

My opinion - his reasoning is garbage.  He should be testing the backups to ensure they are valid.   If you don't trust the backup when things are running fine, what...

So this is a problem because:

A - sa is disabled, so you cannot log in as sa.

B - local machine administrator account is not an admin

What I would suggest is...

My understanding, and a quick google confirmed what I thought, is that they are essentially the same thing.  A FULL backup is a backup of ALL data up until that...

I personally find that the wizards are hit and miss and I prefer to set things up myself where possible.  I've had the wizards say "everything is great" only to...

Quick google of that command, it is part of the SqlServer module.  My best guess is that your SqlServer module is out of date or corrupted in some form.  I...

To add to what Michael said, if you run that in SSMS without the debugger, is it taking 30 seconds to grab data from the fetch?

Also, are you SURE you...

To add to what Michael said though about ports - in practice, any port under 1024 (I think... been a while since I did networking stuff) is a "reserved port"...

You say you know this error very well, but sometimes it helps to go back to the basics and just double check the VERY basic configuration.

Have you come across this...

The problem is in the error message:

module 'pip' has no attribute 'get_installed_distributions'

quick google of that, that module/attribute was removed in Python.  Found this on SO:

https://stackoverflow.com/questions/49923671/are-there-any-function-replacement-for-pip-get-installed-distributions-in-pip

Solution - use supported methods for...

Since you are seeing problems from other VM's, I would suspect it is NOT the 2019 box but the 2017 box.  BUT you can't rule out that your Azure just...

My guess is that it is not a problem with on-prem, it is a problem with MFA.  Personally, I have never set up SSMS or ADS to work with MFA...

This feels almost like an undocumented "feature" (similar to quirky updates)... I know I would be a bit hesitant in how I used this and would probably continue to stick...

I am pretty sure the syntax is just "CREATE CERTIFICATE <certname> FROM FILE=<path to file>", and a quick google confirmed this for me:

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-certificate-transact-sql?view=sql-server-ver15

Mind you, you likely also want to include...