Okay so 'identical' may be slightly inaccurate, but I have 2 Windows 10 Pro PCs on the same network, neither are on a domain. Both machines have what I believe are the same SQL Native Client 11 and ODBC SQL drivers installed.
The database instance SQLEXPRESS is installed on a server i.e. MY-DATA - both machines can ping MYDATA.
I have created a UDL file to MY-DATA\SQLEXPRESS using the sa account to connect.
On one machine it will connect fine on the other it throws up the error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I am now a little stuck as to where I should go next to troubleshoot the issue and any ideas would be very much appreciated.
Thanks in advance.
Joe.