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..
|