Post reply

Where is my SQL Server Enterprise Manager?

  • August 4, 2002 at 10:20 am

    #63949

    Hello!

    Please help me or my head will explode soon! I can't find Enterprise Manager anywhere! I'm running SQL7 and I've downloaded service pack 1 and 4 from the Microsoft site. I've re-installed MSDE two times now. I found out that the Enterprise Manager is a snap-in to MMC and the file (Sql Server Enterprise Manager.msc) should be located in C:\MSSQL7\Binn but it isn't! I read some stuff from the help file and it said that by default the Enterprise Manager is installed to all 32bit environmens... Well, isn't Win2k 32 bits? Why doesn't it install it?

    I'm getting really frustrated. PLEASE help!

    /Tomi

  • August 4, 2002 at 11:01 am

    #433964

    If you put in the SQL 7 CD, you have the option to install the client tools.

    Enterprise Manager itself is actually a .msc file that requires MMC. For SQL 2K client tools, the default shortcut is:

    C:\WINNT\system32\mmc.exe /s "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"

    I'm guessing that under SQL Server 7 the default path for the MSC file is C:\MSSQL7\Binn\ and if you look for a .MSC file there, you'll probably hit upon it.

    HTH.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • August 4, 2002 at 11:21 am

    #433965

    Thanks Brian!

    But the thing is, there isn't a single .msc file in my MSSQL folder! This is a quote from http://www.microsoft.com/sql/downloads/sp1.asp:

    This download provides updates for the database components of a SQL Server 7.0 or MSDE 1.0, including:

    -The data engine

    -Database client utilities, such as SQL Server Enterprise Manager and osql (SQL Server 7.0 only)

    I don't get it! I searched my whole machine for the .msc file and couldn't find it. And the updater program doesn't warn me or anything for not installing Enterprise Manager.

    Oh, and I don't have the SQL7 CD. Once I've installed MSDE from the Office2000 CD and once I've downloaded MSDE from the Microsoft site.

    Any suggestions appreciated!

    /Tomi

  • August 4, 2002 at 3:09 pm

    #433968

    If I remember right, MSDE doesn't come with the SQL Server Enterprise Manager. I believe we installed Office Server Extensions to give 'em a run and of course it dropped an MSDE on the system (which we subsequently repointed), but no Enterprise Manager.

    SP1 will update Enterprise Manager, but only if it is already there.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • August 4, 2002 at 3:39 pm

    #433970

    Thanks again!

    I got your point but there is one thing tho. I got SQL Query Analyzer with SP1 and many other things too! (but no Enterprise Manager) But still, isn't Enterprise Manager a free-ware of some sort? Why isn't it downloadable on the net? I bet just copying the .msc wouldn't work, or would it?

    /Tomi

  • August 4, 2002 at 5:37 pm

    #433972

    Enterprise Manager and Query Analyzer are both part of the client tools for SQL Server. I'm not up to spec on what typically comes with MSDE, as we don't use it where I work since we have quite a few SQL Server 7.0 and 2000 installs at our disposal. Perhaps QA comes because it doesn't have automated facilities for installing replication and other features which are part of the SQL Server but are not included in MSDE.

    One thing you can do is grab an eval copy of SQL Server 2000 and use the client tools for the duration of the evaluation period (currently 120 days). The client tools are licensed along with the server. So if you have a licensed version of SQL Server, you can use the client tools to manage MSDE as well.

    The link to obtain an evaluation version is:

    http://www.microsoft.com/sql/evaluation/trial/default.asp

    You can either download it (free) or have it sent to you on CD (pay for shipping and handling plus a media fee of US$ 7.95).

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • August 4, 2002 at 11:31 pm

    #433978

    Thank you! I'll try that!

    /Tomi

  • August 5, 2002 at 3:52 am

    #433988

    IT WORKED!

    I didn't even install the Sql2000 server just the tools! It worked immediately.

    THANKS A LOT!

    /Tomi

  • August 5, 2002 at 7:00 am

    #433992

    You are welcome. Glad to be of help.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply