http://www.sqlservercentral.com/Articles tagged Security, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications. http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/2008/07/25http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data. http://www.sqlservercentral.com/articles/Security/freeencryption/1980/2008/04/25http://www.sqlservercentral.com/articles/Security/freeencryption/1980/SQL injection has been a hot topic the last couple years and there are some great articles at SQLServerCentral.com on this topic. Michael Coles brings us an updated look at this SQL Server security issue with some new examples you might not have previously thought. http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/2008/03/21http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/The SQL Server 2000 security model is not the best one of all the RDBMS platforms and requires some work to secure properly. One of the practices that is recommended is removing the builtin/administrators group from accessing the SQL Server. New author Kathi Kellenberger shows us some of the pitfalls she encountered when removing this group from her servers. http://www.sqlservercentral.com/articles/Security/removingthebuiltinadministratorssomepitfallstoavoi/1661/2007/08/10http://www.sqlservercentral.com/articles/Security/removingthebuiltinadministratorssomepitfallstoavoi/1661/Part 3 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. This article looks at logins and basic security. http://www.sqlservercentral.com/articles/Administering/beginningsqlserverloginsandusers/1460/2007/08/03http://www.sqlservercentral.com/articles/Administering/beginningsqlserverloginsandusers/1460/Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications. http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/2008/07/25http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/SQL Server 2005 builds some great encryption tools into the product, but what if you are stuck with SQL Server 2000? SQL Server expert Michael Coles brings us the first part of a series along with a free toolkit to manage encryption and keys. http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/2007/06/22http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/Our SQL Server Security expert, Brian Kelley, brings us the first part of a new series on auditing. Most of the auditing articles we've had are based on how you audit changes to data. Brian looks at auditing from the server itself, explaining the different levels of auditing built into SQL Server 2000. http://www.sqlservercentral.com/articles/Security/sqlserverauditingpart1/1451/2007/06/01http://www.sqlservercentral.com/articles/Security/sqlserverauditingpart1/1451/SQL Server includes a great auditing tool: Profiler. It's not the easiest tool to use, however, and it's one that takes some getting used to. Our resident security export, Brian Kelley looks at a simple example of using this tool to audit logins. http://www.sqlservercentral.com/articles/Administering/auditingwithsqlprofiler/1461/2007/04/20http://www.sqlservercentral.com/articles/Administering/auditingwithsqlprofiler/1461/In this presentation at the Jacksonville SQL Server Users Group, Bayer White playS the part of a developer protecting his application and Brian Knight attempts to hack his application using SQL Injection and cross-site scripting. Then, Bayer will show you how to protect yourself from the hacker and then Brian tries again. Back and forth the chess match goes until someone wins! http://www.sqlservercentral.com/redirect/articles/2852/2007/02/12http://www.sqlservercentral.com/redirect/articles/2852/Brian is back with a new security article, this time working through the details of the fixed database roles. There are some important concepts here. In particular if you're not totally clear on the difference between dbo and db_owner, read this article. http://www.sqlservercentral.com/articles/Security/sqlserversecurityfixeddatabaseroles/1231/2007/01/19http://www.sqlservercentral.com/articles/Security/sqlserversecurityfixeddatabaseroles/1231/SQL injection has been a hot topic the last couple years and there are some great articles at SQLServerCentral.com on this topic. Michael Coles brings us an updated look at this SQL Server security issue with some new examples you might not have previously thought. http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/2008/03/21http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment. http://www.sqlservercentral.com/articles/Administering/implementing_efs/870/2006/12/01http://www.sqlservercentral.com/articles/Administering/implementing_efs/870/Arthur Fuller advises DBAs to try to break their software in order to make sure their SQL Server databases can withstand potential attacks. See if your code can hold up to his suggested tests.http://www.sqlservercentral.com/redirect/articles/2620/2006/10/12http://www.sqlservercentral.com/redirect/articles/2620/Security in SQL Server is not too complex, following a fairly simple framework for allowing and preventing access to data. However there are a few places where it can get tricky and some concepts that many people do not understand. Rob Farley brings us an explanation of one of those areas: ownership chaining. Read about how ownership chaining can be useful and also how it may open security holes in your environment. http://www.sqlservercentral.com/articles/Security/2633/2006/10/03http://www.sqlservercentral.com/articles/Security/2633/One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer. http://www.sqlservercentral.com/articles/Security/encryptfunction/372/2006/05/29http://www.sqlservercentral.com/articles/Security/encryptfunction/372/If you're performing a penetration test or higher-level security audit of your SQL Server systems, there's one test you must not miss. It seems obvious, but many people overlook it: SQL Server password testing. Given the inherent weaknesses compared with more secure Windows authentication, you should especially test for password flaws if you're using SQL Server authentication in mixed mode. Password testing will help you determine how easily others can break into your database and help you ensure SQL Server users are being responsible with their accounts.http://www.sqlservercentral.com/redirect/articles/2410/2006/05/16http://www.sqlservercentral.com/redirect/articles/2410/SQL Server 2005 builds some great encryption tools into the product, but what if you are stuck with SQL Server 2000? SQL Server expert Michael Coles brings us the first part of a series along with a free toolkit to manage encryption and keys. http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/2007/06/22http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data. http://www.sqlservercentral.com/articles/Security/freeencryption/1980/2008/04/25http://www.sqlservercentral.com/articles/Security/freeencryption/1980/Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes. http://www.sqlservercentral.com/articles/Service+Packs/sp3coresecurity/907/2005/12/09http://www.sqlservercentral.com/articles/Service+Packs/sp3coresecurity/907/In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable. http://www.sqlservercentral.com/articles/Administering/securitypart2/593/2005/11/04http://www.sqlservercentral.com/articles/Administering/securitypart2/593/The problems caused by the SQL Sapphire Worm, also know as the SQL Slammer, have caused many sites to do a quick upgrade to SQL Server 2000 Service Pack 3 (SP3). It includes the fix that prevents infection by the worm. While moving to the latest service pack is usually a good thing, to do so without thorough testing risks breaking a working application. That is exactly what happened to one of my clients over the weekend.http://www.sqlservercentral.com/redirect/articles/2131/2005/11/02http://www.sqlservercentral.com/redirect/articles/2131/Auditing, analyzing and documenting your SQL Server installation is becoming more important all the time, especially as more and more attention is being paid to the security of your environment. Chad Miller brings us a look at a framework and a sample document you can use in your environment to conduct an audit. http://www.sqlservercentral.com/articles/Administering/conductingasqlserveroperationalaudit/2079/2005/10/24http://www.sqlservercentral.com/articles/Administering/conductingasqlserveroperationalaudit/2079/Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique. http://www.sqlservercentral.com/articles/Administering/loginsusersandrolesgettingstarted/514/2005/09/30http://www.sqlservercentral.com/articles/Administering/loginsusersandrolesgettingstarted/514/SQL injection has been a hot topic the last couple years and there are some great articles at SQLServerCentral.com on this topic. Michael Coles brings us an updated look at this SQL Server security issue with some new examples you might not have previously thought. http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/2008/03/21http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/As a DBA you do not need to know how to setup an Active Directory domain or a DNS server, but you still need to know how Kerberos, Service Principle Names, and hostnames are used to perform integrated authentication to a SQL Server. This article by new columnist Chad Miller shows you some of the more integral parts of troubleshooting running Windows Authentication security in a SQL Server environmnet. http://www.sqlservercentral.com/articles/Installation/cannotgeneratesspicontext/929/2005/08/19http://www.sqlservercentral.com/articles/Installation/cannotgeneratesspicontext/929/Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data. http://www.sqlservercentral.com/articles/Security/freeencryption/1980/2008/04/25http://www.sqlservercentral.com/articles/Security/freeencryption/1980/Securing your SQL Server can be an arduous task, but very rewarding. This article covers 10 steps to properly protecting your data. http://www.sqlservercentral.com/articles/Security/10securingyoursqlserver/701/2005/05/27http://www.sqlservercentral.com/articles/Security/10securingyoursqlserver/701/We have described, so far, authorization based on a predefined fixed server (determining a set of SQL server-wide privileges) and database (applying to database objects and activities) roles. We have also discussed application roles, which makes the level of permissions independent of those assigned to a SQL Server login or a database user account. Now it is time to look into permissions from the point of view of database objects. There are two main factors that play a role in determining how access rights to them are evaluated - their ownership and custom permissions. We will discuss the first one of these topics in this article and will continue with the other one in the next installment of this series. http://www.sqlservercentral.com/redirect/articles/1789/2005/03/22http://www.sqlservercentral.com/redirect/articles/1789/SQL Server does many things very well, but securing itself is not one of them. While securing your server requires some effort, there is an area that many people forget. Securing your backups! Brian Kelley, our resident security expert, brings some advice and ideas for ensuring your data will not be stolen. http://www.sqlservercentral.com/articles/Security/securingsqlbackups/1781/2005/03/21http://www.sqlservercentral.com/articles/Security/securingsqlbackups/1781/