Re: Event Viewer Security Logon

From: Roger Abell (mvpNOSpam_at_asu.edu)
Date: 05/25/05 

Date: Tue, 24 May 2005 18:17:01 -0700

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,
> >
> >
> >

Relevant Pages

  • Re: VB code for filtering mail merge
    ... SQL statement area. ... The filtering options I selected while recording that macro did produce the ... What actually works depends largely on the data source and partly on the ... Connection string so that when you try to re-execute the recorded macro, ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Using Excel and SQL
    ... it is best that you get it working manually while recording a macro and then ... Then select New SQL ... See if you can get any data from the server using this method. ... post the record macro. ...
    (microsoft.public.excel.misc)
  • Re: INSERT INTO..SELECT
    ... in Excel 2002, not to learn to write SQL or VBA. ... but still the recorded macro is blank. ... >> during the macro recording process, ...
    (microsoft.public.excel.programming)
  • Re: How to move current SQL server from Domain A to Domain B?
    ... Users are authenticating to SQL using a local SQL login ID/PWD. ... retiring the old domain and as far as windows security, ... > removing the domain you will have to recreate your security setup. ...
    (microsoft.public.sqlserver.setup)
  • Re: INSERT INTO..SELECT
    ... > SQL INSERT INTO..SELECT statements. ... > during the macro recording process, when I stop recording, ... > the resulting macro is empty. ... macro the recorder and the MS Query wizard write lousy code. ...
    (microsoft.public.excel.programming)