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
In this window ensure that SQL Server Services :
- SQL Server (MSSQLSERVER)
- SQL Server Browser
are running.
Then double click on SQL Server Network Configuration > Protocols for SQLEXPRESS
Click on TCP/IP (Enable it if it isn’t enabled)
Ensure that all IP addresses are enabled (IP1 to IP All) and enter port as 1433.
Now Open SQL Server Surface Area Configuration
Click on the Option highlighted in below picture :
Over here ensure that both TCP/IP and named pipes connections are enabled….
This is do the job for you.
