don't mess with your users

If you get an error related to your user after restoring , mirroring db. etc.


Run this:

sp_change_users_login 'auto_fix', N'XXXXXX'

where XXXXXX= your username,


run this under the DB which that user belongs.

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