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
>
Showing posts with label remotely. Show all posts
Showing posts with label remotely. Show all posts
Sunday, March 11, 2012
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
>
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
>
Friday, March 9, 2012
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
>> >
>> >
>
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
>> >
>> >
>
Friday, February 24, 2012
Enterprise Manager causing lockout of user account on server
When I connect to the SQL Server remotely via enterprise manager as SA my
user account on the server ends up being locked out. Currently my work around
is to log on to the server via terminal service then run enterprise manager
from my terminal service session. I have no problems with my account
accessing enterprise manager through that method. I must point out that I
successfully connect as SA when I run enterprise manager on my desktop. Any
suggest would be most helpful.
I'm not sure how you are logging in on your desktop but it
could be related to the polling of the servers from
Enterprise Manager so you can try turning that off. In
Enterprise Manager, go to the menu to Tools, select Options.
On the General Tab, remove the check for Server State
Polling.
-Sue
On Wed, 2 Mar 2005 05:47:02 -0800, "James"
<James@.discussions.microsoft.com> wrote:
>When I connect to the SQL Server remotely via enterprise manager as SA my
>user account on the server ends up being locked out. Currently my work around
>is to log on to the server via terminal service then run enterprise manager
>from my terminal service session. I have no problems with my account
>accessing enterprise manager through that method. I must point out that I
>successfully connect as SA when I run enterprise manager on my desktop. Any
>suggest would be most helpful.
user account on the server ends up being locked out. Currently my work around
is to log on to the server via terminal service then run enterprise manager
from my terminal service session. I have no problems with my account
accessing enterprise manager through that method. I must point out that I
successfully connect as SA when I run enterprise manager on my desktop. Any
suggest would be most helpful.
I'm not sure how you are logging in on your desktop but it
could be related to the polling of the servers from
Enterprise Manager so you can try turning that off. In
Enterprise Manager, go to the menu to Tools, select Options.
On the General Tab, remove the check for Server State
Polling.
-Sue
On Wed, 2 Mar 2005 05:47:02 -0800, "James"
<James@.discussions.microsoft.com> wrote:
>When I connect to the SQL Server remotely via enterprise manager as SA my
>user account on the server ends up being locked out. Currently my work around
>is to log on to the server via terminal service then run enterprise manager
>from my terminal service session. I have no problems with my account
>accessing enterprise manager through that method. I must point out that I
>successfully connect as SA when I run enterprise manager on my desktop. Any
>suggest would be most helpful.
Enterprise Manager causing lockout of user account on server
When I connect to the SQL Server remotely via enterprise manager as SA my
user account on the server ends up being locked out. Currently my work aroun
d
is to log on to the server via terminal service then run enterprise manager
from my terminal service session. I have no problems with my account
accessing enterprise manager through that method. I must point out that I
successfully connect as SA when I run enterprise manager on my desktop. Any
suggest would be most helpful.I'm not sure how you are logging in on your desktop but it
could be related to the polling of the servers from
Enterprise Manager so you can try turning that off. In
Enterprise Manager, go to the menu to Tools, select Options.
On the General Tab, remove the check for Server State
Polling.
-Sue
On Wed, 2 Mar 2005 05:47:02 -0800, "James"
<James@.discussions.microsoft.com> wrote:
>When I connect to the SQL Server remotely via enterprise manager as SA my
>user account on the server ends up being locked out. Currently my work arou
nd
>is to log on to the server via terminal service then run enterprise manager
>from my terminal service session. I have no problems with my account
>accessing enterprise manager through that method. I must point out that I
>successfully connect as SA when I run enterprise manager on my desktop. Any
>suggest would be most helpful.
user account on the server ends up being locked out. Currently my work aroun
d
is to log on to the server via terminal service then run enterprise manager
from my terminal service session. I have no problems with my account
accessing enterprise manager through that method. I must point out that I
successfully connect as SA when I run enterprise manager on my desktop. Any
suggest would be most helpful.I'm not sure how you are logging in on your desktop but it
could be related to the polling of the servers from
Enterprise Manager so you can try turning that off. In
Enterprise Manager, go to the menu to Tools, select Options.
On the General Tab, remove the check for Server State
Polling.
-Sue
On Wed, 2 Mar 2005 05:47:02 -0800, "James"
<James@.discussions.microsoft.com> wrote:
>When I connect to the SQL Server remotely via enterprise manager as SA my
>user account on the server ends up being locked out. Currently my work arou
nd
>is to log on to the server via terminal service then run enterprise manager
>from my terminal service session. I have no problems with my account
>accessing enterprise manager through that method. I must point out that I
>successfully connect as SA when I run enterprise manager on my desktop. Any
>suggest would be most helpful.
Enterprise Manager causing lockout of user account on server
When I connect to the SQL Server remotely via enterprise manager as SA my
user account on the server ends up being locked out. Currently my work around
is to log on to the server via terminal service then run enterprise manager
from my terminal service session. I have no problems with my account
accessing enterprise manager through that method. I must point out that I
successfully connect as SA when I run enterprise manager on my desktop. Any
suggest would be most helpful.I'm not sure how you are logging in on your desktop but it
could be related to the polling of the servers from
Enterprise Manager so you can try turning that off. In
Enterprise Manager, go to the menu to Tools, select Options.
On the General Tab, remove the check for Server State
Polling.
-Sue
On Wed, 2 Mar 2005 05:47:02 -0800, "James"
<James@.discussions.microsoft.com> wrote:
>When I connect to the SQL Server remotely via enterprise manager as SA my
>user account on the server ends up being locked out. Currently my work around
>is to log on to the server via terminal service then run enterprise manager
>from my terminal service session. I have no problems with my account
>accessing enterprise manager through that method. I must point out that I
>successfully connect as SA when I run enterprise manager on my desktop. Any
>suggest would be most helpful.
user account on the server ends up being locked out. Currently my work around
is to log on to the server via terminal service then run enterprise manager
from my terminal service session. I have no problems with my account
accessing enterprise manager through that method. I must point out that I
successfully connect as SA when I run enterprise manager on my desktop. Any
suggest would be most helpful.I'm not sure how you are logging in on your desktop but it
could be related to the polling of the servers from
Enterprise Manager so you can try turning that off. In
Enterprise Manager, go to the menu to Tools, select Options.
On the General Tab, remove the check for Server State
Polling.
-Sue
On Wed, 2 Mar 2005 05:47:02 -0800, "James"
<James@.discussions.microsoft.com> wrote:
>When I connect to the SQL Server remotely via enterprise manager as SA my
>user account on the server ends up being locked out. Currently my work around
>is to log on to the server via terminal service then run enterprise manager
>from my terminal service session. I have no problems with my account
>accessing enterprise manager through that method. I must point out that I
>successfully connect as SA when I run enterprise manager on my desktop. Any
>suggest would be most helpful.
Subscribe to:
Posts (Atom)