Click Browse, and navigate to the instance of SQL Server that you want to access through the firewall, and then click Open. In the Program dialog box, select This program path. In the Rule Type dialog box, select Program, and then click Next.ģ.
#MICROSOFT DYNAMICS POS ODBC CONNECTION WINDOWS#
In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane.Ģ. To do this, please follow the steps below:ġ. The Inbound Rule will allow Sqlserver.exe to be accessed through the firewall. In the Name dialog box, type a name and description for this rule, and then click Finish. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click next.Ħ. In the Action dialog box, select Allow the connection, and then click Next.ĥ. Select Specific local ports, and then type the port number of the instance of the Database Engine, such as 1433 for the default instance. In the Protocol and Ports dialog box, select TCP. In the Rule Type dialog box, select Port, and then click next.ģ. In the Windows Firewall with Advanced Security, in the left pane, right-click Outbound Rules, and then click New Rule in the action pane.Ģ. This problem can be rectified by creating an Outbound and Inbound Rule as follows:ġ. However, when we turned the Windows Firewall on, the ODBC connection did not work. We were working with a client recently and their ODBC connection worked fine when the Windows Firewall was disabled.
0 kommentar(er)
