Problem running Logbinder


Problem running Logbinder

d

Hello,

I'm trying to use the trial of Logbinder in my computer to try it but i'm having some problems. I have created an local admin user with sysadmin privileges at the DB but when i put the .sqlaudit files on the input folder the service stop and appears the next error message on the log:

2017-04-19 15:47:34.64 Logging (8) <006> SQL Exporter C:\AuditFiles: Starting step 1
2017-04-19 15:47:34.64 Logging (16) <006> SQL Exporter C:\AuditFiles: Connection string: Data Source=WIN-21R9S4PKNMF\SQLEXPRESS;Initial Catalog=Master;Integrated Security=SSPI;
2017-04-19 15:47:34.64 Logging (16) <006> SQL Configuration: Connection string: Data Source=WIN-21R9S4PKNMF\SQLEXPRESS;Initial Catalog=Master;Integrated Security=SSPI;
2017-04-19 15:47:34.64 Logging (16) <006> SQL Exporter C:\AuditFiles\*: Command string: SELECT TOP 20000 * FROM fn_get_audit_file('C:\AuditFiles\*', DEFAULT, DEFAULT)
2017-04-19 15:47:35.05 Logging (1 Critical) <006> Permission Error--SQL Server: Server connection failure: Could not connect to server WIN-21R9S4PKNMF\SQLEXPRESS: A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded.
2017-04-19 15:47:35.05 Logging (2 Error) <006> SQL Exporter: System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded.;  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
 at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
 at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
 at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
 at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
 at System.Data.SqlClient.SqlDataReader.Read()
 at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
 at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
 at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
 at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
 at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
 at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
 at Mtg.Logbinder.Sql.SqlQueries.QueryAuditData(SqlConnection conn, DataSet ds, Int32 topLimit, String filePattern, String initialFileName, Int64 auditRecordOffset, Boolean nonQuery) in C:\agent\_work\4\s\LogbinderSQ\Mtg.Logbinder.Sql\SqlQueries.cs:line 88
 at Mtg.Logbinder.Sql.SqlQueries.QueryAuditData(SqlConnection conn, DataSet ds, Int32 topLimit, String filePattern, Boolean nonQuery) in C:\agent\_work\4\s\LogbinderSQ\Mtg.Logbinder.Sql\SqlQueries.cs:line 44
 at Mtg.Logbinder.Sql.AuditorExporter.querySql(SqlConnection conn) in C:\agent\_work\4\s\LogbinderSQ\Mtg.Logbinder.Sql\AuditorExporter.cs:line 232
2017-04-19 15:47:35.05 Logging (8) <006> SQL Exporter C:\AuditFiles: Completed step 1
2017-04-19 15:47:35.05 Logging (8) <006> Auditor C:\AuditFiles: Completed export step 1
2017-04-19 15:47:35.05 Logging (8) <006> LOGbinder SQL service: Completed processing for auditor index 0
2017-04-19 15:47:35.05 Logging (16) <006> Auditor Processor: Completed round of processor, will start another in seconds: 90
2017-04-19 15:47:35.05 Logging (16) <006> Auditor Processor: Aborting processor!

Do you know what could be the problem?
The Operating System is Windows 7 and SQL version is Microsoft SQL Server Express 11.0.2100.60

Thanks in advance.

bjvista

dvcfc - 4/19/2017
Hello,

I'm trying to use the trial of Logbinder in my computer to try it but i'm having some problems. I have created an local admin user with sysadmin privileges at the DB but when i put the .sqlaudit files on the input folder the service stop and appears the next error message on the log:

2017-04-19 15:47:34.64 Logging (8) <006> SQL Exporter C:\AuditFiles: Starting step 1
2017-04-19 15:47:34.64 Logging (16) <006> SQL Exporter C:\AuditFiles: Connection string: Data Source=WIN-21R9S4PKNMF\SQLEXPRESS;Initial Catalog=Master;Integrated Security=SSPI;
2017-04-19 15:47:34.64 Logging (16) <006> SQL Configuration: Connection string: Data Source=WIN-21R9S4PKNMF\SQLEXPRESS;Initial Catalog=Master;Integrated Security=SSPI;
2017-04-19 15:47:34.64 Logging (16) <006> SQL Exporter C:\AuditFiles\*: Command string: SELECT TOP 20000 * FROM fn_get_audit_file('C:\AuditFiles\*', DEFAULT, DEFAULT)
2017-04-19 15:47:35.05 Logging (1 Critical) <006> Permission Error--SQL Server: Server connection failure: Could not connect to server WIN-21R9S4PKNMF\SQLEXPRESS: A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded.
2017-04-19 15:47:35.05 Logging (2 Error) <006> SQL Exporter: System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded.;  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
 at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
 at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
 at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
 at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
 at System.Data.SqlClient.SqlDataReader.Read()
 at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
 at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
 at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
 at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
 at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
 at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
 at Mtg.Logbinder.Sql.SqlQueries.QueryAuditData(SqlConnection conn, DataSet ds, Int32 topLimit, String filePattern, String initialFileName, Int64 auditRecordOffset, Boolean nonQuery) in C:\agent\_work\4\s\LogbinderSQ\Mtg.Logbinder.Sql\SqlQueries.cs:line 88
 at Mtg.Logbinder.Sql.SqlQueries.QueryAuditData(SqlConnection conn, DataSet ds, Int32 topLimit, String filePattern, Boolean nonQuery) in C:\agent\_work\4\s\LogbinderSQ\Mtg.Logbinder.Sql\SqlQueries.cs:line 44
 at Mtg.Logbinder.Sql.AuditorExporter.querySql(SqlConnection conn) in C:\agent\_work\4\s\LogbinderSQ\Mtg.Logbinder.Sql\AuditorExporter.cs:line 232
2017-04-19 15:47:35.05 Logging (8) <006> SQL Exporter C:\AuditFiles: Completed step 1
2017-04-19 15:47:35.05 Logging (8) <006> Auditor C:\AuditFiles: Completed export step 1
2017-04-19 15:47:35.05 Logging (8) <006> LOGbinder SQL service: Completed processing for auditor index 0
2017-04-19 15:47:35.05 Logging (16) <006> Auditor Processor: Completed round of processor, will start another in seconds: 90
2017-04-19 15:47:35.05 Logging (16) <006> Auditor Processor: Aborting processor!

Do you know what could be the problem?
The Operating System is Windows 7 and SQL version is Microsoft SQL Server Express 11.0.2100.60

Thanks in advance.

According to the log message there is a permissions error. There are three possible accounts involved here.  Your account, the service account that is running LOGbinder, and the SQL server account. These could all be same if setup that way.  But the account(s) need the proper permissions to run correctly.  Can you verify that you've setup the permissions according to the Getting Started Guide in Step 2 on this page

Also, make sure you are using the "Run as administrator" option when you run LOGbinder.  We have seen many times over the years where Windows UAC does not grant Admin privileges to running applications even if you are logged on as an admin.
GO


Similar Topics


Reading This Topic


Login
Existing Account
Email Address:


Password:


Select a Forum....








LOGbinder Forum


Search