The world has now had time to recover and mitigate damage from the widespread WannaCry ransomware attack. We evaluated what it has left in its wake. Tallied damage includes:
More than 150 countries.
Currently $111,996.86 has been paid in bitcoin so far to decrypt files.
Around 16 of England’s National Health System organizations affected, with doctors resorting to pen and paper to complete patient records.
Renault, a European auto manufacturer, kept a French plant—that employs 3500 people—closed Monday, May 28th as a “preventative” measure.
SQL Server Management Studio : Windows Authentication from a non-domain-joined computer.
When trying to connect with an Windows integrated account to a domain-joined Microsoft SQL Server 2017 from a non-domain-joined computer or a computer joined to another non-trusted domain, you get a "login failed" on every connection attempts.
The solution (or workaround) is to use the Windows Credential Manager to pre-configure the domain user account to be trusted by SSMS with the following steps:
Open Credential Manager (type Credential Manager from the Start Menu)
Click "Add A Windows Credential"
Populate the network address field with the name and port number of the SQL instance you wish to store credentials. For example: MyMSSQLServer.domain.org:1433 (1433 is the default port, you may need a different port, especially if you are connecting to a named instance).
Populate the "User Name" including the domain name: "DOMAIN\Username"
Enter the "Password"
Done! Restart SSMS, try connecting to the remote SQL Server from your non-domain joined machine and this time your login should work!
Microsoft Data Protection Manager loses the disk (disk becomes RAW)
After New Installation and several days of backups, the DPM loses one of the disks with backed-up data. Disk becomes RAW, with all data lost. Configured hardware RAID-10, disks are 7200 rpm, 8TB capacity. What could be the issue?