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 loading DB

Hello
I have a problem with a loading DB in Enterprise Manager.
I had restored a DB from another Sql Server and something seems wrong. I´ve
got no error message but I have a grey DB Icon with my DB Name and a loading
behind the name. I can´t delete the DB with Enterprise manager, can´t open
the properties nothing.
I have tried in Sql Query analyzer to drop the database, but I´ve got an
error that the db can´t be deleted because an use for replication exist.
On the Sql Server where I have restored the DB is no replication configured
only on the sql server where the backup was made.
Any idea how to remove the DB?
(Sql Server 2000 sp3)
Thx
BjörnPerhaps the restore was done using NORECOVERY option? Try:
RESTORE DATABASE dbname WITH RECOVERY
That would make the database accessible. Then drop the database, possibly removing replication
config first if needed (Google for details...).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Björn" <prodevelop@.gmx.net> wrote in message news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...
> Hello
> I have a problem with a loading DB in Enterprise Manager.
> I had restored a DB from another Sql Server and something seems wrong. I´ve
> got no error message but I have a grey DB Icon with my DB Name and a loading
> behind the name. I can´t delete the DB with Enterprise manager, can´t open
> the properties nothing.
> I have tried in Sql Query analyzer to drop the database, but I´ve got an
> error that the db can´t be deleted because an use for replication exist.
> On the Sql Server where I have restored the DB is no replication configured
> only on the sql server where the backup was made.
> Any idea how to remove the DB?
> (Sql Server 2000 sp3)
> Thx
> Björn
>|||Hi,
Add on to Tibor; You could also try
RESTORE LOG dbname WITH RECOVERY
Thanks
Hari
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ehrzeNsyGHA.4976@.TK2MSFTNGP04.phx.gbl...
> Perhaps the restore was done using NORECOVERY option? Try:
> RESTORE DATABASE dbname WITH RECOVERY
> That would make the database accessible. Then drop the database, possibly
> removing replication config first if needed (Google for details...).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Björn" <prodevelop@.gmx.net> wrote in message
> news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...
>> Hello
>> I have a problem with a loading DB in Enterprise Manager.
>> I had restored a DB from another Sql Server and something seems wrong.
>> I´ve
>> got no error message but I have a grey DB Icon with my DB Name and a
>> loading
>> behind the name. I can´t delete the DB with Enterprise manager, can´t
>> open
>> the properties nothing.
>> I have tried in Sql Query analyzer to drop the database, but I´ve got an
>> error that the db can´t be deleted because an use for replication exist.
>> On the Sql Server where I have restored the DB is no replication
>> configured
>> only on the sql server where the backup was made.
>> Any idea how to remove the DB?
>> (Sql Server 2000 sp3)
>> Thx
>> Björn
>>
>|||Hi
Thx for your answer
Now the DB is deleted:)
regards
Björn
"Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:#tECW2wyGHA.3568@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Add on to Tibor; You could also try
> RESTORE LOG dbname WITH RECOVERY
> Thanks
> Hari
> SQL Server MVP
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ehrzeNsyGHA.4976@.TK2MSFTNGP04.phx.gbl...
> > Perhaps the restore was done using NORECOVERY option? Try:
> >
> > RESTORE DATABASE dbname WITH RECOVERY
> >
> > That would make the database accessible. Then drop the database,
possibly
> > removing replication config first if needed (Google for details...).
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Björn" <prodevelop@.gmx.net> wrote in message
> > news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...
> >> Hello
> >>
> >> I have a problem with a loading DB in Enterprise Manager.
> >> I had restored a DB from another Sql Server and something seems wrong.
> >> I´ve
> >> got no error message but I have a grey DB Icon with my DB Name and a
> >> loading
> >> behind the name. I can´t delete the DB with Enterprise manager, can´t
> >> open
> >> the properties nothing.
> >> I have tried in Sql Query analyzer to drop the database, but I´ve got
an
> >> error that the db can´t be deleted because an use for replication
exist.
> >> On the Sql Server where I have restored the DB is no replication
> >> configured
> >> only on the sql server where the backup was made.
> >> Any idea how to remove the DB?
> >> (Sql Server 2000 sp3)
> >>
> >> Thx
> >>
> >> Björn
> >>
> >>
> >
>

enterprise manager loading DB

Hello
I have a problem with a loading DB in Enterprise Manager.
I had restored a DB from another Sql Server and something seems wrong. Ive
got no error message but I have a grey DB Icon with my DB Name and a loading
behind the name. I cant delete the DB with Enterprise manager, cant open
the properties nothing.
I have tried in Sql Query analyzer to drop the database, but Ive got an
error that the db cant be deleted because an use for replication exist.
On the Sql Server where I have restored the DB is no replication configured
only on the sql server where the backup was made.
Any idea how to remove the DB?
(Sql Server 2000 sp3)
Thx
BjrnPerhaps the restore was done using NORECOVERY option? Try:
RESTORE DATABASE dbname WITH RECOVERY
That would make the database accessible. Then drop the database, possibly re
moving replication
config first if needed (Google for details...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bjrn" <prodevelop@.gmx.net> wrote in message news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...[
vbcol=seagreen]
> Hello
> I have a problem with a loading DB in Enterprise Manager.
> I had restored a DB from another Sql Server and something seems wrong. Iv
e
> got no error message but I have a grey DB Icon with my DB Name and a loadi
ng
> behind the name. I cant delete the DB with Enterprise manager, cant open
> the properties nothing.
> I have tried in Sql Query analyzer to drop the database, but Ive got an
> error that the db cant be deleted because an use for replication exist.
> On the Sql Server where I have restored the DB is no replication configure
d
> only on the sql server where the backup was made.
> Any idea how to remove the DB?
> (Sql Server 2000 sp3)
> Thx
> Bjrn
>[/vbcol]|||Hi,
Add on to Tibor; You could also try
RESTORE LOG dbname WITH RECOVERY
Thanks
Hari
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ehrzeNsyGHA.4976@.TK2MSFTNGP04.phx.gbl...
> Perhaps the restore was done using NORECOVERY option? Try:
> RESTORE DATABASE dbname WITH RECOVERY
> That would make the database accessible. Then drop the database, possibly
> removing replication config first if needed (Google for details...).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Bjrn" <prodevelop@.gmx.net> wrote in message
> news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...
>|||Hi
Thx for your answer
Now the DB is deleted
regards
Bjrn
"Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:#tECW2wyGHA.3568@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Add on to Tibor; You could also try
> RESTORE LOG dbname WITH RECOVERY
> Thanks
> Hari
> SQL Server MVP
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ehrzeNsyGHA.4976@.TK2MSFTNGP04.phx.gbl...
possibly[vbcol=seagreen]
an[vbcol=seagreen]
exist.[vbcol=seagreen]
>

Enterprise manager loading databases

Hi,

I'm on a shared MS SQL server, and I have access on 2 databases there.
On the server there are many other database, I guess around 170.
When I want to access my database I open enterprise manager choose the server from the server list and click on "databases" to list all databases. This last step (listing all databases) takes ages to complete, it takes something like 3 minutes to show all databases so I can click my database from the list and do my thing.

Isn't there any way to only view my own databases and not showing the others. I can't access the others so there's really no point in showing them anyway, it only takes time.

anyone?

Enterprise Manager HANGS

For some strange reason we cannot connect to both our databases and
Enterprise manger hangs when we try loading it? anyone have any ideas?
___________________________
Giacomo
Hi,
2 reasons may be the cause:-
1. See if Autoclose option is enabled for the database. If it is enabled
then disable the database option. This option will close the database once
the last user logs off. So while connecting back it open the database back
again and take some time
2. This can be slow if you have more backup history. So delete the history
using:-
sp_delete_database_backuphistoXry (see books online)
Thanks
Hari
SQL Server MVP
"Giacomo" <gdagostino@.vision2000.ca> wrote in message
news:13AAF4E3-DF25-4839-B241-A573BA966E34@.microsoft.com...
> For some strange reason we cannot connect to both our databases and
> Enterprise manger hangs when we try loading it? anyone have any ideas?
> --
>
> ___________________________
> Giacomo
|||Giacomo
There was a problem like this with the early version of SQL Server 2000.
What service pack are you on? Have a look at this article, it may be your
problem.
http://support.microsoft.com/default...b;en-us;282416
Hope this helps
John
"Hari Prasad" wrote:

> Hi,
> 2 reasons may be the cause:-
> 1. See if Autoclose option is enabled for the database. If it is enabled
> then disable the database option. This option will close the database once
> the last user logs off. So while connecting back it open the database back
> again and take some time
> 2. This can be slow if you have more backup history. So delete the history
> using:-
> sp_delete_database_backuphistoXry (see books online)
> Thanks
> Hari
> SQL Server MVP
>
>
> "Giacomo" <gdagostino@.vision2000.ca> wrote in message
> news:13AAF4E3-DF25-4839-B241-A573BA966E34@.microsoft.com...
>
>

Enterprise Manager HANGS

For some strange reason we cannot connect to both our databases and
Enterprise manger hangs when we try loading it? anyone have any ideas?
--
___________________________
GiacomoHi,
2 reasons may be the cause:-
1. See if Autoclose option is enabled for the database. If it is enabled
then disable the database option. This option will close the database once
the last user logs off. So while connecting back it open the database back
again and take some time
2. This can be slow if you have more backup history. So delete the history
using:-
sp_delete_database_backuphisto_ry (see books online)
Thanks
Hari
SQL Server MVP
"Giacomo" <gdagostino@.vision2000.ca> wrote in message
news:13AAF4E3-DF25-4839-B241-A573BA966E34@.microsoft.com...
> For some strange reason we cannot connect to both our databases and
> Enterprise manger hangs when we try loading it? anyone have any ideas?
> --
>
> ___________________________
> Giacomo|||Giacomo
There was a problem like this with the early version of SQL Server 2000.
What service pack are you on? Have a look at this article, it may be your
problem.
http://support.microsoft.com/defaul...kb;en-us;282416
Hope this helps
John
"Hari Prasad" wrote:

> Hi,
> 2 reasons may be the cause:-
> 1. See if Autoclose option is enabled for the database. If it is enabled
> then disable the database option. This option will close the database once
> the last user logs off. So while connecting back it open the database back
> again and take some time
> 2. This can be slow if you have more backup history. So delete the history
> using:-
> sp_delete_database_backuphisto_ry (see books online)
> Thanks
> Hari
> SQL Server MVP
>
>
> "Giacomo" <gdagostino@.vision2000.ca> wrote in message
> news:13AAF4E3-DF25-4839-B241-A573BA966E34@.microsoft.com...
>
>

Enterprise Manager HANGS

For some strange reason we cannot connect to both our databases and
Enterprise manger hangs when we try loading it? anyone have any ideas?
--
___________________________
GiacomoHi,
2 reasons may be the cause:-
1. See if Autoclose option is enabled for the database. If it is enabled
then disable the database option. This option will close the database once
the last user logs off. So while connecting back it open the database back
again and take some time
2. This can be slow if you have more backup history. So delete the history
using:-
sp_delete_database_backuphisto­ry (see books online)
Thanks
Hari
SQL Server MVP
"Giacomo" <gdagostino@.vision2000.ca> wrote in message
news:13AAF4E3-DF25-4839-B241-A573BA966E34@.microsoft.com...
> For some strange reason we cannot connect to both our databases and
> Enterprise manger hangs when we try loading it? anyone have any ideas?
> --
>
> ___________________________
> Giacomo|||Giacomo
There was a problem like this with the early version of SQL Server 2000.
What service pack are you on? Have a look at this article, it may be your
problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;282416
Hope this helps
John
"Hari Prasad" wrote:
> Hi,
> 2 reasons may be the cause:-
> 1. See if Autoclose option is enabled for the database. If it is enabled
> then disable the database option. This option will close the database once
> the last user logs off. So while connecting back it open the database back
> again and take some time
> 2. This can be slow if you have more backup history. So delete the history
> using:-
> sp_delete_database_backuphisto­ry (see books online)
> Thanks
> Hari
> SQL Server MVP
>
>
> "Giacomo" <gdagostino@.vision2000.ca> wrote in message
> news:13AAF4E3-DF25-4839-B241-A573BA966E34@.microsoft.com...
> > For some strange reason we cannot connect to both our databases and
> > Enterprise manger hangs when we try loading it? anyone have any ideas?
> > --
> >
> >
> >
> > ___________________________
> > Giacomo
>
>