I am getting error A network-related or instance-specific error while accessing SQL Management Studio ?

Solution :

If your ip address is not allowed in server firewall then you will get an error ” A network-related or instance-specific error”. To add ip addresses, follow the steps given below

[1] Login to your plesk control panel
[2] Click on the domain name you wish to add the ip for sql access from the subscriptions list
[3] Click on Websites and Domains option in your control panel
[4] Click on AddSQLIP button in the control panel
[5] Supply the IP Address and submit
[6] Wait for 15-20 min to get your ip reflected in the firewall

Then you can access the database via sql management studio.