Do you mean the cert is not on the system you are trying to restore...

Did you try this using the GUI or T-SQL on the second node?

Sounds like there could be an application hitting the only open connection before you are able to try and connect. What happens if you try this:

- Script out...

I have not heard that but I would be very interested in that as well. I would imagine that any DBA that works for any federal government would have similar...

Are you in master when trying to backup your TDE cert? The cert protecting the DEKs in TDE live in master, this is the only option and by design, so...

Are you using compression on the backup?

If the user on the partially contained database is a "SQL user mapped to a login" or a "Windows User", they both are still created mapped to a login. That...

It should be the report server web service URL that you connect to (ex: http://dwh:80/reportserver). In order to use that you need to confirm the following:

- The...

You can certainly apply permissions to a custom set of AD users to a report or folder, but as far as I know you cannot create a custom group within...

This is supported, as long as the nodes have the resources to host the databases/log files.

Well, Snowden wasn't DoD, but yeah, several layers of encryption are usually looked at if feasible. That is the main concept by Defense-in--Depth I believe.

There was a Microsoft webinar about SQL Server on Linux a couple weeks back. One of the things they mentioned when porting SQL Server over to Linux was the need...

Have you taken a look at the DoD's guidelines for securing SQL Server? It covers many facets of he

Application Security - Database A To Z

Can you check that gratuitous ARP packets are allowed on the networking devices hosting your VLAN? I have an issue in my workplace that gratuitous ARP is blocked on the...