Enterprise Mgr Error

Good Day
SQL 2000 - just started recieving the following when loading Enterprise
Manager directly on the server console (from a workstation is fine)
'Connection to application failed. Ensure that no program modules have
been deleted'
I tried re-installing both OS & SQL service packs to see if a DLL or
something was missing - but am still receiving the error - any ideas ?
Thanks!
Hi
Can you open MMC and other add-ins without getting this error?
Can you open SQL Server Enterprise Manager.msc from within MMC?
John
"ERoss" wrote:

> Good Day
> SQL 2000 - just started recieving the following when loading Enterprise
> Manager directly on the server console (from a workstation is fine)
> 'Connection to application failed. Ensure that no program modules have
> been deleted'
> I tried re-installing both OS & SQL service packs to see if a DLL or
> something was missing - but am still receiving the error - any ideas ?
> Thanks!
>
|||In article <818FA874-C913-4C1C-93FB-3B62B00E0770@.microsoft.com>,
jbellnewsposts@.hotmail.com says...[vbcol=seagreen]
> Hi
> Can you open MMC and other add-ins without getting this error?
> Can you open SQL Server Enterprise Manager.msc from within MMC?
> John
> "ERoss" wrote:
Good Point & thanks -
MMC.exe runs OK - I added various snapins - all worked successfully -
tried to add enterprise manager.msc - it blows withthe same error
Thanks
|||Hi
You don't say what service pack you are on!
But you could try renaming the MMC and loading the renamed file (which seems
to sometimes work!), renaming the MMC file and installing a service pack, or
copy the MMC from another machine that is on the same fix level.
John
"ERoss" wrote:

> In article <818FA874-C913-4C1C-93FB-3B62B00E0770@.microsoft.com>,
> jbellnewsposts@.hotmail.com says...
> Good Point & thanks -
> MMC.exe runs OK - I added various snapins - all worked successfully -
> tried to add enterprise manager.msc - it blows withthe same error
> Thanks
>
|||In article <CD313813-AB93-40D6-90A4-8BF3DB4682F5@.microsoft.com>,
jbellnewsposts@.hotmail.com says...
SQL is SP4 -
I had re-applied that service pack -
But I will retry after renaming the enterprise manager.msc file
Thanks!

> Hi
> You don't say what service pack you are on!
> But you could try renaming the MMC and loading the renamed file (which seems
> to sometimes work!), renaming the MMC file and installing a service pack, or
> copy the MMC from another machine that is on the same fix level.
> John
>

Enterprise Mgr Error

Good Day
SQL 2000 - just started recieving the following when loading Enterprise
Manager directly on the server console (from a workstation is fine)
'Connection to application failed. Ensure that no program modules have
been deleted'
I tried re-installing both OS & SQL service packs to see if a DLL or
something was missing - but am still receiving the error - any ideas ?
Thanks!Hi
Can you open MMC and other add-ins without getting this error?
Can you open SQL Server Enterprise Manager.msc from within MMC?
John
"ERoss" wrote:
> Good Day
> SQL 2000 - just started recieving the following when loading Enterprise
> Manager directly on the server console (from a workstation is fine)
> 'Connection to application failed. Ensure that no program modules have
> been deleted'
> I tried re-installing both OS & SQL service packs to see if a DLL or
> something was missing - but am still receiving the error - any ideas ?
> Thanks!
>|||In article <818FA874-C913-4C1C-93FB-3B62B00E0770@.microsoft.com>,
jbellnewsposts@.hotmail.com says...
> Hi
> Can you open MMC and other add-ins without getting this error?
> Can you open SQL Server Enterprise Manager.msc from within MMC?
> John
> "ERoss" wrote:
> > Good Day
> >
> > SQL 2000 - just started recieving the following when loading Enterprise
> > Manager directly on the server console (from a workstation is fine)
> >
> > 'Connection to application failed. Ensure that no program modules have
> > been deleted'
> >
> > I tried re-installing both OS & SQL service packs to see if a DLL or
> > something was missing - but am still receiving the error - any ideas ?
> >
> > Thanks!
> >
Good Point & thanks -
MMC.exe runs OK - I added various snapins - all worked successfully -
tried to add enterprise manager.msc - it blows withthe same error
Thanks|||Hi
You don't say what service pack you are on!
But you could try renaming the MMC and loading the renamed file (which seems
to sometimes work!), renaming the MMC file and installing a service pack, or
copy the MMC from another machine that is on the same fix level.
John
"ERoss" wrote:
> In article <818FA874-C913-4C1C-93FB-3B62B00E0770@.microsoft.com>,
> jbellnewsposts@.hotmail.com says...
> > Hi
> >
> > Can you open MMC and other add-ins without getting this error?
> >
> > Can you open SQL Server Enterprise Manager.msc from within MMC?
> >
> > John
> >
> > "ERoss" wrote:
> >
> > > Good Day
> > >
> > > SQL 2000 - just started recieving the following when loading Enterprise
> > > Manager directly on the server console (from a workstation is fine)
> > >
> > > 'Connection to application failed. Ensure that no program modules have
> > > been deleted'
> > >
> > > I tried re-installing both OS & SQL service packs to see if a DLL or
> > > something was missing - but am still receiving the error - any ideas ?
> > >
> > > Thanks!
> > >
> Good Point & thanks -
> MMC.exe runs OK - I added various snapins - all worked successfully -
> tried to add enterprise manager.msc - it blows withthe same error
> Thanks
>|||In article <CD313813-AB93-40D6-90A4-8BF3DB4682F5@.microsoft.com>,
jbellnewsposts@.hotmail.com says...
SQL is SP4 -
I had re-applied that service pack -
But I will retry after renaming the enterprise manager.msc file
Thanks!
> Hi
> You don't say what service pack you are on!
> But you could try renaming the MMC and loading the renamed file (which seems
> to sometimes work!), renaming the MMC file and installing a service pack, or
> copy the MMC from another machine that is on the same fix level.
> John
>

Enterprise Manager Won't Run

I am unable to start my Enterprise Manager. I get the following error message:
"Microsoft Management Console has encountered a problem and needs to close".
This is a SQL 2000 system.
This happened one day for no apparent reason. I use SQL Enterprise Manager
everyday. I have uninstalled and reinstalled the product and have the same
problem.
Help is appreciated. Thanks.
Hi
Have you tried to run MMC on it's own and then open up the SQL Server
Enterprise Manager MMC?
John
"john" <john@.discussions.microsoft.com> wrote in message
news:4AA5174A-D9C1-4FA1-979C-3DAC67521A14@.microsoft.com...
>I am unable to start my Enterprise Manager. I get the following error
>message:
> "Microsoft Management Console has encountered a problem and needs to
> close".
> This is a SQL 2000 system.
> This happened one day for no apparent reason. I use SQL Enterprise Manager
> everyday. I have uninstalled and reinstalled the product and have the same
> problem.
> Help is appreciated. Thanks.
|||Yes, I can start say Computer Management which uses the MMC and it opens just
fine. I can leave it open and then try to start the Enterprise Manaer and i
get the same problem. I am not sure if they use the same version of the MMC
or not.
"John Bell" wrote:

> Hi
> Have you tried to run MMC on it's own and then open up the SQL Server
> Enterprise Manager MMC?
> John
> "john" <john@.discussions.microsoft.com> wrote in message
> news:4AA5174A-D9C1-4FA1-979C-3DAC67521A14@.microsoft.com...
>
>
|||Hi
You can therefore try and open the SQL Server Enterprise Manager.mmc from
the tools (or the tools/html) directory.
You could try copying the file from another machine and possibly renaming
it, if it continues to cause an issue.
John
"john" <john@.discussions.microsoft.com> wrote in message
news:C9132729-931C-488D-9F96-63AB177CA33D@.microsoft.com...[vbcol=seagreen]
> Yes, I can start say Computer Management which uses the MMC and it opens
> just
> fine. I can leave it open and then try to start the Enterprise Manaer and
> i
> get the same problem. I am not sure if they use the same version of the
> MMC
> or not.
>
> "John Bell" wrote:
|||I tried copying the MMC from another computer that can run enterprise Manager
and i had the same problem. Then I renamed it as you siuggested and now it
will run. That seems so strange. Any ideas why this works?
thanks for your help
john
"John Bell" wrote:

> Hi
> You can therefore try and open the SQL Server Enterprise Manager.mmc from
> the tools (or the tools/html) directory.
> You could try copying the file from another machine and possibly renaming
> it, if it continues to cause an issue.
> John
> "john" <john@.discussions.microsoft.com> wrote in message
> news:C9132729-931C-488D-9F96-63AB177CA33D@.microsoft.com...
>
>
|||Did you try to register a custom MMC ? Open Managment Console, File
Add/Remove Snappin, Add , SQL Server Enterprise Manager
Save the Console under a known destination path, try to open it from
this msc file.
Would be interesting if the problems occurs after creating this custom
console.
HTH, jens Suessmeyer.

Enterprise Manager Showing Wrong Authentication Mechanism

This is strange,
SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
into the server or I look on the console locally, it shows it as only being
Windows Authentication...
Anyone know of this bug? And how to fix?How do you know it's set to mixed mode? Did you try logging
in with a SQL login?
If you are just looking at a registry setting, it's possible
the service was not restarted to allow the server to be set
to mixed mode.
-Sue
On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
<Chuck@.discussions.microsoft.com> wrote:

>This is strange,
>SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
>into the server or I look on the console locally, it shows it as only being
>Windows Authentication...
>Anyone know of this bug? And how to fix?|||Yes, I am currently logging in as an SQL login account. This client of mine
does not use Windows authentication...
"Sue Hoegemeier" wrote:

> How do you know it's set to mixed mode? Did you try logging
> in with a SQL login?
> If you are just looking at a registry setting, it's possible
> the service was not restarted to allow the server to be set
> to mixed mode.
> -Sue
> On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
> <Chuck@.discussions.microsoft.com> wrote:
>
>|||_-=?/today_-=?/354
"Chuck" wrote:

> This is strange,
> SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
> into the server or I look on the console locally, it shows it as only bein
g
> Windows Authentication...
> Anyone know of this bug? And how to fix?|||_-=?/today_-=?/354
"Chuck" wrote:
[vbcol=seagreen]
> Yes, I am currently logging in as an SQL login account. This client of mi
ne
> does not use Windows authentication...
> "Sue Hoegemeier" wrote:
>

Enterprise manager fails to start

When I try to run SQL Server Enterprise Mgr, but each time, it just fails to start and I get the error box:
Microsoft Management Console has encountered a problem and needs to close. We are sorry for the inconvenience.
You can look at the data before it sends it to MS, but it really doesn't help much. Some of the info is:
AppName: mmc.exe AppVer: 5.1.2600.2180 ModName: mmc.exe
ModVer: 5.1.2600.2180 Offset: 0001f07e
I have uninstalled and reinstalled, but nothing helps. The MMC runs on several other snap ins, including Computer Mgmt and then looking at SQL Server, but the problem is that I need to view some remote SQL Servers.
--
Joel Z
Maybe the snap-in has become corrupt or damaged.
Try renaming the existing SQL Server Enterprise Manager.MSC
file.
Then copy the SQL Server Enterprise Manager.MSC file from
the your SQL Server CD to the same location.
-Sue
On Wed, 2 Mar 2005 19:24:52 -0600, "Joel Zinn"
<Joelz@.zinn-4.com> wrote:

>When I try to run SQL Server Enterprise Mgr, but each time, it just fails to start and I get the error box:
>Microsoft Management Console has encountered a problem and needs to close. We are sorry for the inconvenience.
>You can look at the data before it sends it to MS, but it really doesn't help much. Some of the info is:
>AppName: mmc.exe AppVer: 5.1.2600.2180 ModName: mmc.exe
>ModVer: 5.1.2600.2180 Offset: 0001f07e
>
>I have uninstalled and reinstalled, but nothing helps. The MMC runs on several other snap ins, including Computer Mgmt and then looking at SQL Server, but the problem is that I need to view some remote SQL Servers.
|||In addition to Sue's advice, you could try reinstalling the MMC, scroll down this page for the MMC 1.2 download. http://www.microsoft.com/windows2000...anagement/mmc/
Steve
"Joel Zinn" <Joelz@.zinn-4.com> wrote in message news:uqiWO$4HFHA.3844@.TK2MSFTNGP14.phx.gbl...
When I try to run SQL Server Enterprise Mgr, but each time, it just fails to start and I get the error box:
Microsoft Management Console has encountered a problem and needs to close. We are sorry for the inconvenience.
You can look at the data before it sends it to MS, but it really doesn't help much. Some of the info is:
AppName: mmc.exe AppVer: 5.1.2600.2180 ModName: mmc.exe
ModVer: 5.1.2600.2180 Offset: 0001f07e
I have uninstalled and reinstalled, but nothing helps. The MMC runs on several other snap ins, including Computer Mgmt and then looking at SQL Server, but the problem is that I need to view some remote SQL Servers.
--
Joel Z
|||I have recently encountered this same error and I was able to fix it. It happens to be an error with the MMC application data file for enterprise manager in your user profile.
From windows explorer, browse to the "MMC" folder under C:\Documents and Settings\[user_profile]\Applicaiton Data\Microsoft\ (This is a hidden folder and to be able to view it you must show hidden files and folders in the "Tools" --> "Folder Options" --> "View" settings). There should be a file named "SQL Server Enterprise Manager". You can either delete or rename this file (I prefer the latter). MMC will re-create this file the next time you access Enterprise Manager and should then be working properly.
j.