Category: Security
-
RSS feeds about Microsoft KB articles
Just a quick tip this time, but one that can save you lot of time and manual work. One of the information sources that all administrators, both Windows and SQL Server alike, should follow is the Microsoft Knowledge Base. However as there are new articles coming in daily, going to…
-
IPSEC settings for the client
After setting up the SQL Server ready for encrypted connections, it’s time to do the same for the clients. This is basically the same process that we already did at the server end, but let’s go through it once more. Instead of inbound firewall rule, we’ll create an outbound rule…
-
IPSEC settings for the SQL Server
To set up IPSEC for a box running SQL Server starts with a simple step, by turning on your Windows Firewall with Advanced Security, if it’s not on already (which it definitely should be!). After that you need to create two rules for your firewall. First the inbound rule, which…
-
Introduction to IPSEC with SQL Server.
Just a small update here. This topic has been for the last 6 years, every year, in top 5 of most read posts in my site. I guess security never goes out of style! A first post of 2014 and it sure took me awhile to write it up. I…
-
Using SSL with SQL Server
It has been couple weeks since my last post and as we’re going through the end of the year frenzy at the office, I find myself having little energy or time left after work to finish up my posts (I do have a couple of other posts waiting to be…
-
Securing SQL Server network traffic
A while back I had a request to encrypt communications between an instance of SQL Server and the clients connecting to it. I knew that SQL Server had the ability to use SSL to encrypt communications, so this all seemed simple enough to do. The easy way, however, didn’t work…