Start a conversation

How do I connect to my MSSQL DB using SQL Server Management Studio?

Getting Started:-
1. Create an MS SQL 2014 database and database user using Plesk under the domain that needs the DB.

 

Click on the databases in the toolbar then
 select to Add Database

Then put all the details marked on the picture. Better you use the generated password.

Go to website & domains and copy that IP address and paste on the next step.


==>Start SQL Server Management Server Studio.

The 'New Server Registration' window should now be visible.

==> Server Name: Enter the Public IP Address of the database server, this information can be obtained from your Database Manager within your Plesk Control Panel for the domain, under the database name, for example, 5.77.38.104

SQL Server Management Studio which is available for free from

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

 The IP address of the computer/server you wish to connect from.




Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Eicra.com

  2. Posted
  3. Updated

Comments

  1. Vengramma

    Hi everyone glad to be at this forum.