How do I configure MS SQL Express Server to allow remote connections?

To allow remote connections, please follow these steps:

1. Log into your server through Remote Desktop Connection (instructions for connecting to your server
   
   

   Getting Started:-
   1. Create an MS SQL 2005 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

   http://msdn.microsoft.com/vstudio/express/sql/download/

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

   Click Start