Security Auditing Matching Up Logins And Users

I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?

Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products

This document provides you with information that will help you understand the concepts of identity in SharePoint 2010 products, how Kerberos authentication plays a critical role in authentication and delegation scenarios, and the situations where Kerberos authentication should be leveraged or may be required in solution designs. The document also shows you how to configure Kerberos authentication end-to-end within your environment, including scenarios which use various service applications in SharePoint Server. Additional tools and resources are described to help you test and validate Kerberos configuration. The "Step-by-Step Configuration" sections of this document cover several SharePoint Server 2010 scenarios.

Security Disclosure

Did your company lose data last year? It can be hard to know, especially when even laws designed to ensure breaches are reported have loopholes. Steve Jones thinks this is a bad idea.

Software Vendor Security

This week Steve Jones finds some issues with the security of third party vendor software.

For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin

In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...

Discuss content posted by NT

Discussions about content posted by NT

Discuss content posted by Richard Pless

Discussions about content posted by Richard Pless

Configure Windows Firewall for SQL Server 2008 Integration Services in Windows Server 2008 R2

I have installed SQL Server 2008 on Windows Server 2008 R2 and I am unable to connect to SQL Server 2008 Integration Services Instance from SQL Server 2008 Management Studio which is installed on another remote server. As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 Integration Services in Windows Firewall for user connectivity.

Discuss content posted by Elliott Whitlow

Discussions about content posted by Elliott Whitlow

Encryption