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
Database


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

Comments

Submitted by Anonymous (not verified) on Wed, 19/10/2016 - 10:16
 

I am using the the sequelize ORM and MS SQL in Javascript.
I have done all the above given steps but still when I am trying to access the data, this is the error arising

{ [SequelizeConnectionRefusedError: Failed to connect to 127.0.0.1:1433 - connec
t ECONNREFUSED 127.0.0.1:1433]
name: 'SequelizeConnectionRefusedError',
message: 'Failed to connect to 127.0.0.1:1433 - connect ECONNREFUSED 127.0.0.1
:1433',
parent:
{ [ConnectionError: Failed to connect to 127.0.0.1:1433 - connect ECONNREFUSE
D 127.0.0.1:1433]
message: 'Failed to connect to 127.0.0.1:1433 - connect ECONNREFUSED 127.0.
0.1:1433',
code: 'ESOCKET' },
original:
{ [ConnectionError: Failed to connect to 127.0.0.1:1433 - connect ECONNREFUSE
D 127.0.0.1:1433]
message: 'Failed to connect to 127.0.0.1:1433 - connect ECONNREFUSED 127.0.
0.1:1433',
code: 'ESOCKET' } }

Add new comment

The content of this field is kept private and will not be shown publicly.
About text formats

Full HTML

  • Lines and paragraphs break automatically.
  • You can caption images (data-caption="Text"), but also videos, blockquotes, and so on.
  • Web page addresses and email addresses turn into links automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <bash>, <cpp>, <css>, <html5>, <java>, <javascript>, <php>, <sql>, <xml>. The supported tag styles are: <foo>, [foo].
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.