From a Windows 10 Pro workstation (in a workgroup) I am having a problem connecting to a SQL Server 2022 Express edition installed on a Windows 11 Pro machine (in the same workgroup), using Windows authentication.
I have setup the SQL Server to allow both Windows and SQL Server users, and have tested connection with a UDL file on the Windows 10 Pro machine. It connects with SQL Server logon, but not with Windows authentication. On the Windows 11 Pro machine, a similar UDL connects both with Windows and SQL Server user authentication.
Likely the OLE DB driver for the two machines are different, though in the UDL on both I select "Microsoft OLE DB Provider for SQL Server".
On the Windows 10 Pro machine it does show the server name in the dropdown box, and I can select it, but with Windows Authentication I get an error
[DBNETLIB][Connection Open (Connect()).]SQL Server does not exist or access denied
as soon as I try to expand the database dropdown box. With SQL Server auth, and after entering SQL user name and password, the database dropdown box shows the available databases on the server, and after selecting one, the test connection reports success.
It is clearly the Windows authentication that is failing, but what is causing it and what can I do to solve it?
I have asked my friend Google and have read countless of Q&A's on various sites and fora (even here on stackoverflow), but so far to no avail. I hope for a bit of luck with this question.
Regards Soren