this new sql server 2014 express installation. application using sql server, installed on server works, no problem connecting. when client pc (on lan) tries use application, "canned" sql server message says "server not exist or connection denied". think sql server not listening on port 1433 can't figure out why not. here tried:
- server connection property has box "allow remove connections computer checked"
- sql server browser running.
- sql server configuration manager -> client protocols -> tcp/ip: port 1433 enabled. (this 1 looks different sql server 2008 though in sql server 2008 there ports, ip1, ip2, , 1 port 1433 set active)
- sql server management studio set use window , sql server authentication.
- when run netstat -a on server, not see line (which think should) this: tcp ###.##.##.###:1433 established.
so concerned 5 above not showing looking for. else can try?
make sure option remote connections enabled. right-click on server, choose properties, connections dcheck box allow remote connctions.
equally important!
make sure firewall allows traffic through chosen port. also, make sure have rules defined in windows firewall or turn off windows firewall altogether.
Comments
Post a Comment