Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  Database  >  How to Connect your Database Remotely through SQL Management Studio?
Top Scroll

How to Connect your Database Remotely through SQL Management Studio?

 2 min

Steps to connect your database remotely through SQL Management Studio:

  • Open Microsoft SQL Server Management Studio. 

  • Connect to Server dialog box appears on the screen.

  • In the Server type list box, select Database Engine.
  • In the Server name text box, enter the name of the server or IP address.
  • In the Authentication list box, select SQL Server Authentication. 
  • In the Login text box, type the Microsoft SQL database username.
  • In the Password text box, enter the password.
  • If you do not want to re-enter the password every time you connect to the server then, select the Remember password check box.
  • Now, click on Connect.

  • You will see the database in the object explorer window.

That’s how you can connect to the database remotely through the SQL management studio.

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
Claim the discount before it’s too late. Use the coupon code:
Note: Copy the coupon code and apply it on checkout.