May 5, 2009 at 10:50 am
Hi,
I wan to enable auditing in SQL Server 2005 but the login audit option itself is not enabled.
Please tell how to enable login audit option so that i can select the required auditing.
Waiting for ur kind reply :hehe:
May 5, 2009 at 10:59 am
You can create your own auditing with triggers, including DDL and login triggers, in 2005.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 5, 2009 at 11:02 am
yes we can do that for some testing purpose i need to enable that option but that login audit option is disabled in database server properties- security option.
May 6, 2009 at 7:00 am
Are you asking how to enable it? Just not sure what your question is at this point.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 6, 2009 at 8:59 am
hi,
If i go to Database server->properties->Security option
their using Login audit window will be enable to select to options but in my server login audit option is not enable i,e i am not able to select any option. so please any idea about this....
May 6, 2009 at 9:16 am
What edition of SQL Server are you using? Express? Standard? Enterprise? Workgroup?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 6, 2009 at 9:18 am
I am using Enterprise edition with sp3.
May 6, 2009 at 9:24 am
Option should definitely exist. Is it possible you don't have the necessary security rights to access it?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 6, 2009 at 9:29 am
I have full admin access and i can see login aduit option screen but that option window is showing faded color i,e i can't edit that option but same thing i can do in other server thats whats its confusing...
May 7, 2009 at 6:57 am
No idea what would cause that in that case.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 7, 2009 at 9:35 am
anjan.ashok (5/6/2009)
I am using Enterprise edition with sp3.
Did you installed SP3 recently? check the log file of sp3 installation as may be due to some failure in sp3.
Hope this helps
\\K 🙂
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
May 8, 2009 at 5:38 am
You could try to execute "sp_helpdb master" to see the user admin and "select * from sys.syspermissions" to see his rights.
/*
sp_helpdb master
select * from sys.syspermissions
*/
If the user is "sa" you could try to logon as "sa" and probe to change your "login audit".
May 8, 2009 at 6:26 am
Hi,
I login as SA and checked, but same issue is there???:hehe:
May 8, 2009 at 1:36 pm
taken from: http://www.sqlmag.com/Articles/ArticleID/98709/pg/2/2.html
To determine whether or not C2 audit mode is turned on, you can use the following T-SQL statement, which returns the current value of the C2 audit mode option:
SELECT value FROM sys.configurations
WHERE name = ‘c2 audit mode’;
GO
If the result is 1, C2 audit mode is enabled; if 0, it’s disabled.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply