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
Post a Comment