sql server 2008 database mirroring gotchas

One day if you try to configure sql server for mirroring without domain accounts you may come across with a few problems.such as this error message:

Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote

"alter failed for database" The server network address can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

The server network address "%.*ls" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

Error messages differs but the problem is sql servers principal and mirror should trust each other. On the net there are various resources how to configure this via certificates etc. but if you are in a hurry to test something quick

try this on your mirror:
run on master database

if not exists( select * from sys.syslogins where loginname = 'NT AUTHORITY\ANONYMOUS LOGON')
Begin
Create Login [NT AUTHORITY\ANONYMOUS LOGON] from windows
End

grant connect on endpoint::[Mirroring] to [NT AUTHORITY\ANONYMOUS LOGON]

where [mirrorring] should be your endpoint name... and you should run this on your master database of your mirror server..

I am assuming that if you see the above error messages you have already configured mirroring using wizards etc.

this will grant the permission needed not the most secure way though therefore keep that in mind.

Comments

Post a Comment

Popular posts from this blog

how can you enable a windows firewall rule for a dynamic dns name or dns address

in a windows server sometimes you just need to enable some ports on your firewall to your dynamic dns address.(such as RDP , FTP , etc..) It is cumbersome when you do this manually every time your ip address changes.Why not update your server automatically every time when your ip changes based on your new dynamic dns update ? 1 ) just create a powershell script like this: $ip = [System.Net.Dns]::GetHostAddresses(" your ddnss address ").IpAddressToString Set-NetFirewallRule -DisplayName " myrule " -RemoteAddress $ip Put in your ddns name like: xxx.dydns.org , no-ip etc.. Create a firewall rule and define ports etc. before hand and name it either "myrule" and use the second line as it is ,or change the "myrule" to your rule's display name on advanced firewall app on windows server. 2) name it as firewall.ps1 3) and than create a task on task scheduler like this: command to execute: powershell -executionpolicy remotesigned -File
Read more

Bose speaker hack (companion 5) to turn on/off automatically

Image
I have on of these Bose companion 5 speakers. The problem with it is when you don't use it actively it turns off to save energy, next time when you want to use it you should press the button on the control pod to activate it. This is a problem when you use the aux cable as input as a standalone speaker. Solution was not the easiest but it's a quick hack.  I designed a system where when an audio detected from the aux input , it Bose speakers turn on automatically to green. Here is how it goes: Tested the pins of the control pod, looks like there are different voltages supplied to the control pod. It all ends up here because I couldn't find how the audio transmitted to the main device.I had to find a way to open this: There were 2 screws at the back. It turns out it uses the same screws apple uses T5 When I opened it the top came off You need to unscrew these as well, and you have to cut the wheel, (you can glue it ba
Read more

how to IR remote control via wemos d1 (esp8266) & mqtt & sonoff tasmota

Image
I used wemos d1 and connected like this: (source: https://github.com/witnessmenow/ESP8266-IR-Remote-Example) Receiver module is tsop38238 Transistor :  2N3904 (without it , LED is not bright enough to send IR signal) Led diode is Infrared diode. I used this library with arduiono :  https://github.com/markszabo/IRremoteESP8266 From examples  with this one:  IRrecvDumpV2.ino you can capture IR codes from the remote by pressing the remote button and it will be captured  and it generates codes like this:
Read more