Solved

SQL 2005 Enterprise Manager

Posted on 2007-04-11
4
255 Views
Last Modified: 2011-04-14
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
Comment
Question by:wwlis
  • 2
4 Comments
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 18890663
SQl Server Management Studio is the new tool...and the query environment is built-in.  No more "query analyzer"
0
 

Author Comment

by:wwlis
ID: 18890915
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
 
LVL 16

Accepted Solution

by:
rboyd56 earned 50 total points
ID: 18891782
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
 

Author Comment

by:wwlis
ID: 18893419
I finaly found the place to see the screen I needed. Thanks
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question