HI all
Gurus i am struck up in sql 2005.I am new to sql 2005.I have my server
installed on one machine.Now what do i download so that i am able to
register it.
Now i want to connect to that machine thru enterprise manager or client
like we do in sql server 2000 thru query analyzer..
Will sql 2005 express help.?
Please help
Regards

nitin (nitin1353@gmail.com) writes:
> Gurus i am struck up in sql 2005.I am new to sql 2005.I have my server
> installed on one machine.Now what do i download so that i am able to
> register it.
> Now i want to connect to that machine thru enterprise manager or client
> like we do in sql server 2000 thru query analyzer..

You cannot connect to SQL Server 2005 from Enterprise Manager. You cannot
connect from Query Analyzer to SQL 2005, although some features does not
work. But for running queries it works just fine!

In SQL 2005 EM and QA has been replaced ny SQL Server Management Studio.
This tool comes with all editions of SQL 2005, except for SQL Express.
So if you installed SQL 2005 Developer Editions (for instance), you
should have the tools there. It may be on a second CD or in a Tools
directory. (But as a tip: keep you Query Analyzer! Not everything is
better in the new tool.)

If you have SQL Express, you can download the Express version of
Management Studio from http://msdn.microsoft.com/sql/express/.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On 30 May 2006 09:38:18 -0700, nitin wrote:

>HI all
>Gurus i am struck up in sql 2005.I am new to sql 2005.I have my server
>installed on one machine.Now what do i download so that i am able to
>register it.
>Now i want to connect to that machine thru enterprise manager or client
>like we do in sql server 2000 thru query analyzer..
>Will sql 2005 express help.?
>Please help
>Regards

Hi Nitin,

Install the client tools if yoou haven't already done so. Then, click
Start / All Programs / Microsoft SQL Server 2005 / SQL Server Management
Studio.

Management Studio is the replacement for both Query Analyzer and
Enterprise Manager.

--
Hugo Kornelis, SQL Server MVP