SQL Configuration

Post Views: 4,648

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 :

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.

2 thoughts on “SQL Configuration”