SQL Configuration

Use these settings to connect to your SQL database remotely in a same local network.

Click start > Microsoft SQL Server 2005 (2008 or 2012…) > Configuration tools >SQL Server Configuration Manager 

sql 1

In this window ensure that SQL Server Services :

  • SQL Server (MSSQLSERVER)
  • SQL Server Browser 

are running.

sql 4

Then double click on SQL Server Network Configuration > Protocols for SQLEXPRESS 

SQL

Click on TCP/IP (Enable it if it isn’t enabled)

sql 8

 

sql 9

Ensure that all IP addresses are enabled (IP1 to IP All) and enter port as 1433.

Now Open SQL Server Surface Area Configuration 

sql 2

 

Click on the Option highlighted in below picture :

 

sql 10

 

Over here ensure that both TCP/IP and named pipes connections are enabled….

sql 11

This is do the job for you.

sql 15

  • Pingback: Connect Android to MS SQL Database. • ParallelCodes()

  • Pingback: Connect Android to MS SQL Database. • ParallelCodes()

  • haresh

    hi E/ERRO: Network error IOException: failed to connect to /192.168.1.100 (port 1433): connect failed: ECONNREFUSED (Connection refused) how to clear the error

  • CC

    i’m using MS SQL SERVER Management Studio 2016, and i failed to find “SQL Server Surface Area Configuration ” . Thus i am unable to ensure that both TCP/IP and named pipes connections are enabled….

    Thanks in advance !

    • Click on :
      “sql server configuration manager”
      Click on the Protocols for SQLEXPRESS (your might be different).
      In that IP options is there, enable all