Question : After windows patching (windows 2008 R2 , SQL Server 2012 Sp2). I could not start SQL Server Service […]
Tag: spn
What should my SPN entries look like for each SQL instance?
Question : I’m finding contradictory information for how exactly to format SPNs (Service Principle Names) to get the proper Kerberos […]
SQL Server – register Service Principle Name without service restart?
Question : I have a live SQL Server 2012 environment that had no SPN registered – this has previously not […]
Server 2012 Linked Server From An Instance
Question : I have 3 SQL Server 2012 Instances, 2 on SiteA on the same server SiteAServer. I have 1 […]
Whay does the SQL Server Service account has the “”Impersonate a client after authentication” Right?
Question : Our database is running on SQL Server 2008 hosted on a Windows 2008 Server. We have found that […]
Can an AD service account host SPNs for multiple SQL Instances?
Question : Trying to set up Kerberos Authentication between two linked server to get past the double-hop issue. Server A […]
set SPN on SQL cluster
Question : I have a question about how to manually set SPN for using Kerberos authentication on a SQL cluster. […]
cannot generate sspi – None of Solution worked!
Question : I am receiving “cannot generate sspi” error when I try to connect a sql instance remotely. I suspected […]
Connection to database causes SSPI context error
Question : I have migrated a SQL server from another server box that was decommissioned. They have the same name […]
What is Accepted NTLM SPNs
Question : In SQL Server Configuration Manager on the Advanced tab in TCP/IP Protocol properties box there is an option […]