How to Connect your Database Remotely through SQL Management Studio?

Steps to remotely connect to your database using SQL Management Studio:

  • Launch Microsoft SQL Server Management Studio.

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2020/11/sql_server_management_studio_open.png

  • The "Connect to Server" dialog box will appear on the screen.

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2020/11/sql_server_management_studio.png

  • In the "Server type" list box, choose "Database Engine."

  • In the "Server name" text box, input the server name or IP address.

  • In the "Authentication" list box, opt for "SQL Server Authentication."

  • In the "Login" text box, enter the Microsoft SQL database username.

  • In the "Password" text box, provide the password.

  • To avoid re-entering the password with each connection, select the "Remember password" checkbox.

  • Finally, click on "Connect."

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2020/11/sql_server_management_studio_connect-min.jpg

  • The database will be visible in the Object Explorer window.

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2020/11/sql_server_management_studio_connected_censored.jpg

That's the process for connecting to the database remotely through SQL Management Studio.


Was this article helpful?

mood_bad Dislike 0
mood Like 0
visibility Views: 145