Sql server remote connection

# Check right click sql server instance Properties>Connections Allow remote connection to this server .

# Open sql server configuration manager > SqlServer Network Configuration > Protocols For Sql Server  then enable TCP/IP and TCP/IP >Ip Address Tcp port must be 1433.

# Go to windows firewall >  Advanced Settings  > Inbounds Rules and add new rule  add tcp port 1433 then enable rule.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s