Server error 1431 When setting up Database Mirroring Using Local System Accounts and Certificate authentication
I attempted to setup database mirroring using a High Availability scenario but when I installed SQL is chose to use local system accounts for all the services. Consequently, I stubled upon a microsoft article explaining how to setup mirroring using local system accounts and certificate authentication but I am stil not able to get it to work. When I try ti initiate the mirror from the mirror server I receive an error stating "Neither the partner nor the witness server instance for database "EDENLive" is available. Reissue the command when at least one of the instances becomes available." I have checked all the endpoints and everything seems to be in order. I even checked to make sure that each server was listening on the appropriate ports and I AM able to telnet to the ports. Please help!
Server error 1431 When setting up Database Mirroring Using Local System Accounts and Certificate authentication
YetAnotherLogin
Hi,
So, at one point, i believe you had mirroring setup, otherwise you wouldn't be getting the 1431 error. 1431 means that the mirror thinks it is in a mirroring session already (i.e. mirroring has been setup correctly previously), but currently, there is an error.
Now, I don't know what you were doing but right know your system (the mirror) is NOT able to communicate with its partner or witness to complete the command. Quorum is required to complete the command.
So, get the partner servers talking to each other again. If you have changed the system (network config, security settings, etc.) recently, change it back. Look in the errorlogs.
More info is needed if I am going to be able to help you. (repro steps, errorlogs, etc.)
Thanks,
Mark