SQL Server Magazine

Fortify Remote-Server Security

Attacks on branch-office domain controllers can spread to your entire forest. Read-only DCs help Windows Server 2008 reduce that risk by eliminating multimaster replication, limiting password caching, and restricting the reach of local administrators.

Secure Access to Report Data

Restrict and secure access to SQL Server Reporting Services report data by linking SSRS roles to report folders, then mapping roles to AD users and groups.

How ADFS "Does" Identity Federation

Microsoft Active Directory Federation Services (ADFS) lets you allow designated users access to your network—but to use ADFS, you need to know about ADFS components and the claim transformation process.

Windows Vista's Take on Least Privilege

With Vista on the horizon, now is the time to examine how the new OS redefines the concept of least privilege into a more behavior-based dynamic.

Dump and Query Event Log Files on Remote Systems

Extending Windows SSO to Enterprises

ENTSSO is a valuable service for enterprises that want to streamline and integrate the Windows-rooted portions of their IT infrastructures and applications with other legacy systems and applications.

ENTSSO Password Synchronization

ENTSSO password synchronization ensures that user passwords on different platforms are in sync.

Logging with the Netlogon service

Turning the Netlogon service on and off and analyzing the content of Netlogon log files can help you solve authentication problems. Find out how you can accomplish these useful tasks.

NT Gatekeeper: Using SQL-Like Queries to Extract File-Format Information

Need an Event Viewer log file query tool that supports an SQL-like query language? Microsoft's Log Parser could be the answer.

NT Gatekeeper: Using Windbind to Enable SSO Between NT and Linux

You can use Winbind, a little-known Samba service, to create unified logons between NT and UNIX systems.

NT Gatekeeper: Interpreting Authentication Event IDs

Here’s an explanation of the fields in a user authentication event.

NT Gatekeeper: Changing Event-Log File Locations

You can edit the registry to change the location of Event Viewer log files.

NT Gatekeeper: Audit for Failed Logon Attempts

To monitor failed logon attempts, you must enable auditing for “logon and logoff” events in a domain’s audit policy and in the local audit policy of every workstation or member server.

Ensuring That No One Can Access Deleted Data

Learn how to ensure that deleted data isn’t accessible.

NT Gatekeeper--Learning about NT 4.0 Remote Access Client-Side Logging Options

Discover the available NT 4.0 RAS client-side logging options.

NT Gatekeeper--Exploring the Netlogon Change Log

Learn how to use the Netlogon change log, which ensures SAM replication.

NT Gatekeeper--Using a Command-Line Tool to Clear Event Logs

Learn which command-prompt tool lets you delete all entries from a log.

NT Gatekeeper: Deleting Specific Event Viewer Log Entries

Use WinZapper to remove specific event log entries.

NT Gatekeeper: Configuring SQL Server Access Across a Firewall

Learn how to let your IIS front end communicate with your SQL Server back end without punching large holes in your firewall.

NT Gatekeeper: Setting Up Auditing to Track Application Use

Discover how to monitor the execution of a particular program on users’ desktops by using a trace and Windows NT Event Viewer.