I am working on a new Access Control System and as per manufacturer recommendations, I am supposed to choose "Windows Authentication Mode" when installing the SQL server on to a remote machine.
That sounds like the best option in terms of security. But what happens if the machine dies and all I am left with is a backup of that database? How am I supposed to recover the data from that database if the only way to authenticate is by using the original Windows credentials/token?