• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 621
  • Last Modified:

Windows 2008 Server, SQL SERVER, firewall settings

I need my SQL SERVER 2008 to listen on 1433 port to all connections from any IP, so I need instructions on how to start the program to configure the firewall, and which rules should I set up, and which values should I assign...

Thanks
0
aguisa
Asked:
aguisa
1 Solution
 
dbaSQLCommented:
I'm not sure about the firewall settings, but you need only to enable TCP/IP after setup.  At that point, if it's not on 1433 (happened to me with my 1st v2008 installation), you can change it as detailed herein:

http://msdn.microsoft.com/en-us/library/ms177440.aspx
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now