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