I have a named instance of SQL Server 2019 Developer Edition running on my host Windows 10.
Using SSMS I can log in locally using Windows Auth or a SQL Server account.
Whenever I try this from my Laravel site running on my Linux VM running under Hyper-V (using the sa account), the authentication fails.
SQLSTATE: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed for user 'sa'.
This only started failing recently after KB5015807 was installed on my Windows10 host, uninstalling the patch makes the authentication work again.
Are there any known issues/changes in this patch for SQL Server auth?
UPDATE 1 (7th Sept 2022):
So, I've since moved the linux VM onto VMWare ESXi 6.5 (to work around Hyper-V).
I'm still getting the same error, though I did find an error item in the logs:
Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only.
Source MSSQLSERVER
Category (4)
Event 18456
Computer [MyHostMachine]
Of course, it is configured for mixed mode.
select serverproperty('IsIntegratedSecurityOnly')
returns 0 and my sa password works when logging in through SSMS. Any ideas?
UPDATE 2 (12th Sept 2022):
Got my dev machine working under ESXi, Laravel doesn't like port 1433 being specified, also updated the production server (which still works).
Updated my old Hyper-V VM, which still doesn't work, so definitely a Windows/Hyper-V issue - hopefully a future patch will resolve it.
Asked by SteB
(349 rep)
Aug 28, 2022, 06:59 PM
Last activity: Mar 5, 2025, 07:02 AM
Last activity: Mar 5, 2025, 07:02 AM