since yesterday I have this message everytime I try to open Sql Server
"Enterprise manager"; I reinstalled the outfit completely without success
any solution
thanks
FernandFernand St-Georges wrote:
> Hi,
> since yesterday I have this message everytime I try to open Sql Server
> "Enterprise manager"; I reinstalled the outfit completely without success
> any solution
> thanks
> Fernand
If it's MMC.exe (not MMX.exe) then there's a couple of things to look
at:
1) Can you start MMC.exe separately (through Start -> Run)? If not,
then MMC itself is foobar - it's a built-in part of windows (Microsoft
Management Console), so you'll need to look at repairing windows in
some manner - possible reapplying your last service pack (or deleting
MMC.exe then reapplying the SP)
2) If you can start MMC.exe then it's probably the SQL Server (tools)
install. How thoroughly did you do your reinstall? We're all
directories completely cleared?|||Hi,
I did as you said...the MMC console opens by itself.
To answer your second question, this morning I reinstalled completely SQL
Server, but without deleting the files
do you think I better delete everything?
thanks
"Damien" <Damien_The_Unbeliever@.hotmail.com> a crit dans le message de
news: 1121949111.547383.267750@.g43g2000cwa.googlegroups. com...
> Fernand St-Georges wrote:
>> Hi,
>> since yesterday I have this message everytime I try to open Sql Server
>> "Enterprise manager"; I reinstalled the outfit completely without
>> success
>>
>> any solution
>>
>> thanks
>>
>> Fernand
> If it's MMC.exe (not MMX.exe) then there's a couple of things to look
> at:
> 1) Can you start MMC.exe separately (through Start -> Run)? If not,
> then MMC itself is foobar - it's a built-in part of windows (Microsoft
> Management Console), so you'll need to look at repairing windows in
> some manner - possible reapplying your last service pack (or deleting
> MMC.exe then reapplying the SP)
> 2) If you can start MMC.exe then it's probably the SQL Server (tools)
> install. How thoroughly did you do your reinstall? We're all
> directories completely cleared?|||
thanks for the info...in fact MMC open but not the file related to Sql
Server Enterprise Manager.msc
I did reinstall SQL Server but without clearing the directories at all.
You think I should?
thanks
*** Sent via Developersdex http://www.developersdex.com ***|||Fernand St-Georges wrote:
> thanks for the info...in fact MMC open but not the file related to Sql
> Server Enterprise Manager.msc
> I did reinstall SQL Server but without clearing the directories at all.
> You think I should?
> thanks
> *** Sent via Developersdex http://www.developersdex.com ***
It's worth a try and doesn't cost much time to do - I have a feeling,
since the console is a "management tool", that it may be left behind.
On the other hand, if you deinstall, delete everything, reinstall, and
the problem still recurs, then it is likely to be the settings related
to the console.
I've had a bit of a search, and cannot seem to find any likely settings
- does anyone else here know where EM stores such things as the
registrations, etc? I'm fairly sure that they're stored on a per-user
basis, but I cannot find anything likely in either the registry (HKCU),
nor in the profile directories.
Damien|||Damien wrote:
> does anyone else here know where EM stores such things as the
> registrations, etc? I'm fairly sure that they're stored on a per-user
> basis, but I cannot find anything likely in either the registry (HKCU),
> nor in the profile directories.
The server registration information may be stored in different places,
depending on the configurations from Tools / Options / Server
Registration Information. With the default option (Read/Store locally,
user independent), the location is:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X
Razvan
