SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 SQL Server Port 1443		  Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

filduarte
Starting Member

3 Posts
Posted - 03/27/2007 :  12:54:03  Show Profile
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...

Edited by - filduarte on 03/27/2007 12:55:05

tkizer
Almighty SQL Goddess

USA
35007 Posts
Posted - 03/27/2007 :  13:11:16  Show Profile  Visit tkizer's Homepage
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 Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

filduarte
Starting Member

3 Posts
Posted - 03/28/2007 :  09:12:53  Show Profile
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!
Go to Top of Page

harsh_athalye
Flowing Fount of Yak Knowledge

India
5509 Posts
Posted - 03/28/2007 :  09:22:56  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message
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
2. Port is required to make SQL Server available over the network. Nothing to do with working on databases if they are local.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35007 Posts
Posted - 03/28/2007 :  12:40:05  Show Profile  Visit tkizer's Homepage
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 Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

filduarte
Starting Member

3 Posts
Posted - 03/28/2007 :  13:00:33  Show Profile
"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?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35007 Posts
Posted - 03/28/2007 :  13:13:17  Show Profile  Visit tkizer's Homepage
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 Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000