|
|
Posted by Erland Sommarskog on 05/30/06 21:26
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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|