Knowledgebase: Databases
Ways to connect to SQL Server from your PC
Posted by Paul Woodland (Import) on 02 December 2006 04:35 AM
With the advent of SQL Server 2005 and higher, it is no longer possible to use the Enterprise Manager that came with SQL Server 2000 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 likley 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 doesnt have the full client. At the time of writing this article, the download could be found here:

We also have a full tutorial on how to connect using it, available in the knowledge base:

Option Three: EMS SQL Manager
This management application is third-part commerical software which you can use to manage your database. There is also a range of companion products which you can purchase to add more functionality. The full range can be found here:
(65 vote(s))
Not helpful

Comments (0)