There was a problem loading the comments.

Ways to connect to SQL Server 2005 from your PC

Support Portal  »  Knowledgebase  »  Viewing Article

  • 18 August 2006 2:22 PM

With the advent of SQL Server, it is no longer possible to use the Enterprise Manager that came with SQL Server in order to connect. However there are many alternatives that you can use. There are three ways which we recommend, and they are detailed below:

Option One: SQL Server Management Studio
This software is supplied if you buy a copy of the SQL Server software itself from Microsoft, and is the full client which we recommend that you use if you have it. With many improvements over the old Enterprise Manager which it replaced, this is a great way to manage your databases. Connection details can be found on the database page in Helm, or you can follow the connection steps from the tutorial for the express edition (Option Two) below, which is similar. Only serious developers or companies are likly to have access to this, so although its a recommended way to do it, it will not be the most popular.

Option Two: SQL Server Management Studio Express (Free!)
Unlike SQL Server 2000's Enterprise Manager, an express edition of the management studio mentioned above is available for free download from the Microsoft website. We recommend this to anyone who doesn't have the full client. At the time of writing this article, the download could be found here: Download here

Option Three: Web Data Administrator (Free!)
You can connect to the SQL server via the URL: or . You will need to specify the MS SQL database username, password and IP address (available in HELM).

Share via
Did you find this article useful?  

Related Articles


Add Comment

Replying to  

Self-Hosted Help Desk Software by SupportPal