Questions tagged [kerberos]
A network authentication protocol developed at MIT that allows secure authentication for both the user and the server.
47
questions
0
votes
2answers
46 views
pre login initialization =29237; handshake=26244
Connecting to one of my servers (no mirror or availability group running), from a local machine and I get this error message below related to handshake when the firewall is up.
when the firewall is ...
2
votes
1answer
103 views
Old ODBC app throws “cannot generate sspi context” on Windows 10
An old Access 2003 .adp project is currently running on Windows 7 machines, while SQL Server 2008 is on the backend.
Since the app is moved to a Windows 10 machine, the app will trigger "Cannot ...
0
votes
0answers
36 views
unable to set kerberos authentication in mssql 2014 express
Hello I've recently installed MS SQL 2014 Express in MS Server 2016 Essential
I wanted to use Kerberos authentication so I've run through many pages but whenever I'm trying authentication always says ...
5
votes
1answer
100 views
how to stop using sql server login credentials in a linked server?
I have a linked server based in Italy server_italia that connects to a server based in Oregon USA ORDB1
we are on different but trusted domains.
The connection from server_italia to ORDB1 is made ...
0
votes
0answers
46 views
mssql + sssd Ubuntu cannot login via AD group
I've got mssql 14.0.3192.2-2 setup unter Ubuntu; I have joined my machine to AD as described here.
The Windows login via SSMS and sqlcmd works if I add invididual AD users, but not if I add groups.
...
0
votes
0answers
24 views
Executing Project-deployed SSIS package Works in SSA job but not via SSMS Object Explorer
I'm configuring a SSIS project in the SSISDB repository of a SQL 2016 instance. I have experience setting up credentials and SSA proxies to run packages with Windows authentication via SSA job steps. ...
0
votes
1answer
48 views
differences in the authentication scheme - could it be because of Kerberos?
I am using this script to check the connections to my sql server:
select
C.client_net_address,
S.host_name,
c.session_id,
c.net_transport,
c.protocol_type,
c.auth_scheme,
s.program_name
from sys....
1
vote
0answers
250 views
SSIS 2017 KerberosSupport - Double Hop Issue
I am having an issue with what appears to be a kerberos double hop issue with SSIS 2017.
The setup consists of a backend database cluster servers (DBSERVER01\02) an Application\SSIS server (...
1
vote
1answer
116 views
Question on Enabling Kerberos Authentication using SetSPN for Availability Listener alternative DNS name
We have Availability Group, and original DNS name that was given to AG Listener, is too long (something like longername-Listener-01.mydomain.com); Its hard for us to change original DNS name of ...
2
votes
0answers
255 views
Enabling Kerberos for Microsoft SQL Server Reporting Services
I am trying to enable Kerberos for MS SQL Server Reporting Services. I am fairly familiar with Windows security and how it works. However, I am new to Scale Out Deployment and Clustering of Windows ...
1
vote
3answers
730 views
NTLM vs Kerberos authentication - questions
We have 4 servers, all are members of the same Domain:
1. SQL 2012 on Windows Server 2016
2. SQL 2012 on Windows Server 2012
3. SQL 2017 on Windows Server 2016
4. SQL 2017 on Windows Server 2016
I ...
0
votes
1answer
714 views
How to get Kerberos working against a named SQL Server instance in Power BI Report Server?
I have a Power BI Report Server working perfectly connecting to SQL Server machines with a default instance only. I can also connect to SSAS named instances with the proper SPNs and by allowing ...
2
votes
1answer
1k views
SQL Server - register Service Principle Name without service restart?
I have a live SQL Server 2012 environment that had no SPN registered - this has previously not been an issue as Kerberos authentication wasn't required. But now it is required.
I have configured ...
0
votes
0answers
1k views
Why SQL Server Kerberos authentication does not work?
I am trying to find out why there is no Kerberos authentication on my SQL instance :
SELECT COUNT (auth_scheme) as nb, auth_scheme --net_transport, client_net_address
FROM sys.dm_exec_connections
...
2
votes
0answers
1k views
SQL Server SPNs not being created, state: 43
I'm trying to configure a SQL Server 2014 (12.0.5000.0) instance to use a regular user account in AD and Kerberos auth. During installation the default accounts (local system ones) were used, and the ...
3
votes
1answer
53 views
Using DNS per application in ConnectionStrings
I have come across an idea recently when I had to migrate a ton of in-house applications to a new SQL server. The more I look at it, the more it sounds perfect, but I wanted to ask the community for ...
0
votes
1answer
732 views
Linked Server - Double Hop - Kerberos - TCP
I am having trouble with a Linked Server.
I would typically not use a linked server, but legacy issues are forcing my hand.
I am attempting to set up a linked server between two new production SQL ...
1
vote
0answers
254 views
Postgresql delegated authentication with S4U2 not working
I am trying to authenticate to Postgres with Kerberos using S4U2 delegation with a service principle impersonating the user.
I have delegated the principal 'HTTP/sp01.domain' to login as 'username' ...
1
vote
0answers
690 views
SQL Server Kerberos Delegation on Failover Cluster Instance
I am attempting to setup kerberos delegation on a SQL Server failover cluster in order to get around the double-hop issue but have hit a roadblock.
Environment Overview:
Four SQL Servers in two ...
1
vote
1answer
2k views
Windows Authentication for SQL Server Linked Servers
Currently, on our project, we have a situation: there are a SQL Server 2012 instance IA in domain A and MS SQL Server 2012 instance IB in domain B. Domains A and B are trusted. IB configured as the ...
0
votes
1answer
756 views
cannot generate sspi - None of Solution worked!
I am receiving "cannot generate sspi" error when I try to connect a sql instance remotely. I suspected the issue might be with spn and verified that spn was registered properly on the service account(...
8
votes
2answers
13k views
What should my SPN entries look like for each SQL instance?
I'm finding contradictory information for how exactly to format SPNs (Service Principle Names) to get the proper Kerberos connections, and how many I need for each SQL instance.
This 2017 MS ...
1
vote
0answers
581 views
Occasional Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error
I know that this issue has been discussed elsewhere and I already read it. Our problem is that this occurs only once a day (roughly), the rest of time everything works fine.
SERVER RS
Windows Server ...
15
votes
2answers
48k views
The certificate chain was issued by an authority that is not trusted
some time ago I installed SQL server 2016 developer edition on a windows 10 home edition environment (a laptop to be precise) and everything was fine.
then someone - an administrator on the box - ...
4
votes
1answer
633 views
SSMS connections not using KERBEROS over VPN - why?
I have a very simple setup. SQL Server X (2012) and SQL Server Y (2016). X has a linked server to Y using the setting "Connections will: Be made using the login's current security context". SPNs are ...
1
vote
1answer
509 views
Can I configure Oracle such that a Windows client can connect to a Linux Oracle server without a password?
I am attempting to configure Kerberos authentication to an Oracle 11.2 database from a Windows client. The goal is to have an IIS Application Pool connect to the DB via its service account ...
1
vote
1answer
776 views
Access - SQL Server: cannot generate SSPI context
I actually understand why this error messages pops up, but I do not know how to implement my solution.
There is a SQL Server network instance I am providing some MS Access forms to interact with, ...
4
votes
1answer
3k views
set SPN on SQL cluster
I have a question about how to manually set SPN for using Kerberos authentication on a SQL cluster.
Do I set one SPN on the clustername or one on each node?
I also have a default named instance, do ...
2
votes
2answers
2k views
Kerberos Configuration Manager - Does it work with SQL Server 2016?
I have just installed Kerberos Configuration Manager on a clustered SQL Server 2016 server and trying to connect using the app, it keeps failing.
I can connect using SSMS, but not with Kerberos ...
3
votes
1answer
499 views
MongoDB Fails to get TGT
I've setup MongoDB enterprise on CentOS 7 with Kerberos support. Additionally I've setup a Kerberos service on CentOS 7 for the authentication. I know that Kerberos is setup correctly as I now have ...
3
votes
1answer
496 views
What sort of SPN / AD Computer Delegation do you need for delegation of credentials to a linked server that connects to a file share?
The idea here is to perform a double hop and delegate the credentials of the client (leeand00@example.org), that have been sent to the SQL2.example.org server to SQL3.example.org (admittedly this is ...
5
votes
1answer
347 views
What is a Forest?
I am reading the Microsoft article How to troubleshoot the "Cannot generate SSPI context" error message
The two quotes imply that if I know what a domain is I should know what a forest is, but I don'...
4
votes
2answers
5k views
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
I have an Operations server running Windows Server 2012R2 and SQL Server 2014 Enterprise back end. This server is used to deploy new code to other production servers via cmd file called by a SQL ...
3
votes
2answers
838 views
Cannot register SPN, error 0x80090350, state 4
This is my first time trying to configure kerberos. I need it for SQL Server.
Considerations
I'm running SQL Server 2008 R2 on Windows 2008 R2 server.
I have an Active Directory account for SQL ...
1
vote
0answers
667 views
Connecting to MS SQL server from a Linux box
I am trying to connect to MS SQLServer from an application that I have written (using Qt) which runs on Linux. Here are some details of the setup:
The SQLServer box (SQLBox) is part of my domain (...
0
votes
0answers
277 views
Kerberos and Linked Server
I have been reading through past posts but I am still getting issues with 2 SQL servers connecting using a linked server when querying from a 3rd SQL server. I constantly get the error "Login failed ...
1
vote
1answer
547 views
Mongodb: Couldn't find mech GSSAPI
I am trying to understand how mongodb works with kerberos. To do that I have configured a kerberos server, just only for local. This is the configuration of my realm:
this is the content of krb5.conf ...
0
votes
1answer
914 views
Only local administrators can connect remotely
I'm facing a problem that when I try to connect to the SQL Express instance from client to server. The Server logs an error:
SSPI handshake failed with error code 0x8009030c, state 14 while
...
14
votes
1answer
4k views
Why would you use a managed service account rather than a virtual account in SQL Server 2012?
In SQL Server 2012, service accounts are created as virtual accounts (VAs), as described here, as opposed to managed service accounts (MSAs).
The important differences I can see for these, based on ...
0
votes
1answer
78 views
Linked SQL Servers
I'm trying to link 2 SQL Servers (2008 and 2005). I have tried it via the GUI and scripts, and having no luck. I have problems trying to to query through it with access. As I'm not the Admin of the ...
0
votes
0answers
1k views
SSPI handshake failed with error code 0x80090308 connection to Sql Server 2008 R2
I have a cross domain situation where the SQL Server 2008 R2 server sits in one domain and the client in another. There is a one-way trust between the domains. The SQL Server runs on a domain account. ...
3
votes
1answer
40k views
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed
As the title states, I'm getting the following error when attempting to use a ASP.NET webapp:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed ...
0
votes
1answer
1k views
Kerberos Authentication Issue
I'm getting these errors when testing a linked server from SQL Server 2012 to SSAS 2012 (both servers are Windows 2012 and clustered)
"An error was encountered in the transport layer" and "The peer ...
20
votes
2answers
73k views
How can I get my linked server working using Windows authentication?
I'm trying to get a linked server to ServerA created on another server, ServerB using "Be made using the login's current security context" in a domain environment. I read that I'd need to have SPNs ...
0
votes
1answer
726 views
BUILTIN\Administrators allowing access via linked server but not locally
We have two servers:
LYNDB01 & LYNDB02
On LYNDB01 we have a database called db_ExampleDatabase
We have created a Linked Server on LYNDB02 to LYNDB01 using no mappings and the "Be made using the ...
8
votes
2answers
6k views
Kerberos authentication not working with Linked Servers in SQL Server 2012
I am setting up a DEV/TEST environment using 2 SQL Servers running SQL Server 2012 on Windows Server 2012. We are moving from SQL Server 2005 on Windows Server 2008, where we already have this up-and-...
2
votes
1answer
184 views
Possible Pitfalls of Setting Up Kerberos to Permit Cross-SQL Database Access Via AD Trusted Connection
We are hoping to the implement Kerberos on our Active Directory (2003, Functional Level 2) so that our SQL Server 2005 databases can communicate with one another when a client is using Active ...
