Tuesday, March 20, 2012

::Conection

Hi All,
I Have a SQL Server run in a computer that run Windows 2003 and have one
static ip.
This computer also have a NAT with basic firewall to distribute internet.
In my home I have one computer withWindows XP that I want acess SQL.
When I disable basic firewall, I can conect, but if firewall is on I can't.
My question: what port I need open to connect in my sql?
I know that I need use SQL account.
Thanks
Default installations of SQL Server monitor TCP port 1433, but the port
doesn't need to be 1433. A named instance of SQL Server 2000 will listen a
dynamic port by default. This port should be changed to a fixed port prior
to configuring the firewall. You can refer to this article for more
information:
287932 INF: TCP Ports Needed for Communication to SQL Server Through a
Firewall
http://support.microsoft.com/?id=287932
HTH!
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
sql

No comments:

Post a Comment