Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 how do I block access to my server's sqlserver?

Author  Topic 

sql777
Constraint Violating Yak Guru

314 Posts

Posted - 2006-02-11 : 10:35:12
Hi,

I have read that one should block access to a server if it has sqlserver running on it. How can I block the ports? I believe its port 1433?

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-02-11 : 11:13:25
You do that on the firewall.
Port 1433 is the standard port for sql server, you can check the port in the SQL Server Network Utility, under TCP/IP properties.

In what environment is your sql-server running?
At home?, on a LAN?, fronting the internet?

www.sqlsecurity.com has some good information on security.

rockmoose
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-02-11 : 12:28:50
You might like to move SQL server to a different port number - particularly a much higher number. Most of the port scanners are only looking for 1433, and a few are just looking for low numbered ports ....

Not a replacement for a proper security policy, but it can help deter the casual hack/virus/etc.

Kristen
Go to Top of Page
   

- Advertisement -