Remote Access to MS SQL Server Database
This articles applies to Windows Business package with SQL server database
To access and manage your SQL Server 2005 database from your desktop you will need to have Microsoft SQL Server Studio Manager Express or standard edition installed. You can freely download the express edition from Microsoft website:
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en
1. Open Microsoft SQL Server Studio Manager and enter the server connection information
a. Server Name: neptune.infomind.co.uk,5000
(check your account details or control panel for correct SQL Server Host name)
b. Login Name: this is created when adding the database
c. Password: this is created when adding the database
d. Connect
Note (Important)
It is important to use ,5000 on the end of the server name. Habesha.net has closed the standard MS SQL Server port to public access
Accessing SQL Server 2005 from a proxy network that does not forward TCP ports other than common ports may have difficulty access server. As mention above accessing SQL Server from a public internet connection requires a connection on TCP Port 5000 and therefore the locally proxy if used must forward that port.