LOGON TRIGGERS

Are there any plans to enhance LOGON TRIGGERS in Katmai or SP3 for SQL Server 2005?

And I mean by enhancements:

- providing base scripts that can be adapter for specific scenarios like limiting the number of connections

- any interface (like the Windows Server Active Directory Users and Computers Snap-in for managing Logon Hours)

- etc

These is some documentation for basic scripts in the works.

I can update this thread when they can be released.

Thanks,

-Steven Gott

SDE/T

SQL Server

|||

Also Books Online states the following:

Important:

In addition to enabling the common criteria compliance enabled option, you also must download and run a script that completes configuring SQL Server 2005 SP2 to comply with Common Criteria evaluation assurance level 4 (EAL4+). You can download this script from the Microsoft SQL Server Common Criteria Web site.

But the script is for SP1. What about the script for SP2?

LOGON TRIGGERS

Are there any plans to enhance LOGON TRIGGERS in Katmai or SP3 for SQL Server 2005?

And I mean by enhancements:

- providing base scripts that can be adapter for specific scenarios like limiting the number of connections

- any interface (like the Windows Server Active Directory Users and Computers Snap-in for managing Logon Hours)

- etc

These is some documentation for basic scripts in the works.

I can update this thread when they can be released.

Thanks,

-Steven Gott

SDE/T

SQL Server

|||

Also Books Online states the following:

Important:

In addition to enabling the common criteria compliance enabled option, you also must download and run a script that completes configuring SQL Server 2005 SP2 to comply with Common Criteria evaluation assurance level 4 (EAL4+). You can download this script from the Microsoft SQL Server Common Criteria Web site.

But the script is for SP1. What about the script for SP2?

LOGON TRIGGERS

Are there any plans to enhance LOGON TRIGGERS in Katmai or SP3 for SQL Server 2005?

And I mean by enhancements:

- providing base scripts that can be adapter for specific scenarios like limiting the number of connections

- any interface (like the Windows Server Active Directory Users and Computers Snap-in for managing Logon Hours)

- etc

These is some documentation for basic scripts in the works.

I can update this thread when they can be released.

Thanks,

-Steven Gott

SDE/T

SQL Server

|||

Also Books Online states the following:

Important:

In addition to enabling the common criteria compliance enabled option, you also must download and run a script that completes configuring SQL Server 2005 SP2 to comply with Common Criteria evaluation assurance level 4 (EAL4+). You can download this script from the Microsoft SQL Server Common Criteria Web site.

But the script is for SP1. What about the script for SP2?

Login Triggers?

Quick question about SQL 2000. Are there ways to have a trigger fire when
someone (anyone) logs in to a MSSQL SQL 2000 instance? I had thought MSSQL
came with login triggers but I haven't been able to find any info.
TIA,
JDNo, sorry.
If you want to track logins, you can log all login attempts. Or you can run
a SQL Trace that captures that information. However, if you wanted to do
some additional work for the user, there is no trigger for that.
RLF
"Joe D" <jkdriscoll@.qg.com> wrote in message
news:dvph8d$2k91$1@.sxnews1.qg.com...
> Quick question about SQL 2000. Are there ways to have a trigger fire when
> someone (anyone) logs in to a MSSQL SQL 2000 instance? I had thought MSSQL
> came with login triggers but I haven't been able to find any info.
> TIA,
> JD
>|||thanks for the feed back Russell.
Do you if SQL 2005 will offer it?
Thanks again.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:O5cm9uRTGHA.4900@.TK2MSFTNGP12.phx.gbl...
> No, sorry.
> If you want to track logins, you can log all login attempts. Or you can
> run a SQL Trace that captures that information. However, if you wanted to
> do some additional work for the user, there is no trigger for that.
> RLF
> "Joe D" <jkdriscoll@.qg.com> wrote in message
> news:dvph8d$2k91$1@.sxnews1.qg.com...
>|||Hello Joe,

> Do you if SQL 2005 will offer it?
Thats an interesting question. The answer is yes, but you'll have to be a
bit more creative than you might like.
In 2005 you can do an CREATE EVENT NOTIFICATION on SERVER FOR AUDIT_LOGIN|AU
DIT_LOGIN_FAILED|AUDIT_LOGOUT
etc and send that payload to a service broker queue for processing. The spro
c
that processes queued messages could then do what you neeed more than likely
.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||Interesting.
Thanks Kent.
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad741c12a8c81b0a6c56b8f0@.news.microsoft.com...
> Hello Joe,
>
> Thats an interesting question. The answer is yes, but you'll have to be a
> bit more creative than you might like.
> In 2005 you can do an CREATE EVENT NOTIFICATION on SERVER FOR
> AUDIT_LOGIN|AUDIT_LOGIN_FAILED|AUDIT_LOG
OUT etc and send that payload to a
> service broker queue for processing. The sproc that processes queued
> messages could then do what you neeed more than likely.
> Thank you,
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>|||>> Thats an interesting question. The answer is yes, but you'll have to[vbcol=seagreen]
Closing the loop on this: http://www.sqljunkies.com/WebLog/kt...ifications.aspx
Enjoy!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/