468,278 Members | 1,582 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,278 developers. It's quick & easy.

sql client in sql server 2005

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

May 30 '06 #1
2 2100
nitin (ni*******@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, es****@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
May 30 '06 #2
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
May 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by Michael Rybak | last post: by
4 posts views Thread by Sharon | last post: by
1 post views Thread by Phil Townsend | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
1 post views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.