Questions About Kerberos and SQL Server That You Were Too Shy to Ask

Kerberos authentication is a topic that many database administrators avoid. It’s really not that difficult to understand, but it’s also easy to get wrong. In this article, Kathi Kellenberger talks about what you need to know about configuring Kerberos for SSRS and SQL Server databases but were too shy to ask.

SPN Registration and SQL monitoring using SCOM

Solving Kerberos Issues in SSRS When Running Beside IIS

When SSRS is running on a server with IIS, pass through Windows Authentication can be difficult to set up.

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.

Configuring Kerberos Authentication

Longtime author Brian Kelley brings us a new article on security and Kerberos authentication in SQL Server.

Configure MaxTokenSize for SQL Server Authentication

DBA's and web developers at our company are experiencing issues with connecting to SQL instances using SQL Server Management Studio and other SQL tools using Windows Integrated Authentication. Our company is large, with well over 70,000 users and groups in Active Directory. When we look in the NT event log on the SQL Server we see both MSSQL and Kerberos errors. What could be causing this?

RE: Moving Cluster

Hai Colin,We used to move Cluster resources/groups (cluster admin-->right click group-->move group) from one node to another manually.I just want to track when this movement happends...time and date subhash

RE: Dynamically set DTSDestination column name from variable

Yes, this was it.  I found it after stepping through in debug.  I had a field name misspelled in my lookup table so it could not be found.Thank you for responding.

RE: Just a simple question

One very important thing to remember: RESTORE the database using WITH NORECOVERY, the RESTORE the first log WITH NORECOVERY, then the last log using WITH RECOVERY.Oh, second thing to remember....if your database 'goes down', try to backup the current Transaction Log. If you can back it up, you can RESTORE it last using WITH STOPAT […]

RE: store stored proc results into table

Also...     Do NOT use this in a loop or Scalar UDF. This method adds overhead, and should be used as a "last resort". Do not use this method just for the sake of using it, avoid it like you would cursors.     You will also not get information about the "remote" script within your […]