[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

SQL 2005 Enterprise Manager

I had setup a new SQL 2005 server. In SQL 2000 there is a program Enterprise Manger that lists all the databaes, data transformation services... I can not find this opton in SQL 2005. Does any one know how to get this scrren in SQL 2005
0
wwlis
Asked:
wwlis
  • 2
1 Solution
 
Kevin3NFCommented:
SQl Server Management Studio is the new tool...and the query environment is built-in.  No more "query analyzer"
0
 
wwlisAuthor Commented:
I have been in the program. I can connect to only to the Integrateion Service on the SQl 2005. When I connect to one of the SQL 2000 servers I can see all the database. When I select Connect to server and Database Engine my new server is not lsited.
0
 
rboyd56Commented:
Have you enabled named pipes and TCP/IP for this instance of SQL Server 2005. By default they are turned off. You can do this using the SQL Server Surface Area Configuration or SQL Server Configuration Manager utilities.
0
 
wwlisAuthor Commented:
I finaly found the place to see the screen I needed. Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now