I did
netstat -an | find /i "listening"
I get ports:
80, 135, 445, 1025, 1026, 1056, 3389
but no 1433?
I followed all the steps of allowing for remote connections that I could find, what could be the reason?
steps i did: 1. created a user account, tested on server and I can login using the server name .\express (using the IP doesn't work??) 2. in the server properties, allowed for both windows and sql authentication 3. surface area config: set local & remote connections, using both tcp/ip and named pipes (not sure I need named pipes, but just to get it to work I did both) 4. restarted both the server and sql browser service 5. sql config manager: protocoals for SQLExpress: shared mem, named, tcp/ip work.
Should I be connecting using:
233.234.234.234\SQLEXpress
or
233.234.234.234\SQLEXpress, 1433
or
233.234.234.234, 1433
or
233.234.234.234
I opend up ports 1433 (TCP) and 1434 (UDP) on the firewall. Server doesn't have windows firewall running.