?
Solved

Enterprise manager not working

Posted on 2004-09-17
8
Medium Priority
?
235 Views
Last Modified: 2013-12-03
I click on the Enterprise Manager on the start menu >> programs >>MS SQL >> Enterprise Manager and I receive this message "MMC cannot open the selected file"  Any ideas on how to fix this, I reinstalled the tool and I receive the same message.

0
Comment
Question by:mystikal1000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 12088673
Are you able to connect to the server in any other way?
0
 
LVL 21

Expert Comment

by:mastoo
ID: 12088712
Right click the menu item and get properties.  Post what is in the Shortcut tab's "target" field.
0
 
LVL 44

Expert Comment

by:bruintje
ID: 12088732
what changed when this started?

did you uninstall sql server 2000? then this may apply
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q272453

or the file is just corrupt, you installed again but what if you try

to replace your existing file > SQL Server Enterprise Manager.MSC
should be located at  > YourSQLInstallPath\Microsoft SQL Server\80\Tools\Binn
with the original  SQL Server Enterprise Manager.MSC file from the installation CD
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 1

Author Comment

by:mystikal1000
ID: 12088784
"C:\Program Files\Microsoft SQL Server\80\Tools\BINN" but its missing and reinstalling doesn't help...
0
 
LVL 1

Author Comment

by:mystikal1000
ID: 12088791
Here is the installation log file...


Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=7V20231;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

driver={sql server};server=7V20231;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

driver={sql server};server=7V20231;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

SQL Server configuration failed.

###############################################################################

10:11:45 Process Exit Code: (-1)
10:13:11 Setup failed to configure the server.   Refer to the server error logs and C:\WINNT\sqlstp.log for more information.
10:13:11 Action CleanUpInstall:
10:13:11 C:\TEMP\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4 -Service SQLSERVERAGENT
10:13:11 Process Exit Code: (1060) The specified service does not exist as an installed service.

10:13:11 C:\TEMP\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4 -Service MSSQLSERVER
10:13:12 Process Exit Code: (0)
10:13:12 StatsGenerate returned: 2
10:13:12 StatsGenerate (0x0,0x1,0xf000000,0x300,1033,303,0x0,0x1,0,0,0
10:13:12 StatsGenerate -1,dp98236)
10:13:12 Installation Failed.
0
 
LVL 44

Accepted Solution

by:
bruintje earned 2000 total points
ID: 12088825
source : http://groups.google.com/groups?selm=%23GL56wc2CHA.2332%40TK2MSFTNGP10.phx.gbl&output=gplain

relevant part
-------------
This is usually due to a problem with the SQL ODBC driver (C:\WINNT\sqlsrv32.dll).
Try installing MDAC first, reboot and then installing SQL Server.
You can download the latest version of MDAC from
www.microsoft.com/data 
or you can run sqlerdis.exe which is found on your install CD in \X86\OTHER
-------------
0
 
LVL 1

Author Comment

by:mystikal1000
ID: 12088902
Should I uninstall sql server before installing MDAC?
0
 
LVL 44

Expert Comment

by:bruintje
ID: 12090749
if that's possible
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

649 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