FREDERICK (2/5/2013)
HelloAnother party set up the Server and Databases.
First the Server was set up
Windows Server 2008 SP1
Then the Databases were set up
SQL Server 2008 along the reporting Services
Server Authentication - SQL Server and Windows Authentication
Now I go to use Reporting Services with Integrated Windows Authentication and find Kerberos was never set up.
So I ran this to check the Kerberos
SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@spid
And I got
NTLM
SO my question is:
If I set Kerberos now, will this cause any issues?
Thanks
FRED
Connecting to a local instance is always done using NTLM, i.e. when on the server where SQL Server resides and connecting to a local instance.
Setting up your SPNs such that remote clients authenticate using Kerberos instead of NTLM is transparent to the database operations within SQL Server and should not cause you any trouble.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato