How to allow Access to SQL Server on Network?

After installing the SQL Server Database Engine & Management Studio, the next step is to allow access to SQL Server on Network. To enable access to the SQL server on the network, follow the given steps:

Step-1 Open SQL Server 2017 Configuration Manager.

SQLServer2017ConfigurationManager

Step-2 In the ‘SQL Server Network Configuration’, open “Protocols for SQLEXPRESS. You have to enable both, Name pipes and TCP/IP protocols. Shared Memory is by default enabled.

SQLServerNetworkConfiguration

Step-3 Next step is to enable TCP/IP protocol as shown in the picture below:

Enable-Protocols

After setting Enabled option to Yes, go to IP Addresses settings. Here, set the TCP Port of IPAII to 1433.

IPAII-TCP-Port

Click on Apply and OK button to save the changes.

Step-4 Although the changes are saved, they will not have any effect until you stop and restart the SQL Server Services. For restarting the services, go to the SQL Server Services option.

RestartSQLServerServices

Step-5 Open Windows Defender Firewall. Go to the Advanced Settings.

WindowsDefenderFirewallAdvancedSettings

Step-6 Go to Inbound Rules. Click on New Rule.

SetNewInboundRule

Step-7 New Inbound Rule Wizard will open. In the Rule Type section, select the Port option. Then Click on Next button.

RuleType

Step-8 In the Protocol and Ports section, enter the Specific Local TCP port number i.e., 1433. It means that the rule will be applied to the specific TCP ports.

ProtocolAndPorts

Click the Next button to proceed.

Step-9 Select “Allow the Connection” option as Action type and click on Next button.

Action

Step-10 Select Domain, Private, & Public options in the Profile section. Click the Next button to proceed.

Profile

Step-11 Enter Name of the rule. You can also specify the description.

EnterName

Click the Finish button to save the rule.

Step-12 In the Windows search bar, search for Services. Then, Click to open the Services.

Services

Step-13 In the SQL Server Browser set the Startup Type to Automatic.

SQLServerBrowser

Also, copy the program path mentioned in “Path to executable:” option. Make sure to save it in notepad or MS-word.

Step-14 Now again go to the Inbound Rules and create New Rule.

Select Program as Rule Type and click on Next button as shown in the figure below:

RuleType-Program

Step-15 Paste the program path that you copied in the Step-13, or you can browse it also.

ProgramPath

Step-16 Select “Allow the Connection” option as Action type and click on Next button.

Action

Step-17 Select Domain, Private, & Public options in the Profile section. Click the Next button to proceed.

Profile

Step-18 Enter Name of the new rule. You can also specify the description.

EnterRuleName

Click the Finish button to save the new rule.

(Visited 48 times, 1 visits today)

About The Author

You might be interested in