Steps to enable remote connections for SQL Server Express 2008 R2

InfoPath alternatives for form designing SharePoint

In this post, we will discuss how to enable remote connections in SQL server express 2008 R2. Also, you can check out:

Follow these steps to enable remote connections for SQL Server Express 2008 R2:
Open SQL Management Studio and right-click server name in the left panel and select Properties. ( See in fig)
Steps to enable remote connections for SQL Server Express 2008 R2
Steps to enable remote connections for SQL Server Express 2008 R2
Select Connections in the left panel and make sure that a check-box Allow remote connection to this server is selected. (See in fig)
Steps to enable remote connections for SQL Server Express 2008 R2
Steps to enable remote connections for SQL Server Express 2008 R2
Run SQL Server Configuration Manager.
Go to SQL Server Network Configuration -> Protocols for SQLEXPRESS.
Make sure TCP/IP is enabled.
Now Right-click on TCP/IP and select Properties.
Verify that, under IP2, the IP Address is set to the computer’s IP address on the local subnet. (See in fig)
Steps to enable remote connections for SQL Server Express 2008 R2 while configuring sharepoint 2013
Steps to enable remote connections for SQL Server Express 2008 R2 while configuring sharepoint 2013
Now Scroll down to IPAll.
Make sure that TCP Dynamic Ports is blank.
Make sure that TCP Port is set to 1433.( See in fig )
Steps to enable remote connections for SQL Server Express 2008 R2 while configuring sharepoint 2016
Steps to enable remote connections for SQL Server Express 2008 R2 while configuring sharepoint 2016
Now restart the SQL service
Open SQL Server Configuration Manager and click on “SQL Server Services” in the left panel, right-click SQL Server Browser service and select Properties. (See in fig )
Steps to enable remote connections for SQL Server Express 2008 R2 while configuring sharepoint 2019
Steps to enable remote connections for SQL Server Express 2008 R2 while configuring sharepoint 2019
For exceptions must be configured Windows Firewall to allow access to SQL Server
1. Go to Windows Firewall Advance Settings and create a new Inbound Rule Wizard.
2. Select Port
3. Select TCP and specify port 1433
4. Allow the connection
5. Choose all three profiles.
6. Give the name of the rule.
After this start the SQL service and open the SQL Server Manager Studio in that system where you want to connect remotely and enter the IP address of that system where you configure the remote connection,1433\instance name and click on Connect. (See in fig).
Steps to enable remote connections for SQL Server Express 2008 R2 while configuring sharepoint 2010
Steps to enable remote connections for SQL Server Express 2008 R2 while configuring SharePoint 2010

 


You May Also like the Following SharePoint Online Tutorials:

About Navneet Singh

I am Navneet Singh, Working at C3it software solutions pvt. ltd. in Pune. My core skills are SharePoint 2013, Office 365, SharePoint 2010, SharePoint Designer, SharePoint Designer Workflow, Nintex Workflow, Infopath, Webpart, CSOM/SSOM, Power-shell, C#, ASP.NET and SQL Server.

View all posts by Navneet Singh →

Leave a Reply