Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
richard82
Starting Member
1 Post |
 Posted - 2010-08-24 : 12:25:11
|
| I have installed MSSQL 2008 R2 on a server running windows server web edition. It all installs ok but I cannot connect remotely. I have enabled remote connections and checked/double checked the firewall and all is correct.When I do a netstat -an I notice that SQL server is bound to 0.0.0.0:1433 but is not bound to the external IP of my server. Is it a limitation on windows web server that you cannot connect to SQL remotely? I have set up many instances in the past but never tried connecting remotely to them.The reason I need to connect remotely is to upload the data directly, once that is done all i will use is internal connections.Thanks for your help |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-24 : 15:10:28
|
| what error message are u getting?change the port at the very least if you're exposing it to the internet.then create an alias in sql configuration manager.make sure firewall is allowing traffic over that port. |
 |
|
|
|
|
|
SQL server on windows web edition