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 |
|
filduarte
Starting Member
3 Posts |
 Posted - 2007-03-27 : 12:54:03
|
| Hi, this is my first post on this forum... :) can anyone tell me, how can i open this port so i can work from a remote connection... (SQL Server Port 1443) thanks all... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-27 : 13:11:16
|
| When you say open the port, do you mean in the firewall? If so, you'll need to talk to your firewall admins as that's outside of SQL Server.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
filduarte
Starting Member
3 Posts |
Posted - 2007-03-28 : 09:12:53
|
| Ok... now i've got a new doubt.what is the relationship between Port 1443 and SQL Server?Does SQL have some ports that need to be open to work on some databases??Thanks! |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-28 : 09:22:56
|
| 1. Port 1443 is the default port used by SQL Server but you can change it to some another port number at the time of installation2. Port is required to make SQL Server available over the network. Nothing to do with working on databases if they are local.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-28 : 12:40:05
|
| Well port 1433 is the default port not 1443. For externally accessed databases, you should change the port to a 5 digit port and never post it on the Internet.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
filduarte
Starting Member
3 Posts |
Posted - 2007-03-28 : 13:00:33
|
| "1. Port 1443 is the default port used by SQL Server but you can change it to some another port number at the time of installation"ok, thanks :-) but how can i change the port number now?? and where in the software i see that port? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-28 : 13:13:17
|
| For SQL Server 2000, you can change it in the Server Network Utility tool.For SQL Server 2005, you can change it in the SQL Server Configuration Manager tool.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
SQL Server Port 1443