Enterprise Manager Logon Failures

Hello,
I have an interesting situation: We have some remote users who connect to a
SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
their machines Accoutn Logon errors are generated in on the SQL server for
the login that they are logged onto their computer with. The registration
for the server specifically uses SQL security to authenticate.
Anybody have any idea why Ent. Manager would be causing this?
Derek
Hi,
Do you want to remove these messages? If yes then just disable the auditing
options in Enterprise manager.
1. Open enterprise manager
2. Select the server you need to disable to auditing
3. Right click and select properties and select "Secury" tab
4. Select the Audit level based on ur requirement
5. Click OK
Did I answer your question?
Thanks
Hari
MCDBA
"Derek" <dg364@.juno.com> wrote in message
news:#$47FNvNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have an interesting situation: We have some remote users who connect to
a
> SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
> their machines Accoutn Logon errors are generated in on the SQL server for
> the login that they are logged onto their computer with. The registration
> for the server specifically uses SQL security to authenticate.
> Anybody have any idea why Ent. Manager would be causing this?
> Derek
>
>
|||It could be the polling of the services from the clients.
You can try turning off the polling on the clients and see
if that makes a difference.
In Enterprise Manager, go to tools then select options.
Clear the checkbox for Server State Polling on the
General tab.
-Sue
On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
wrote:

>Hello,
>I have an interesting situation: We have some remote users who connect to a
>SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
>their machines Accoutn Logon errors are generated in on the SQL server for
>the login that they are logged onto their computer with. The registration
>for the server specifically uses SQL security to authenticate.
>Anybody have any idea why Ent. Manager would be causing this?
>Derek
>
|||Sue,
That did it. Thanks a lot, it was bothering my event logs...
Derek
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.4ax.com... [vbcol=seagreen]
> It could be the polling of the services from the clients.
> You can try turning off the polling on the clients and see
> if that makes a difference.
> In Enterprise Manager, go to tools then select options.
> Clear the checkbox for Server State Polling on the
> General tab.
> -Sue
> On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
> wrote:
to a[vbcol=seagreen]
for[vbcol=seagreen]
registration
>
|||Your welcome Derek and thanks for posting back the results!
-Sue
On Tue, 11 May 2004 12:10:42 -0700, "Derek" <dg364@.juno.com>
wrote:

>Sue,
>That did it. Thanks a lot, it was bothering my event logs...
>Derek
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.4ax.com.. .
>to a
>for
>registration
>

Enterprise Manager Logon Failures

Hello,
I have an interesting situation: We have some remote users who connect to a
SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
their machines Accoutn Logon errors are generated in on the SQL server for
the login that they are logged onto their computer with. The registration
for the server specifically uses SQL security to authenticate.
Anybody have any idea why Ent. Manager would be causing this?
DerekHi,
Do you want to remove these messages? If yes then just disable the auditing
options in Enterprise manager.
1. Open enterprise manager
2. Select the server you need to disable to auditing
3. Right click and select properties and select "Secury" tab
4. Select the Audit level based on ur requirement
5. Click OK
Did I answer your question?
Thanks
Hari
MCDBA
"Derek" <dg364@.juno.com> wrote in message
news:#$47FNvNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have an interesting situation: We have some remote users who connect to
a
> SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
> their machines Accoutn Logon errors are generated in on the SQL server for
> the login that they are logged onto their computer with. The registration
> for the server specifically uses SQL security to authenticate.
> Anybody have any idea why Ent. Manager would be causing this?
> Derek
>
>|||It could be the polling of the services from the clients.
You can try turning off the polling on the clients and see
if that makes a difference.
In Enterprise Manager, go to tools then select options.
Clear the checkbox for Server State Polling on the
General tab.
-Sue
On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
wrote:

>Hello,
>I have an interesting situation: We have some remote users who connect to
a
>SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
>their machines Accoutn Logon errors are generated in on the SQL server for
>the login that they are logged onto their computer with. The registration
>for the server specifically uses SQL security to authenticate.
>Anybody have any idea why Ent. Manager would be causing this?
>Derek
>|||Sue,
That did it. Thanks a lot, it was bothering my event logs...
Derek
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.
4ax.com...
> It could be the polling of the services from the clients.
> You can try turning off the polling on the clients and see
> if that makes a difference.
> In Enterprise Manager, go to tools then select options.
> Clear the checkbox for Server State Polling on the
> General tab.
> -Sue
> On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
> wrote:
>
to a[vbcol=seagreen]
for[vbcol=seagreen]
registration[vbcol=seagreen]
>|||Your welcome Derek and thanks for posting back the results!
-Sue
On Tue, 11 May 2004 12:10:42 -0700, "Derek" <dg364@.juno.com>
wrote:

>Sue,
>That did it. Thanks a lot, it was bothering my event logs...
>Derek
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.
4ax.com...
>to a
>for
>registration
>

Enterprise Manager Logon Failures

Hello,
I have an interesting situation: We have some remote users who connect to a
SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
their machines Accoutn Logon errors are generated in on the SQL server for
the login that they are logged onto their computer with. The registration
for the server specifically uses SQL security to authenticate.
Anybody have any idea why Ent. Manager would be causing this?
DerekHi,
Do you want to remove these messages? If yes then just disable the auditing
options in Enterprise manager.
1. Open enterprise manager
2. Select the server you need to disable to auditing
3. Right click and select properties and select "Secury" tab
4. Select the Audit level based on ur requirement
5. Click OK
Did I answer your question?
Thanks
Hari
MCDBA
"Derek" <dg364@.juno.com> wrote in message
news:#$47FNvNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have an interesting situation: We have some remote users who connect to
a
> SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
> their machines Accoutn Logon errors are generated in on the SQL server for
> the login that they are logged onto their computer with. The registration
> for the server specifically uses SQL security to authenticate.
> Anybody have any idea why Ent. Manager would be causing this?
> Derek
>
>|||It could be the polling of the services from the clients.
You can try turning off the polling on the clients and see
if that makes a difference.
In Enterprise Manager, go to tools then select options.
Clear the checkbox for Server State Polling on the
General tab.
-Sue
On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
wrote:
>Hello,
>I have an interesting situation: We have some remote users who connect to a
>SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
>their machines Accoutn Logon errors are generated in on the SQL server for
>the login that they are logged onto their computer with. The registration
>for the server specifically uses SQL security to authenticate.
>Anybody have any idea why Ent. Manager would be causing this?
>Derek
>|||Sue,
That did it. Thanks a lot, it was bothering my event logs...
Derek
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.4ax.com...
> It could be the polling of the services from the clients.
> You can try turning off the polling on the clients and see
> if that makes a difference.
> In Enterprise Manager, go to tools then select options.
> Clear the checkbox for Server State Polling on the
> General tab.
> -Sue
> On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
> wrote:
> >Hello,
> >
> >I have an interesting situation: We have some remote users who connect
to a
> >SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
> >their machines Accoutn Logon errors are generated in on the SQL server
for
> >the login that they are logged onto their computer with. The
registration
> >for the server specifically uses SQL security to authenticate.
> >
> >Anybody have any idea why Ent. Manager would be causing this?
> >
> >Derek
> >
> >
>|||Your welcome Derek and thanks for posting back the results!
-Sue
On Tue, 11 May 2004 12:10:42 -0700, "Derek" <dg364@.juno.com>
wrote:
>Sue,
>That did it. Thanks a lot, it was bothering my event logs...
>Derek
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.4ax.com...
>> It could be the polling of the services from the clients.
>> You can try turning off the polling on the clients and see
>> if that makes a difference.
>> In Enterprise Manager, go to tools then select options.
>> Clear the checkbox for Server State Polling on the
>> General tab.
>> -Sue
>> On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
>> wrote:
>> >Hello,
>> >
>> >I have an interesting situation: We have some remote users who connect
>to a
>> >SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
>> >their machines Accoutn Logon errors are generated in on the SQL server
>for
>> >the login that they are logged onto their computer with. The
>registration
>> >for the server specifically uses SQL security to authenticate.
>> >
>> >Anybody have any idea why Ent. Manager would be causing this?
>> >
>> >Derek
>> >
>> >
>

Enterprise Manager locks on expanding databases folder

I'm having a very irritating situation occur with
Enterprise Manager.
I expand the databases folder after logging in to our
server and the application goes into 'not responding' mode.
There are about 200 databases to list, so I tried just
putting it in background... for four hours !!!!!
I killed the EM and tried this repeatedly, to no avail.
Does anyone know why this happens and what to do about it?Randy,
Are you on the latest service pack? Assuming its SQL2000, see
FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes
a Long Time
http://support.microsoft.com/default.aspx?scid=kb;en-us;282416
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"randyv" <randy.volters@.whaleyfoodservice.com> wrote in message
news:061001c361d3$4bd83480$a101280a@.phx.gbl...
> I'm having a very irritating situation occur with
> Enterprise Manager.
> I expand the databases folder after logging in to our
> server and the application goes into 'not responding' mode.
> There are about 200 databases to list, so I tried just
> putting it in background... for four hours !!!!!
> I killed the EM and tried this repeatedly, to no avail.
> Does anyone know why this happens and what to do about it?|||> Does anyone know why this happens and what to do about it?
http://www.aspfaq.com/2469