How to access MS SQL database Remotely

So guys ! Here are the steps to access SQL Server database remotely.Generally if try to access server database then you will be getting following  error . Please go through  each step carefully.

Setep :1 .Go to the system which you want to make as a server .Open Sql management studio.Right click on current instance then click on properties. 

Step :2. Click on connection and Check the allow remote connection to the server checkbox .Then press ok button.

Step:  3 .Click on security and check the checkbox as  shown in following image.Then press ok button.

Step 4: If have already set the id and password then SKIP this step .

Step 5 . Open command prompt type wf.msc .Then press ok button.

Step 6. Following image showing the firewalls settings .Create new inbound rule for accessing database by other system.

Step 7 .Do as shown in following image .Then press next button.

 Make sure the TCP port must be 1433 .

At client side 

Step 1 .Open SQL server management studio  and connect to database .In the server name textbox click on <brows for more> .Then click on network server tab. 

Note: If you dont get any computer name in the list then you can just put the ip Address of the server computer in Server name textbox.

Step 2 .You are done .

For any query put your comments .

Thanks .