Event Viewer Security Logon

[Guest]

Archived from groups: microsoft.public.win2000.security (More info?)

The is a Windows 2003 DataCenter Edition server that is 64-bit that Itanium
2 (1.6 GHZ) processors. In the Event Viewer in the Category field creates a
new Logon/Logoff every 30 seconds for userids that are register within SQL
Server but they are present not using the server.

Is there a settings can be changed to correct this problem or is there an
error with Windows 2003 DataCenter Edition security.

Thanks,

 

[Guest]

Archived from groups: microsoft.public.win2000.security (More info?)

You might want to check whether those are users that have SQL Enterprise
Manager open, and have not changed it to not do frequent refreshing.

--
Roger Abell
Microsoft MVP (Windows Security)
MCSE (W2k3,W2k,Nt4) MCDBA
"Joe K." <Joe K.@discussions.microsoft.com> wrote in message
news:5B7D7FDD-8911-46D3-90E7-A3CECD5C5B11@microsoft.com...
>
> The is a Windows 2003 DataCenter Edition server that is 64-bit that
Itanium
> 2 (1.6 GHZ) processors. In the Event Viewer in the Category field creates
a
> new Logon/Logoff every 30 seconds for userids that are register within SQL
> Server but they are present not using the server.
>
> Is there a settings can be changed to correct this problem or is there an
> error with Windows 2003 DataCenter Edition security.
>
> Thanks,

 

[Guest]

Archived from groups: microsoft.public.win2000.security (More info?)

Check the group policies Computer Configuration | Security Settings | Audit
Policy | Audit Logon events. Turn this off and that should help....

"Roger Abell" wrote:

> You might want to check whether those are users that have SQL Enterprise
> Manager open, and have not changed it to not do frequent refreshing.
>
> --
> Roger Abell
> Microsoft MVP (Windows Security)
> MCSE (W2k3,W2k,Nt4) MCDBA
> "Joe K." <Joe K.@discussions.microsoft.com> wrote in message
> news:5B7D7FDD-8911-46D3-90E7-A3CECD5C5B11@microsoft.com...
> >
> > The is a Windows 2003 DataCenter Edition server that is 64-bit that
> Itanium
> > 2 (1.6 GHZ) processors. In the Event Viewer in the Category field creates
> a
> > new Logon/Logoff every 30 seconds for userids that are register within SQL
> > Server but they are present not using the server.
> >
> > Is there a settings can be changed to correct this problem or is there an
> > error with Windows 2003 DataCenter Edition security.
> >
> > Thanks,
>
>
>

 

[Guest]

Archived from groups: microsoft.public.win2000.security (More info?)

Well, that does remove having to see the symptoms anyway . . .

The underlying issue is the repetitious login events that SQL is recording
without, as I read the OP, there being any connections alive when one looks
from within SQL that would explain all the recorded activity.

The OP might also want to ask in the sqlserver.security newsgroup.

--
Roger Abell
Microsoft MVP (Windows Security)
MCSE (W2k3,W2k,Nt4) MCDBA
"Drumgod" <Drumgod@discussions.microsoft.com> wrote in message
news:E1C70244-21DD-4E3F-91F1-629D0DD39001@microsoft.com...
> Check the group policies Computer Configuration | Security Settings |
Audit
> Policy | Audit Logon events. Turn this off and that should help....
>
> "Roger Abell" wrote:
>
> > You might want to check whether those are users that have SQL Enterprise
> > Manager open, and have not changed it to not do frequent refreshing.
> >
> > --
> > Roger Abell
> > Microsoft MVP (Windows Security)
> > MCSE (W2k3,W2k,Nt4) MCDBA
> > "Joe K." <Joe K.@discussions.microsoft.com> wrote in message
> > news:5B7D7FDD-8911-46D3-90E7-A3CECD5C5B11@microsoft.com...
> > >
> > > The is a Windows 2003 DataCenter Edition server that is 64-bit that
> > Itanium
> > > 2 (1.6 GHZ) processors. In the Event Viewer in the Category field
creates
> > a
> > > new Logon/Logoff every 30 seconds for userids that are register within
SQL
> > > Server but they are present not using the server.
> > >
> > > Is there a settings can be changed to correct this problem or is there
an
> > > error with Windows 2003 DataCenter Edition security.
> > >
> > > Thanks,
> >
> >
> >