Forum Discussion
AndreaC
May 31, 2024Copper Contributor
Firewall blocks odbc32
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 i...
- Jun 03, 2024
olafhelper I solved it by deleting the firewall rule on incoming port 1433 made by the previous supplier and recreating it. I still have the doubt of knowing which restrictions were active previously. Thanks
olafhelper
Jun 03, 2024Bronze Contributor
with sqlserver 2022 express already installed.
AndreaC , by default the free Express Edition get installed as "name instance" =.\SQLEXPRESS and also by default it uses dynamic IP port assignement, not a fix port 1433. Is it so yin your case?
Have you unblocked UDP port as well? See
Configure the Windows Firewall to allow SQL Server access - SQL Server | Microsoft Learn
- AndreaCJun 03, 2024Copper Contributor
olafhelper I solved it by deleting the firewall rule on incoming port 1433 made by the previous supplier and recreating it. I still have the doubt of knowing which restrictions were active previously. Thanks