How to Audit Login, Log off, and Login failure attempts

Hi,
Can anyone provide a pointer on how to enable login, log out, and=
login failure attempts without using the SQL Profiler? I want=
to enable this type of auditing at all times and store the=
results to a table. SQL Profiler does it however I would have=
to keep this tool open all the time in order to get the audit=
results.
Any advice is greatly appreciated. Thanks!
-Lorinda
User submitted from AEWNET (http://www.aewnet.com/)Take a look at sp_trace_create and sp_trace_status in Books Online. You can
create a SQL Agent job to start these on startup or create your own procedur
e
that preps and calls these and mark that proc to start up when SQL Server
does. It basically does the same thing as profiler but is script based
instead of the interactive GUI.
Hope this helps.
Sincerely,
Anthony Thomas
"Guest" wrote:

> Hi,
> Can anyone provide a pointer on how to enable login, log out, and login failure at
tempts without using the SQL Profiler? I want to enable this type of auditing at al
l times and store the results to a table. SQL Profiler does it however I would have
to
keep this tool open all the time in order to get the audit results.
> Any advice is greatly appreciated. Thanks!
> -Lorinda
> User submitted from AEWNET (http://www.aewnet.com/)
>|||Hi,
See this article by Vyas.
http://vyaskn.tripod.com/server_sid..._sql_server.htm
Thanks
Hari
SQL Server MVP
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:7938CF87-6D42-43FD-8A54-7F7288BEE53A@.microsoft.com...[vbcol=seagreen]
> Take a look at sp_trace_create and sp_trace_status in Books Online. You
> can
> create a SQL Agent job to start these on startup or create your own
> procedure
> that preps and calls these and mark that proc to start up when SQL Server
> does. It basically does the same thing as profiler but is script based
> instead of the interactive GUI.
> Hope this helps.
> Sincerely,
>
> Anthony Thomas
>
> "Guest" wrote:
>|||Also in SQL Enterprise Manager, right click your server and go to properties
( I think the security tab) ... IN the middle you can set some login
auditing parameters..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Guest" <Guest@.aew_nospam.com> wrote in message
news:%23prHz3gwEHA.1400@.TK2MSFTNGP11.phx.gbl...
Hi,
Can anyone provide a pointer on how to enable login, log out, and login
failure attempts without using the SQL Profiler? I want to enable this type
of auditing at all times and store the results to a table. SQL Profiler
does it however I would have to keep this tool open all the time in order to
get the audit results.
Any advice is greatly appreciated. Thanks!
-Lorinda
User submitted from AEWNET (http://www.aewnet.com/)|||What you require is also what C2 auditing in SQL Server offers (and much
more). This might also help:
http://www.databasejournal.com/feat...cle.php/3399241
Sasan Saidi, MSc in CS
Senior DBA
Brascan Business Services
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Guest" wrote:

> Hi,
> Can anyone provide a pointer on how to enable login, log out, and login failure at
tempts without using the SQL Profiler? I want to enable this type of auditing at al
l times and store the results to a table. SQL Profiler does it however I would have
to
keep this tool open all the time in order to get the audit results.
> Any advice is greatly appreciated. Thanks!
> -Lorinda
> User submitted from AEWNET (http://www.aewnet.com/)
>|||Server side tracing is exactly what I need. Thank you for all your response
s!
-Lorinda
User submitted from AEWNET (http://www.aewnet.com/)

How to Audit Login, Log off, and Login failure attempts

Hi,
Can anyone provide a pointer on how to enable login, log out, and= login failure attempts without using the SQL Profiler? I want= to enable this type of auditing at all times and store the= results to a table. SQL Profiler does it however I would have= to keep this tool open all the time in order to get the audit= results.
Any advice is greatly appreciated. Thanks!
-Lorinda
User submitted from AEWNET (http://www.aewnet.com/)Take a look at sp_trace_create and sp_trace_status in Books Online. You can
create a SQL Agent job to start these on startup or create your own procedure
that preps and calls these and mark that proc to start up when SQL Server
does. It basically does the same thing as profiler but is script based
instead of the interactive GUI.
Hope this helps.
Sincerely,
Anthony Thomas
"Guest" wrote:
> Hi,
> Can anyone provide a pointer on how to enable login, log out, and login failure attempts without using the SQL Profiler? I want to enable this type of auditing at all times and store the results to a table. SQL Profiler does it however I would have to keep this tool open all the time in order to get the audit results.
> Any advice is greatly appreciated. Thanks!
> -Lorinda
> User submitted from AEWNET (http://www.aewnet.com/)
>|||Hi,
See this article by Vyas.
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
Thanks
Hari
SQL Server MVP
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:7938CF87-6D42-43FD-8A54-7F7288BEE53A@.microsoft.com...
> Take a look at sp_trace_create and sp_trace_status in Books Online. You
> can
> create a SQL Agent job to start these on startup or create your own
> procedure
> that preps and calls these and mark that proc to start up when SQL Server
> does. It basically does the same thing as profiler but is script based
> instead of the interactive GUI.
> Hope this helps.
> Sincerely,
>
> Anthony Thomas
>
> "Guest" wrote:
>> Hi,
>> Can anyone provide a pointer on how to enable login, log out, and login
>> failure attempts without using the SQL Profiler? I want to enable this
>> type of auditing at all times and store the results to a table. SQL
>> Profiler does it however I would have to keep this tool open all the time
>> in order to get the audit results.
>> Any advice is greatly appreciated. Thanks!
>> -Lorinda
>> User submitted from AEWNET (http://www.aewnet.com/)|||Also in SQL Enterprise Manager, right click your server and go to properties
( I think the security tab) ... IN the middle you can set some login
auditing parameters..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Guest" <Guest@.aew_nospam.com> wrote in message
news:%23prHz3gwEHA.1400@.TK2MSFTNGP11.phx.gbl...
Hi,
Can anyone provide a pointer on how to enable login, log out, and login
failure attempts without using the SQL Profiler? I want to enable this type
of auditing at all times and store the results to a table. SQL Profiler
does it however I would have to keep this tool open all the time in order to
get the audit results.
Any advice is greatly appreciated. Thanks!
-Lorinda
User submitted from AEWNET (http://www.aewnet.com/)|||What you require is also what C2 auditing in SQL Server offers (and much
more). This might also help:
http://www.databasejournal.com/features/mssql/article.php/3399241
--
Sasan Saidi, MSc in CS
Senior DBA
Brascan Business Services
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Guest" wrote:
> Hi,
> Can anyone provide a pointer on how to enable login, log out, and login failure attempts without using the SQL Profiler? I want to enable this type of auditing at all times and store the results to a table. SQL Profiler does it however I would have to keep this tool open all the time in order to get the audit results.
> Any advice is greatly appreciated. Thanks!
> -Lorinda
> User submitted from AEWNET (http://www.aewnet.com/)
>|||Server side tracing is exactly what I need. Thank you for all your responses!
-Lorinda
User submitted from AEWNET (http://www.aewnet.com/)sql

How to Audit Login, Log off, and Login failure attempts

Hi,
Can anyone provide a pointer on how to enable login, log out, and=
login failure attempts without using the SQL Profiler? I want=
to enable this type of auditing at all times and store the=
results to a table. SQL Profiler does it however I would have=
to keep this tool open all the time in order to get the audit=
results.
Any advice is greatly appreciated. Thanks!
-Lorinda
User submitted from AEWNET (http://www.aewnet.com/)
Take a look at sp_trace_create and sp_trace_status in Books Online. You can
create a SQL Agent job to start these on startup or create your own procedure
that preps and calls these and mark that proc to start up when SQL Server
does. It basically does the same thing as profiler but is script based
instead of the interactive GUI.
Hope this helps.
Sincerely,
Anthony Thomas
"Guest" wrote:

> Hi,
> Can anyone provide a pointer on how to enable login, log out, and login failure attempts without using the SQL Profiler? I want to enable this type of auditing at all times and store the results to a table. SQL Profiler does it however I would have to
keep this tool open all the time in order to get the audit results.
> Any advice is greatly appreciated. Thanks!
> -Lorinda
> User submitted from AEWNET (http://www.aewnet.com/)
>
|||Hi,
See this article by Vyas.
http://vyaskn.tripod.com/server_side...sql_server.htm
Thanks
Hari
SQL Server MVP
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:7938CF87-6D42-43FD-8A54-7F7288BEE53A@.microsoft.com...[vbcol=seagreen]
> Take a look at sp_trace_create and sp_trace_status in Books Online. You
> can
> create a SQL Agent job to start these on startup or create your own
> procedure
> that preps and calls these and mark that proc to start up when SQL Server
> does. It basically does the same thing as profiler but is script based
> instead of the interactive GUI.
> Hope this helps.
> Sincerely,
>
> Anthony Thomas
>
> "Guest" wrote:
|||Also in SQL Enterprise Manager, right click your server and go to properties
( I think the security tab) ... IN the middle you can set some login
auditing parameters..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Guest" <Guest@.aew_nospam.com> wrote in message
news:%23prHz3gwEHA.1400@.TK2MSFTNGP11.phx.gbl...
Hi,
Can anyone provide a pointer on how to enable login, log out, and login
failure attempts without using the SQL Profiler? I want to enable this type
of auditing at all times and store the results to a table. SQL Profiler
does it however I would have to keep this tool open all the time in order to
get the audit results.
Any advice is greatly appreciated. Thanks!
-Lorinda
User submitted from AEWNET (http://www.aewnet.com/)
|||What you require is also what C2 auditing in SQL Server offers (and much
more). This might also help:
http://www.databasejournal.com/featu...le.php/3399241
Sasan Saidi, MSc in CS
Senior DBA
Brascan Business Services
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Guest" wrote:

> Hi,
> Can anyone provide a pointer on how to enable login, log out, and login failure attempts without using the SQL Profiler? I want to enable this type of auditing at all times and store the results to a table. SQL Profiler does it however I would have to
keep this tool open all the time in order to get the audit results.
> Any advice is greatly appreciated. Thanks!
> -Lorinda
> User submitted from AEWNET (http://www.aewnet.com/)
>
|||Server side tracing is exactly what I need. Thank you for all your responses!
-Lorinda
User submitted from AEWNET (http://www.aewnet.com/)

How to assign more Operators to a Job failure alert ?

Hello,
I'm using SQL Server 2000 and have defined 3 Operators that need to receive
alerts from shecduled jobs.
We have chosen to go with 'Net Send' type of alert.
Inside each scheduled job, under Notifications Tab, it doesn't give me a
choice to add more operators upon failure of this job, nor does it allow me
to run a script (a batch file that I would include Net send commands to 3
Operators).
Is there a quick way to resolve this without installing Notifications
Services ?
Thanks,
Sam.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.server:426602
We use netsend operators at work but rather than using seperate mail
accounts, we use a mail group, that way you can send to more users.
"Sameer via droptable.com" <u4996@.uwe> wrote in message
news:5d00a065a9839@.uwe...
> Hello,
> I'm using SQL Server 2000 and have defined 3 Operators that need to
receive
> alerts from shecduled jobs.
> We have chosen to go with 'Net Send' type of alert.
> Inside each scheduled job, under Notifications Tab, it doesn't give me a
> choice to add more operators upon failure of this job, nor does it allow
me
> to run a script (a batch file that I would include Net send commands to 3
> Operators).
> Is there a quick way to resolve this without installing Notifications
> Services ?
> Thanks,
> Sam.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200603/1
|||Where and how do you create the Mail Group ?
Message posted via http://www.droptable.com
|||In your mail server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"spremji via droptable.com" <u4996@.uwe> wrote in message news:5d036a522f9fe@.uwe...
> Where and how do you create the Mail Group ?
> --
> Message posted via http://www.droptable.com
|||Would that mean that I have to setup MAPI on SQL Server for it to detect Mail
Groups ?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1
|||The built-in mail feature of SQL Server 2000 only supports MAPI. There are some workarounds
(http://www.karaszi.com/SQLServer/info_no_mapi.asp), but we finally got SMTP support in 2005.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"spremji via droptable.com" <u4996@.uwe> wrote in message news:5d0e98b1e5179@.uwe...
> Would that mean that I have to setup MAPI on SQL Server for it to detect Mail
> Groups ?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200603/1
|||The reason we went with Net Send was to avoid MAPI setup on the server. But I
guess, I'll develop custom-code to handle this.
Thanks for your advises. I appreciate it :-)
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1

How to assign more Operators to a Job failure alert ?

Hello,
I'm using SQL Server 2000 and have defined 3 Operators that need to receive
alerts from shecduled jobs.
We have chosen to go with 'Net Send' type of alert.
Inside each scheduled job, under Notifications Tab, it doesn't give me a
choice to add more operators upon failure of this job, nor does it allow me
to run a script (a batch file that I would include Net send commands to 3
Operators).
Is there a quick way to resolve this without installing Notifications
Services ?
Thanks,
Sam.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1We use netsend operators at work but rather than using seperate mail
accounts, we use a mail group, that way you can send to more users.
"Sameer via SQLMonster.com" <u4996@.uwe> wrote in message
news:5d00a065a9839@.uwe...
> Hello,
> I'm using SQL Server 2000 and have defined 3 Operators that need to
receive
> alerts from shecduled jobs.
> We have chosen to go with 'Net Send' type of alert.
> Inside each scheduled job, under Notifications Tab, it doesn't give me a
> choice to add more operators upon failure of this job, nor does it allow
me
> to run a script (a batch file that I would include Net send commands to 3
> Operators).
> Is there a quick way to resolve this without installing Notifications
> Services ?
> Thanks,
> Sam.
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||Where and how do you create the Mail Group ?
--
Message posted via http://www.sqlmonster.com|||In your mail server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"spremji via SQLMonster.com" <u4996@.uwe> wrote in message news:5d036a522f9fe@.uwe...
> Where and how do you create the Mail Group ?
> --
> Message posted via http://www.sqlmonster.com|||Would that mean that I have to setup MAPI on SQL Server for it to detect Mail
Groups ?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||The built-in mail feature of SQL Server 2000 only supports MAPI. There are some workarounds
(http://www.karaszi.com/SQLServer/info_no_mapi.asp), but we finally got SMTP support in 2005.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"spremji via SQLMonster.com" <u4996@.uwe> wrote in message news:5d0e98b1e5179@.uwe...
> Would that mean that I have to setup MAPI on SQL Server for it to detect Mail
> Groups ?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||The reason we went with Net Send was to avoid MAPI setup on the server. But I
guess, I'll develop custom-code to handle this.
Thanks for your advises. I appreciate it :-)
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1sql

How to assign more Operators to a Job failure alert ?

Hello,
I'm using SQL Server 2000 and have defined 3 Operators that need to receive
alerts from shecduled jobs.
We have chosen to go with 'Net Send' type of alert.
Inside each scheduled job, under Notifications Tab, it doesn't give me a
choice to add more operators upon failure of this job, nor does it allow me
to run a script (a batch file that I would include Net send commands to 3
Operators).
Is there a quick way to resolve this without installing Notifications
Services ?
Thanks,
Sam.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.server:426602
We use netsend operators at work but rather than using seperate mail
accounts, we use a mail group, that way you can send to more users.
"Sameer via droptable.com" <u4996@.uwe> wrote in message
news:5d00a065a9839@.uwe...
> Hello,
> I'm using SQL Server 2000 and have defined 3 Operators that need to
receive
> alerts from shecduled jobs.
> We have chosen to go with 'Net Send' type of alert.
> Inside each scheduled job, under Notifications Tab, it doesn't give me a
> choice to add more operators upon failure of this job, nor does it allow
me
> to run a script (a batch file that I would include Net send commands to 3
> Operators).
> Is there a quick way to resolve this without installing Notifications
> Services ?
> Thanks,
> Sam.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200603/1|||Where and how do you create the Mail Group ?
Message posted via http://www.droptable.com|||In your mail server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"spremji via droptable.com" <u4996@.uwe> wrote in message news:5d036a522f9fe@.uwe...agreen">
> Where and how do you create the Mail Group ?
> --
> Message posted via http://www.droptable.com|||Would that mean that I have to setup MAPI on SQL Server for it to detect Mai
l
Groups ?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1|||The built-in mail feature of SQL Server 2000 only supports MAPI. There are s
ome workarounds
(http://www.karaszi.com/SQLServer/info_no_mapi.asp), but we finally got SMTP
support in 2005.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"spremji via droptable.com" <u4996@.uwe> wrote in message news:5d0e98b1e5179@.uwe...agreen">
> Would that mean that I have to setup MAPI on SQL Server for it to detect M
ail
> Groups ?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200603/1|||The reason we went with Net Send was to avoid MAPI setup on the server. But
I
guess, I'll develop custom-code to handle this.
Thanks for your advises. I appreciate it :-)
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1