Use the following query on the database of the user.
Alter User [UserName] with login = [loginname]
Month: June 2019
Cannot connect to SQL server using SQL server authentication
The server may have been configured for integrated security only.
Change it to allow both SQL authentication and Windows Authentication by logging in using Windows user, then right click the server => Properties => Security, then change authentication mode to allow SQL authentication.
Then restart SQL server services.
Source: https://dba.stackexchange.com/questions/87390/sql-server-authentication-login-failed
Web Service Host for WCF doesn’t work
If you open a WCF Solution that uses a web site to host the WCF services and the services cannot be browsed when opening using a web browser (showing HTTP error 403.1 not found), try turning on HTTP Activation feature.
On Windows server, go through server manager.
On Windows desktop, search for turn Windows features on or off, Under .NET Framework Advanced Services -> WCF Services -> HTTP Activation. Check HTTP Activation to enable it, and click OK.
This really wasn’t apparent at first and I thought there was some issues with the config files.
Unity game shows purple screen on older Android device, “your device doesn’t meet minimum requirements…”
Go to Build Settings -> Player Settings -> Other settings -> Rendering.
Set Auto Graphics API to true. On some older devices there wouldn’t be Vulkan API and the game wouldn’t work.
Android Device not showing in Chrome Developer Tools under remote devices
If it doesn’t show, it’s possible that it’s because the adb daemon is not running to detect plugged in devices or emulators.
Run adb devices in a terminal to start the daemon if not running already.
Make sure USB debugging is enabled in the device.
Make sure the Android USB driver for the device is installed in the computer.
Cannot find Certificate when configuring IIS bindings
When configuring bindings, IIS list certificates in the personal store.
So when generating a certificate using Powershell or Openssl, make sure the cert is in the Personal store. Then it will show up when configuring SSL bindings in IIS manager.
In order for the browsers to trust the cert, install self-signed certs to the trusted root CA store. But don’t remove it from Personal store, because it’s needed for bindings.
New-SelfSignedCertificateEx , adding basic constraints to certificate for Android
Add the following parameter to the command. Remember to replace the double quotes.
TextExtension=(“2.5.29.19={text}CA:True”)
Outlook 365 says need password but the login window flashes after password change
Was able to fix this today by
-Open Microsoft Word
-On top where the user name is displayed, sign out
-Sign in again with the new password.
-Open Outlook again. Somehow it works.
Hostname resolves to old IP address
If the IP address has been changed and other clients keep using the old IP address, run “ipconfig /flushdns” to update the IP address in the client (For Windows only).
Cannot find or connect to SQL instance showing when connecting to SQL server from SSMS
Checklist
-SQL Browser service is running on the DB server, this one listens to UDP broadcast to tell clients of its presence.
-UDP 1434 is allowed in the firewall of the server(inbound rule), this is so that UDP broadcasts from clients can reach server.
-TCP 1433 and 1434 are allowed in the firewall(inbound rule), this is so that SSMS can connect to SQL server instance.
-TCP and UDP protocols are enabled in SQL Configuration Manager.
-The SQL instance allows remote connections, check this by opening SSMS inside the server, connect to local instance, right click, choose Properties and check the option to allow remote connections.
-There is no IP conflict in the network with another server (if using Virtual machines, check that MAC addresses are different to have different IPs, otherwise SSMS may try to connect to wrong server).