Windows error 0x8009030C, -2146893044

SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security

I get the following error while trying to connect to SQL Server 2005 using JDBC connection. Error: 17806, Severity: 20, State: 2. Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 127.0.0.1] Logon Error: 18452, Severity: 14, State: [...] read more

gMSA account authentication failure during password rotation

When our gMSA accounts are automatically rotated, we see login failures for around 1-10 minutes. This is particularly apparent for gMSA client accounts that connect to MS SQL server, but I think it happens for other gMSA accounts as well. MS SQL server is not running as a gMSA account, [...] read more

Forefront Identity Manager errors when starting the SharePoint 2010 User Profile Synchronization Service Application

After following Spence Harbar's Rational Guide to implementing SharePoint Server 2010 User Profile Synchronization (http://www.harbar.net/articles/sp2010ups.aspx) exactly (and having it work several times for other implementations) in this particular instance, starting the user profile synchronization service generates the following errors (these can be found in the windows logs of the server [...] read more

SQL Server mirroring refuses to work. Tearing my hair out

I'm trying to attempt what I thought would be a very simple process - the mirroring of a database between two MSSQL 2008 R2 servers within the same domain. Both servers are configured similarly, and I have a database called 'archive' that I'd like to mirror. I took a full [...] read more

Which user is used in trusted connection to SQL Server - IIS/ASP.NET

A bit of background first. I have an ASP.NET application which lives in the DMZ on our network. It needs to access SQL Server instances on machines which live within our trusted network. I will call the web server WebServer1 and an example SQL Server SqlServer1. Currently, our web server [...] read more

How to see the connection string used to connect to SQL Server

Is there a way to see what connection string was used to connect to SQL Server? Or rather what string was used in a failed login attempt. Many times I deal with complex systems in which I see failures caused by some service failing to log in to SQL. I [...] read more

How do I log in, using SSPI, to SQL Server 2008 R2 on a server in one workgroup from a workstation in another?

We're having trouble connecting to our SQL Server (2008 R2) via SSPI. Our team has recently moved from a domain-based setup to a decentralised workgroup-based setup. Each developer has access to a VPN which, in turn gives them access to a database server running SQL Server 2008 R2. We've previously [...] read more

Unable to connect to database using Win Auth on from ASP.Net web app hosted in IIS7

I've a web application hosted on Windows Server 2008 64 Bit with IIS 7 and SQL Server 2008. The web application pool account is Network Service and I've added this account to SQL Server 2008 logins and mapped to user in database with dbowner rights. This Web site is in [...] read more

Windows authentication for remote user in ASP.NET Core application with Entity Framework

Background I have an ASP.NET Core application running in Http.sys to provide Windows authentication. The client side of my application works with Windows authentication and users are prompted for their Windows login credentials when first accessing the site. All good with that. I am using a SQL Server database (hosted [...] read more

Security problem when connecting to SQL from Windows 7

I need to connect to a SQL Server 2005 from a Windows 7 machine that is not joined to the domain. This has always worked on XP but on Win7 I get the following error (when connecting via TCP/IP): > Login failed for user ''. The user is not associated [...] read more

Problem connecting to Sql Server 2005 on Vista From XP Home

I am attempting to connect to a copy of Microsoft Office Accounting 2009 (running on Vista 64) from a laptop running XP home. I have done all of the MS steps (create user on Vista with same username and password, etc) and I can access files on the workstation from [...] read more

SSPI handshake failed with error code 0x8009030c when connecting to localhost, but not 127.0.0.1

I am using JDBC to connect to SQL Server 2005 locally using integrated security. It is failing with: Error: 17806, Severity: 20, State: 2. Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 127.0.0.1] Logon Error: 18452, Severity: [...] read more

Make Win7 use new password without reboot or screen unlock

We call DirectoryEntry.Invoke("SetPassword",newpwd) to change the password of a local user, but the new password is not being used immediately when doing Windows Authentication to a remote SQL server. It does get used after a reboot, but that's not really an option for me here. How can I make it [...] read more

SQL Server error log entry : Error: 17806, Severity: 20, State: 14

I have error in my log for a few weeks, I searched a lot but I couldn't found useful answer. I did close SQL Server port for public IP, But I have problem yet. > Error: 17806, Severity: 20, State: 14. > SSPI handshake failed with error code 0x8009030c, state [...] read more

Cannot create SQL Server DB within Amazon RDS Instance

This seems to be a common question, however I haven't found a solution out there and many related questions are quite vague. Anyways, I am deploying an ASP.NET MVC 5 application to AWS using the AWS toolkit for Visual Studio Pro 2013. I have successfully published the app to Elastic [...] read more

Exchange 2003 and ID 1705

My Exchange server is occasionally throwing up a 1705 error: An unexpected error is forcing EXPS to close the SMTP connection to "SERVERNAME". "CSessionContext::OnEXPSInNegotiate" called "HrCheckClientPermissions" which failed with error code 0x8009030c ( f:\tisp2\transmt\src\smtpsink\exps\expslib\context.cpp@1819 ). The server that is lists in SERVERNAME is another internal server... but that other server [...] read more

Cannot login SQL Server after changing machine name

After installing and setting up new machines in a domain, we decided to rename one of them which had a SQL Server instance installed. So I changed the hostname, everything went fine regarding the domain but now, the server is logging a approximatively 2 SQL Server errors every 5 minutes [...] read more

Collibra Connecting from DGC instance hosted on Vendors AWS account to SQL Server on EC2 within Company's Network

I need to connect to a SQL Server on EC2 which is hosted on AWS in the Company's network from a Managed Service (Collibra DGC) which is on AWS Account on Vendors (Collibra's) network. I am using a JDBC JTDS driver and authentication menthod as Windows Authentication (NTLMv2) as this [...] read more

Restore SQL DB in RDS using SMO?

Im trying to create a new Database to use within in my .net web app using an existing one as a template using SMO. The code I have, which works when pointing to my local db instance, is the following: var server = new Server(serverConnection); server.ConnectionContext.Connect(); var newDatabase = new [...] read more

connection error with SQL connection string

I am following a white paper that is a simple VS application that uses .NET to connect to a SQL server 2012 database. https://www.mssqltips.com/sqlservertip/5677/how-to-get-started-with-sql-server-and-net/ My host where my application resides is a windows 7 machine. I have a vmware virtual server that contains the SQL server 2012 enterprise edition installation [...] read more

Error with Custom Role Provider: The login is from an untrusted domain and cannot be used with Windows authentication

Having deployed the latest build of a C# MVC app to a test server this is the error I'm getting. This all works fine when run locally in VS2013. I'm using a custom provider and I'm pretty sure this worked ok before. The relevant part of web.config looks like this: [...] read more

"SSPI handshake failed" from unknown location?

I realised a few minutes ago , in my sql server log; there was an error: > SSPI handshake failed with error code 0x8009030c, state 14 while establishing > a connection with integrated security; the connection has been closed. Reason: > AcceptSecurityContext failed. The Windows error code indicates the cause [...] read more

SSPI always picks up NTLM

I have a windows7 connected to a windows2008-r2 domain. Each time I try a SSPI "Negociate" (C++), I fall back to NTLM. I do not understand why... DNS on DC are ok. Something to do I don't ?? If I run a klist I can see all the right, everything [...] read more

Crystalreportviewer.processreponse locks mxsqlserver database account with error SSPI handshake exception

Crystalreportviewer.processreponse locks mxsqlserver database account with error SSPI handshake exception, Message SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. Message Login failed. The login is [...] read more

ODBC fails after changing pc date

We have a girl here who runs a report successfully, then changes the date on her pc, then tries the report again and gets a Connection failed error. * The report is ran in MS Access 2003 * The ODBC itself uses Windows Authentication * The linked table uses a [...] read more

Service broker connection using windows auth fails unless service account is administrator at both ends

Topology: Machine A - Windows Server 2008 - SQL 2008 R2 Dev SQL Server is running as mydomain\user1 Machine B -Windows 7 -SQL 2008 R2 Dev SQL Server is running as mydomain\user1 I have granted the service account at either end connect permissions to the endpoints on either SQL server. [...] read more

Setting up mirroring in untrusted domain environment using Sql server 2008 R2

I have setup mirroring only with principle and mirror in untrusted domain environment using certificates. I have successfully tested the mirroring session by doing a manual failover. But I see a lot of login failures in the mirror server saying > Login failed for user 'NT AUTHORITY\LOCAL SERVICE'. Reason: Failed [...] read more

Unable to connect to database using Win Auth on from ASP.Net web app hosted in IIS7

I've a web application hosted on Windows Server 2008 64 Bit with IIS 7 and SQL Server 2008. The web application pool account is Network Service and I've added this account to SQL Server 2008 logins and mapped to user in database with dbowner rights. This Web site is in [...] read more