mystikal1000
asked on
Enterprise manager not working
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.
Are you able to connect to the server in any other way?
Right click the menu item and get properties. Post what is in the Shortcut tab's "target" field.
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\Microso ft SQL Server\80\Tools\Binn
with the original SQL Server Enterprise Manager.MSC file from the installation CD
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\Microso
with the original SQL Server Enterprise Manager.MSC file from the installation CD
ASKER
"C:\Program Files\Microsoft SQL Server\80\Tools\BINN" but its missing and reinstalling doesn't help...
ASKER
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=;d atabase=ma ster
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
driver={sql server};server=7V20231;UID =sa;PWD=;d atabase=ma ster
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
driver={sql server};server=7V20231;UID =sa;PWD=;d atabase=ma ster
[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.e xe -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.e xe -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,1 033,303,0x 0,0x1,0,0, 0
10:13:12 StatsGenerate -1,dp98236)
10:13:12 Installation Failed.
Starting Service ...
SQL_Latin1_General_CP1_CI_
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=7V20231;UID
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
driver={sql server};server=7V20231;UID
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
driver={sql server};server=7V20231;UID
[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.e
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.e
10:13:12 Process Exit Code: (0)
10:13:12 StatsGenerate returned: 2
10:13:12 StatsGenerate (0x0,0x1,0xf000000,0x300,1
10:13:12 StatsGenerate -1,dp98236)
10:13:12 Installation Failed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Should I uninstall sql server before installing MDAC?
if that's possible