Re: SQL Port Restriction

Thanks alot for the reply!! I've realized that what I am trying to do will
require some sort of firewall. I was hoping to do port filtering on the
network adapter of the web server. Sensibly though, while SQL listens on
1433, the comunications back to the client are randomized ports.

Thanks for the help though!!!


"Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:ete3Bg%23eFHA.3032@xxxxxxxxxxxxxxxxxxxxxxx
> Normally its: SQL/Server (1433), SQL-Monitor (1434)
>
> But as you can configure that as you want with the Server Network config
> Tool, located in the Program folder of SQL Server it can depend on your
> manual settings.
>
>
> HTH, Jens Suessmeyer.
>
> "Wade Rocco" <wade_rocco@xxxxxxxxxxx> schrieb im Newsbeitrag
> news:%23e90IK%23eFHA.688@xxxxxxxxxxxxxxxxxxxxxxx
>> Hello All,
>>
>> Which ports are necessary for SQL communication?? I have a test
>> environment with a web server and a separate db server and I want to shut
>> down any unnecessary ports on the web/SQL server.
>>
>> Any advice is appreciated.
>>
>> Thanks!!
>>
>> Wade
>>
>
>


.

Relevant Pages

  • Re: SQL Server
    ... >> SQL Service manager shows that \\LAPTOP\PALSOFT - MSSQLServer is running. ... Antivirus is Sophos ... > allows you to check connectivity to ports. ... And it looks like you can in fact get the server manger status ...
    (uk.rec.motorcycles)
  • hack using xp_cmdshell
    ... Server, with sp4 and all security updates. ... ProgramName - SQL Exec for NetHakcerIII. ... With all ports closed it runs ...
    (microsoft.public.sqlserver.server)
  • Re: Whats a decent modem/router for tech savy user?
    ... It is not possible to route or deny traffic to specific ports based on the source IP address. ... But it wont route back inside the LAN - needs internal DNS server spoofing. ... Normally, this option should be Enabled, so that an Internet connection will be made automatically, whenever Internet-bound traffic is detected. ... Specifying a Default DMZ Server allows you to set up a computer or server that is available to anyone on the Internet for services that you haven't defined. ...
    (uk.telecom.broadband)
  • Re: Cannot connect to RWW from home PC
    ... That would be the address you need a DNS record for. ... You say "And in the router you need to forward to your external nic IP" ... Still can't telnet to any of your ports at your public ip address. ... Heres' the info for our server: ...
    (microsoft.public.windows.server.sbs)
  • Re: Netopia 3347NWG with Remote Desktop and Remote Web Workplace
    ... Glad you're back in business Greg! ... Ports Closed ... Despite this, Remote Web Workplace DOES WORK now, and Connect to Server ... Exchange BPA updates), ...
    (microsoft.public.windows.server.sbs)
Loading