Tips: sqlservr.exe usually located in this folder:Ĭ:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe Select sqlservr.exe and click Open button. ![]() ![]() Step 4: Locate to sqlservr.exe in pop-up window. Step 3: In Add a Program window, click Browse button next to Path input box. Tips: If "Allow another program" is not available, tap Change settings first, then you would find "Allow another program" become valid. Step 2: Click Allow another program at the bottom side of window. ![]() Click "Allow a program or feature through Windows Firewall" in the left pane. Step 1: Open Control Panel and navigate to Control Panel System and Security Windows Firewall. After allowing SQL Server to communicate through Windows Firewall, Windows Firewall will allow SQL Server access. Steps to allow SQL Server to Communicate through Windows FirewallĪll following settings could be finished in Control Panel in computer. If not, please follow this article to configure Windows Firewall to allow SQL Server access or connections. ![]() In order to guarantee successfully connecting to SQL Server or instance specified, you should check whether SQL Server has been added to allowed programs and features in Windows Firewall. Configure Windows Firewall to Allow SQL Server Access
0 Comments
Leave a Reply. |