SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DBAudit system audit for sql server 2005

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DBAudit system audit for sql server 2005
Author Message
Lei Wang



Joined: 28 Jul 2006
Posts: 3

Post DBAudit system audit for sql server 2005 Reply with quote

I can use data audit but I am having a hard time
to enable system audit.

Everytime DBAudit asks to restart SQL server. I
choose yes but restart will fail. I am using
trusted connection and that connection can restart
sql server no problem in sql server management studio.

If I choose to manually run sp_db_audit_startup it will
always report "Could not load the DLL xp_dbaudit.dll"
but that dll file is in "C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn"

I spent couple of hours on it but could not figure it out.
Please help. Once I can make it work this product will
be great.

Thank you.

Fri Jul 28, 2006 7:24 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: DBAudit system audit for sql server 2005 Reply with quote

Sounds like your SQL Server is starting from some other location.
Are you sure its home is in C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn?

You can verify it in the properties of the SQL Service service (see the command line). If you find it in some other place please copy xp_dbaudit.dll to that place.

: I can use data audit but I am having a hard time
: to enable system audit.

: Everytime DBAudit asks to restart SQL server. I
: choose yes but restart will fail. I am using
: trusted connection and that connection can restart
: sql server no problem in sql server management studio.

: If I choose to manually run sp_db_audit_startup it will
: always report "Could not load the DLL xp_dbaudit.dll"
: but that dll file is in "C:\Program Files\Microsoft SQL
: Server\MSSQL.4\MSSQL\Binn"

: I spent couple of hours on it but could not figure it out.
: Please help. Once I can make it work this product will
: be great.

: Thank you.

Fri Jul 28, 2006 7:57 pm View user's profile Send private message
Lei Wang



Joined: 28 Jul 2006
Posts: 3

Post Re: DBAudit system audit for sql server 2005 Reply with quote

I verified my service. It does show "path to executable:". Please help!

"C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER

: Sounds like your SQL Server is starting from some other location.
: Are you sure its home is in C:\Program Files\Microsoft SQL
: Server\MSSQL.4\MSSQL\Binn?

: You can verify it in the properties of the SQL Service service (see the
: command line). If you find it in some other place please copy
: xp_dbaudit.dll to that place.

Mon Jul 31, 2006 1:41 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: DBAudit system audit for sql server 2005 Reply with quote

And the db_audit.dll is copied to that directory?

: I verified my service. It does show "path to executable:". Please
: help!

: "C:\Program Files\Microsoft SQL
: Server\MSSQL.4\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER

Mon Jul 31, 2006 3:05 pm View user's profile Send private message
Lei Wang



Joined: 28 Jul 2006
Posts: 3

Post Re: DBAudit system audit for sql server 2005 Reply with quote

No there is no db_audit.dll but xp_dbaudit.dll is in the same directory.

: And the db_audit.dll is copied to that directory?

Sun Aug 20, 2006 11:47 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: DBAudit system audit for sql server 2005 Reply with quote

Sorry, I really meant xp_dbaudit.dll file.

This is very strange. Do you have C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn
in the system search path? Is there opends60.dll?
Are you doing this via terminal session or remote desktop by any chance?

: No there is no db_audit.dll but xp_dbaudit.dll is in the same directory.

Mon Aug 21, 2006 8:07 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.