SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Installation without MS SQL restart

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Installation without MS SQL restart
Author Message
Akinja Richards



Joined: 21 Sep 2005
Posts: 6

Post Installation without MS SQL restart Reply with quote

The documentation mention that MS SQL must be restarted once Sys Audit is setup. However, it also states "In case if you run SQL Server in a 24x7 enviornment and the server cannot be restarted read "Alternative Method to Start System Audit section available later in this chapter.""

The problem is that in both v2.6 and v2.7 documentation (Chap 3) I have not been able to find this section. Can someone direct me to the proper location?

Wed Sep 21, 2005 12:57 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: Installation without MS SQL restart Reply with quote

On the server start SQL Query Analyzer or OSQL connect to the database and manually run sp_db_audit_startup procedure. Do not close the tool. That's it.

PS. If you close the tool the connection will be lost and the auditing session will abort.

: The documentation mention that MS SQL must be restarted once Sys Audit is
: setup. However, it also states "In case if you run SQL Server in a
: 24x7 enviornment and the server cannot be restarted read "Alternative
: Method to Start System Audit section available later in this
: chapter.""

: The problem is that in both v2.6 and v2.7 documentation (Chap 3) I have not
: been able to find this section. Can someone direct me to the proper
: location?

Wed Sep 21, 2005 2:22 pm View user's profile Send private message
Akinja Richards



Joined: 21 Sep 2005
Posts: 6

Post Re: Installation without MS SQL restart Reply with quote

I ran

USE master
GO
EXEC sp_db_audit_startup
GO

And recieved

ODBC: Msg 0, Level 16, State 1
Cannot load the DLL xp_dbaudit.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

Any idea

: On the server start SQL Query Analyzer or OSQL connect to the database and
: manually run sp_db_audit_startup procedure. Do not close the tool. That's
: it.

: PS. If you close the tool the connection will be lost and the auditing
: session will abort.

Thu Sep 22, 2005 3:23 pm View user's profile Send private message
Akinja Richards



Joined: 21 Sep 2005
Posts: 6

Post Re: Installation without MS SQL restart Reply with quote

I looked at the stored procedure and it looks like it is trying to execute xp_db_audit. However, I noticed a new stored proc named sp_db_audit.

It is trying to use this proc?

: I ran

: USE master
: GO
: EXEC sp_db_audit_startup
: GO

: And recieved

: ODBC: Msg 0, Level 16, State 1
: Cannot load the DLL xp_dbaudit.dll, or one of the DLLs it references. Reason:
: 126(The specified module could not be found.).

: Any idea

Thu Sep 22, 2005 3:28 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: Installation without MS SQL restart Reply with quote

You need to copy this DLL from DB Audit directory on your computer to the SQL Server's BIN directory on the server.

: I ran

: USE master
: GO
: EXEC sp_db_audit_startup
: GO

: And recieved

: ODBC: Msg 0, Level 16, State 1
: Cannot load the DLL xp_dbaudit.dll, or one of the DLLs it references. Reason:
: 126(The specified module could not be found.).

: Any idea

Thu Sep 22, 2005 4:14 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: Installation without MS SQL restart Reply with quote

Yes, it will execute it internally, don't run it manually.

: I looked at the stored procedure and it looks like it is trying to execute
: xp_db_audit. However, I noticed a new stored proc named sp_db_audit.

: It is trying to use this proc?

Thu Sep 22, 2005 4:15 pm 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.