I want to setup a single instance of sql-server as a mirror-backup for 2 production-servers, and I need to use certificate authentication because they are not part of an AD-domain.
Reading the documentation, it claims this:
All mirroring connections on a server instance use a single database mirroring endpoint, and you must specify the authentication method of the server instance when you create the endpoint. Therefore, you can use only one form of authentication per server instance for database mirroring.
does this mean that it's impossible to use one instance, to backup databases from two other instances?
Since I need to create certificates on all three machines (if I understand it correctly), and I use certificates per endpoint. Shouldn't I be able to create two endpoints on my backup-machine that uses different certificates?