Remote Connection to SQL Server 2012 Standard Edition port 1433 -


i have windows server 2008 r2 running sql server 2012 standard edition and:

  • allow remote connection server (in sql server management studio)

  • tcp/ip enable , configured ipserver , 1433 port (on sql server network condiguration -> protocol for...)

  • named pipes enable (on sql server network condiguration -> protocol for...)

  • shared memory enable (on sql server network condiguration -> protocol for...)

  • firewall off

when run telnet localhost 1433 on server - connect perfect. if run telnet ipsserver 1433 or telnet domainnameserver 1433 - not connect

something else netstat -a display:

0.0.0.0:1433   nameserver:0  listening [::]:1433      nameserver:0  listening 

any ideas?

you have firewall turned on, have create exception tcp/1433.

be aware if have multiple instances must create exception udp/1434 , check on port multiple instances binding.


Comments

Popular posts from this blog

html - How to style widget with post count different than without post count -

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

javascript - storing input from prompt in array and displaying the array -