Thanks all. I will be trying this in next dat or two.  I will keep everyone posted

I am running from command line. I did try opening a second window, but my attempt at connecting SQLCMD was blocked because 'only one administrator can connect in single user...

When I attempt to start in single user mode (-m), immediately I start getting dozens (ultimately hundreds) of login fails like this one right after another. My single user connection...

No. What appears to be the case (I am not located on that site) is that the machines maintain a continuous connection (They are always looking for new instructions, even...

I had to wait till this morning to try the solutions.

1. I'm working from the command line, not using SSMS
2. I tied again this morning attempting to connect to sqlcmd...

• This reply was modified 5 years ago by  jay-h.

"one for the office, one for the home, and one for the vehicle."

Seems like a security risk even if the paper docs don't actually contain passwords (still need a place...

Duh. She was using SMSS 2012. I should have thought of that first, though we were working by email and I wasn't looking directly at her screen.

Following your instruction, I executed from within the database and from within master using EXECUTE AS LOGIN. Both were successful.

To clarify

Yes I have confirmed the user is in the Public role

When attempting to connect to one of the datareader databases, she gets The database xxxxx is not accessible (Object...

I was at first thinking of this as analogous to a truck driver who gets into an accident. Even a careful driver can wind up having an accident, and it's...

• This reply was modified 5 years, 4 months ago by  jay-h.

"anti-malware scanning product can also identify phishing emails"

This is already being done. There are things a system would spot, and there are things that a human would spot. The two...

The IEEE article makes a lot of sense.

Particularly the need for recoverable 'graceful failure.' I remember reading that traffic signal controllers have a separate supervisor system independent of the normal...

• This reply was modified 5 years, 8 months ago by  jay-h.
• This reply was modified 5 years, 8 months ago by  jay-h.

"I rejoice in the tremendous amount of data in the world "

I'm kind of spooked by the term rejoice.  Massive amounts of data has become a drug, and any problems...

The consent rule is also problematic. If you're travelling and become sick or injured, perhaps unconscious, how would that data be accessed quickly enough?

True their customer service lackey did not seem to understand. In truth I bet this is FAR more common than the cases exposed. Discovery is likely close to impossible in...

• This reply was modified 5 years, 8 months ago by  jay-h.