SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
unable to enable system audit on sql server 20

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
unable to enable system audit on sql server 20
Author Message
Cory



Joined: 23 Jan 2006
Posts: 1

Post unable to enable system audit on sql server 2000 Reply with quote

pardon if this was already covered, but i cound't find anyone with a similar issue.
While trying to set this up for the first time, i was able to connect to my db and then launch the audit options, but after trying to save and enable it, i get an error that the server must be restarted, and the dll copied....
so i copied the xp_audit.dll to my sql\binn folder and restarted the service, but am still unable to enable any auditing options.
following is the series of msgs shown in event viewer:
The description for Event ID ( 1001 ) in Source ( DB Audit ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event:
Starting audit event tracer procedure.

The description for Event ID ( 1001 ) in Source ( DB Audit ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event:
Using standard login for the audit process.

The description for Event ID ( 1001 ) in Source ( DB Audit ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event:
Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied..

The description for Event ID ( 1001 ) in Source ( DB Audit ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event:
Error (dbcmd) executing sp_bindsession procedure..

Mon Jan 23, 2006 3:14 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: unable to enable system audit on sql server 20 Reply with quote

Obviously it is an issue with the connection. The local to the server audit process cannot connect to SQL Server. Try connecting to the SQL server using "Trusted connection" option and re-enabling the audit. Please make sure you have admin right on the server. Please let us know if that helps.

PS. The record in event log should say "using integrated security"

: pardon if this was already covered, but i cound't find anyone with a similar
: issue.
: While trying to set this up for the first time, i was able to connect to my
: db and then launch the audit options, but after trying to save and enable
: it, i get an error that the server must be restarted, and the dll
: copied....
: so i copied the xp_audit.dll to my sql\binn folder and restarted the service,
: but am still unable to enable any auditing options.
: following is the series of msgs shown in event viewer: The description for
: Event ID ( 1001 ) in Source ( DB Audit ) cannot be found. The local
: computer may not have the necessary registry information or message DLL
: files to display messages from a remote computer. The following
: information is part of the event: Starting audit event tracer procedure.

: The description for Event ID ( 1001 ) in Source ( DB Audit ) cannot be found.
: The local computer may not have the necessary registry information or
: message DLL files to display messages from a remote computer. The
: following information is part of the event: Using standard login for the
: audit process.

: The description for Event ID ( 1001 ) in Source ( DB Audit ) cannot be found.
: The local computer may not have the necessary registry information or
: message DLL files to display messages from a remote computer. The
: following information is part of the event: Unable to connect: SQL Server
: is unavailable or does not exist. Unable to connect: SQL Server does not
: exist or network access denied..

: The description for Event ID ( 1001 ) in Source ( DB Audit ) cannot be found.
: The local computer may not have the necessary registry information or
: message DLL files to display messages from a remote computer. The
: following information is part of the event: Error (dbcmd) executing
: sp_bindsession procedure..

Mon Jan 23, 2006 4:43 pm View user's profile Send private message
Raymond



Joined: 16 Jan 2006
Posts: 6

Post Re: unable to enable system audit on sql server 20 Reply with quote

: Obviously it is an issue with the connection. The local to the server audit
: process cannot connect to SQL Server. Try connecting to the SQL server
: using "Trusted connection" option and re-enabling the audit.
: Please make sure you have admin right on the server. Please let us know if
: that helps.

: PS. The record in event log should say "using integrated security"

I have exactly same problem . I had Domain admin authority and use trusted connection.
But when I issue EXEC sp_db_audit_startup in MASTER DB. I get " Msg 20001, Level 1, State 20001
Error (dbcmd) executing sp_bindsession procedure." . The interesting part is some sql server work without problem. Some give me the above mesage.

Thu Jan 26, 2006 4:25 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: unable to enable system audit on sql server 20 Reply with quote

This happens usually after some problems in SQL Server. If you restart SQL SErver you will see this problem go away.

: I have exactly same problem . I had Domain admin authority and use trusted
: connection.
: But when I issue EXEC sp_db_audit_startup in MASTER DB. I get " Msg
: 20001, Level 1, State 20001
: Error (dbcmd) executing sp_bindsession procedure." . The interesting
: part is some sql server work without problem. Some give me the above
: mesage.

Thu Jan 26, 2006 10:02 am View user's profile Send private message
Jitesh Hari



Joined: 05 Apr 2006
Posts: 2

Post Re: unable to enable system audit on sql server 20 Reply with quote

: I have exactly same problem . I had Domain admin authority and use trusted
: connection.
: But when I issue EXEC sp_db_audit_startup in MASTER DB. I get " Msg
: 20001, Level 1, State 20001
: Error (dbcmd) executing sp_bindsession procedure." . The interesting
: part is some sql server work without problem. Some give me the above
: mesage.

I am receiving the exact same errors. Has this been resolved.

Wed Apr 05, 2006 7:28 am View user's profile Send private message
Jitesh Hari



Joined: 05 Apr 2006
Posts: 2

Post Re: unable to enable system audit on sql server 20 Reply with quote

: This happens usually after some problems in SQL Server. If you restart SQL
: SErver you will see this problem go away.

I have restarted SQL several times. I also uninstalled and reinstalled DB Audit. No luck

Wed Apr 05, 2006 7:31 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: unable to enable system audit on sql server 20 Reply with quote

This is either an invalid login issue or something is wrong with the user setup in SQL Server.

Check points:
1. Make sure you can login to the server from the server computer using Windows authentication
2. Make sure this particular login is known to SQL Server (listed in logins, member of the "System Administrators" server role and is explicitly set as a member of the "public" role in the master)

: I am receiving the exact same errors. Has this been resolved.

Wed Apr 05, 2006 9:43 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: unable to enable system audit on sql server 20 Reply with quote

This is either an invalid login issue or something is wrong with the user setup in SQL Server.

Check points:
1. Make sure you can login to the server from the server computer using Windows authentication
2. Make sure this particular login is known to SQL Server (listed in logins, member of the "System Administrators" server role and is explicitly set as a member of the "public" role in the master)

: I have restarted SQL several times. I also uninstalled and reinstalled DB
: Audit. No luck

Wed Apr 05, 2006 9:44 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.