Re: Remote Scripting and Firewall Ports
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 24 Jul 2007 22:41:38 +0000 (UTC)
Scott (Scott@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I need to configure my firewall to allow remote scripting on my SQL 2000
DB. Which udp and tcp ports do I need to open?
Would scripting being any different from running queries?
If SQL Server listens on port 1433, that is your guy.
How remote are these connections? From the Internet? Or just in the
local network? If you expose the server on the Internet, make sure
that you have a really strong password for sa and all other SQL logins for
that matter. And make absolutely sure that you are running at least SP3.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: Migrating the WSUS database from a Windows Internal Database instance to a SQL Server 2005 instance on a remote server
- Next by Date: Re: SQL 229 Error
- Previous by thread: Migrating the WSUS database from a Windows Internal Database instance to a SQL Server 2005 instance on a remote server
- Next by thread: Re: SQL 229 Error
- Index(es):
Relevant Pages
|
