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)
Select Connections in the left panel and make sure that a check-box Allow remote connection to this server is selected. (See in fig)
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)
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 )
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 )
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).
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.
Your FREESharePoint Online Ebook is on its way to your Email Inbox. **************** You will get notification on FREE SharePoint online training, SharePoint webinars, Video Tutorial & also latest FREE PDF tutorials