How to connect Database with SQL Server Mangement Studio

If you want to connect to the database on your website you can use localhost as database server name
AND Username and password as your Database username & Password.

Windows Hosting
Previous reading
How to restore MsSql database in plesk
Next reading
How to Add Subdomain in Plesk panel