If you have a MS-SQL Database and would like to use MS-SQL Server Management Studio 2012, here’s how you connect it.
- Open MS-SQL Server 2012 Management Studio
Enter your database server IP address as the Server name (Check the image below to locate your database server IP address from your Plesk Panel)
- Select "SQL Server Authentication"as Authentication
- Enter your database username
- Enter your database password
- Click on Connect
That’s it. You’ll now see your database listed on the left of your screen on left of your screen on the Object Explorer. You’re all good to manage your database from there.