Enabling remote access for user "sa" in SQL Server Express 2008 R2

Submitted by Jochus on Sun, 01/09/2013 - 18:28 | Posted in: Database
Posted in

TCP configuration

  • Launch: SQL Server Configuration Manager
  • Expand: SQL Server Network Configuration
  • Double click: TCP/IP
  • Change Enabled to Yes
  • Switch to tab: IP Addresses
  • Clear out TCP Dynamic Ports
  • Fill in the port on which you want to accept remote access calls. E.g.: TCP Port: 1433

"sa" user configuration

  • Launch: SQL Server Server Management Studio
  • Login by using Windows Authentication
  • Right click on your server and choose Properties
  • Select tab Security
  • Set Server Authentication to SQL Server and Windows Authentication mode
  • Save configuration
  • In the left tree, expand Security > Logins
  • Double click on the sa user
  • Uncheck: Enforce password policy and Enforce password expiration
  • Assign a password for the sa user
  • Open tab Status and put Login to Enabled

Asian characters accidently showing up in Word, Outlook, ...

Submitted by Jochus on Sun, 02/06/2013 - 21:44 | Posted in: Windows
Posted in

I sometimes accidently press a key combination in Word or Outlook which suddenly activates some Asian keyboard. I'm unable to type any other Western character.

The problem was related to me: when you press Alt + Shift, the Asian keyboard is activated. By pressing this key combination again, the Western keyboard is reactivated.

Copy/paste fails in CoRD when multiple remote desktop sessions are active

Submitted by Jochus on Thu, 16/05/2013 - 21:40 | Posted in: Mac
Posted in

I often ran into an issue with CoRD failing to copy/paste between my host machine and my remote desktop machine. This only occured when multiple remote desktop session were active. The clipboard chain gets broken and copy/paste between the host machine and the remote desktop stops working.

To solve this, you need to execute the following batch file on the remote machine:

@echo off
taskkill /IM rdpclip.exe /F
start %SystemRoot%\system32\rdpclip.exe