Good morning,

having to install a windows software to read a sql server database, I worked on a win10 machine with sqlserver 2022 express already installed.
I restored my database on the existing instance. Whoever had installed sql had correctly opened the 1433, and activated tcp/ip and namedpipes. The problem is that the windows application does not access the db from any client (apart from the win10 server). Investigating I discovered that from the clients a dns created with odbc64 works correctly, while a dns created with odbc32 does not access. The windows application that I have to install is 32. In addition, if I deactivate the firewall of the win10 server (the domain part is enough for me) the odbc32 also works (and therefore also the windows application). I can’t understand. Can you help me?

Andrea

​Good morning,having to install a windows software to read a sql server database, I worked on a win10 machine with sqlserver 2022 express already installed.I restored my database on the existing instance. Whoever had installed sql had correctly opened the 1433, and activated tcp/ip and namedpipes. The problem is that the windows application does not access the db from any client (apart from the win10 server). Investigating I discovered that from the clients a dns created with odbc64 works correctly, while a dns created with odbc32 does not access. The windows application that I have to install is 32. In addition, if I deactivate the firewall of the win10 server (the domain part is enough for me) the odbc32 also works (and therefore also the windows application). I can’t understand. Can you help me?Andrea  Read More

​