SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
problem with sys audit

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
problem with sys audit
Author Message
tonyyang



Joined: 29 Aug 2007
Posts: 1

Post problem with sys audit Reply with quote
my db server is sql server 2000 . when I set up a sys audit and click the enable system audit button. The db audit will auto restart my sql server. when the sql server was start. the db audit display a error messagebox. and have some error report in system event management.
the error is :
[Microsoft][ODBC SQL Server Driver][SQL Server]user '(null)\(null)' log fail. (I use chinese opetation system. so i translate it .)

Audit event reader process is unable to connect the database!.
Wed Aug 29, 2007 2:24 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Hi,

You don't have to restart the SQL Server right away. You can click the No (translated) button on that dialog and choose to restart SQL Server later when it is convenient for you. It is just the installed auditing will not start working until the server is restarted.

The reason for this error is that DB Audit back-end auditing process is having problems connecting to the database server. Most likely you specified a connection using SQL Server authentication, which does not work quite well. For the installation you should login using Windows authentication. After the installation you can login any way you want.

You can find additional diagnostic messages in the Windows Application Log on the server.
Wed Aug 29, 2007 9:08 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.