Re: WinXP Firewall and Sql Server
From: Neil Pike (neilpike_at_compuserve.com)
Date: 08/11/03
- Next message: Dejan Sarka: "Re: Best Practices"
- Previous message: rakesh: "Best Practices"
- In reply to: Larry Stall: "WinXP Firewall and Sql Server"
- Next in thread: Larry Stall: "Re: WinXP Firewall and Sql Server"
- Reply: Larry Stall: "Re: WinXP Firewall and Sql Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 11 Aug 2003 19:26:01 +0100
Larry - the protocols/ports used by the enumeration are exactly the ones you
DON'T want to open when connected to the internet.
Why not just type in the name of the SQL Server you want to connect to?
> When I enable the "firewall" on the single LAN connection
> on my WinXP Pro development station, I no longer can
> enumerate SQL Servers in the ODBC administrator or
> VStudio/VS.NET connection dialog. If I disable it, SQL
> Server is now enumerated and works fine, but I get these
> darn hacker pop-up scam windows (they start the spam and
> then try to sell you some bogus software to stop it).
>
> Are there any specific settings in the firewall config
> (ports?) that need to be added to make it work with SQL
> Server. Note: this machine is used primarily for off-site
> development (debug), is running a Personal Edition of
> MSSQL, and is usually running stand-alone (not logged to
> a domain), but connected to the internet.
>
> Thanks!
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
- Next message: Dejan Sarka: "Re: Best Practices"
- Previous message: rakesh: "Best Practices"
- In reply to: Larry Stall: "WinXP Firewall and Sql Server"
- Next in thread: Larry Stall: "Re: WinXP Firewall and Sql Server"
- Reply: Larry Stall: "Re: WinXP Firewall and Sql Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
