<< Troubleshooting SQL Server Quirks | Home | How Not To Outgrow Your DB Infra: A Simple Setup >>

Understanding SQL Server Security and What You Can Do

Here are a couple of good reads. I will add to the list as I find something interesting. Don't hesitate to add your own via comments. The links are ordered according to my impression, first link being the best read.

1. I don't read blogs or articles that often, my skills are basically from experience and troubleshooting, so believe me when I say that this link is a must read.

http://www.windowsecurity.com/articles/Secure_SQL_Server.html 

2. Ever wonder which ports you can and should not restrict? Wonder no more

 http://www.microsoft.com/smallbusiness/support/articles/ref_net_ports_ms_prod.mspx 

3. How about that new service in 2005? De-mystifying SQLBrowser

http://msdn2.microsoft.com/en-us/library/ms181087.aspx

4. How to make unwanted access to SQL Server 2005 by an OS admin more difficult.

 http://support.microsoft.com/kb/932881

 

Print | posted on Thursday, November 22, 2007 6:04 PM

Feedback

# re: Understanding SQL Server Security and What You Can Do

Left by Justin at 12/21/2007 3:13 PM
Take a look at this eweek article. They describe a new tool for managing sql server permissions. I think it's a pretty solid way of securing sql server. With viewing the sum of permissions and easy permissions assigning you can keep security on the necessary level.

# re: Understanding SQL Server Security and What You Can Do

Left by Justin at 12/21/2007 3:13 PM
Take a look at this eweek article. They describe a new tool for managing sql server permissions. I think it's a pretty solid way of securing sql server. With viewing the sum of permissions and easy permissions assigning you can keep security on the necessary level.

Your comment:





 
Please add 4 and 4 and type the answer here:

Copyright © Jen

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski