Problem:--    How to connect to the remote Sql Server through your local Sql Server.


Solution:--

Definition:-- Sql  Server plays an important role while providing data to the front end of a                                         website.
                      Sql server after installation need to remote Sql Server can be connected so that the data                       can be fetched from the database to show it on the front side

• To connect to Remote Sql we can also connect it through the sql in our system
• we just need to connect it through the IP of that system to which we want to connect.
                                                                                                                                          Steps to follow :-                                                                                                                   
• Go to the Object Explorer in your SQL Server
• Click on the Connect  button , you will get a drop down there .
• In the drop down option , click on the  DataBase Engine Menu.

• While clicking on the DataBase Engine option , it will popup a  window to connect to server.
• Enter the remote server IP or the server Name. 
• Chooose windows authentication option from  the authentication .
• Enter User Name in the field of UserName .
• Password in the password field.

Now you will get to connect to Remote  Sql Server and will get all the DataBases  of Remote SQL Server from the left side of your  SQL.