471,046 Members | 1,157 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,046 software developers and data experts.

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 2181
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.