Issue | An error appears in the JobFramework.job log files stating: VIEW SERVER STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action.
<Execution ProcessName="ArcherTech.JobFramework.Job" ProcessID="2624" ThreadID="32" /> <AssemblyVersion>6.8.0.1170</AssemblyVersion> <Channel /> <Computer>xxxxxxxxxxxxxx</Computer> </System> <ApplicationData> <TraceData> <DataItem> <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord"> <TraceIdentifier>Archer.NET</TraceIdentifier> <Description>VIEW SERVER STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action.</Description> <AppDomain>ArcherTech.JobFramework.Job.exe</AppDomain> <Exception> <ExceptionType>System.Data.SqlClient.SqlException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType> <Message>VIEW SERVER STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action.</Message> <Source>.Net SqlClient Data Provider</Source> <ContextData> <HelpLink.ProdName>Microsoft SQL Server</HelpLink.ProdName> <HelpLink.ProdVer>14.00.1000</HelpLink.ProdVer> <HelpLink.EvtSrc>MSSQLServer</HelpLink.EvtSrc> <HelpLink.EvtID>300</HelpLink.EvtID> <HelpLink.BaseHelpUrl>http://go.microsoft.com/fwlink</HelpLink.BaseHelpUrl> <HelpLink.LinkId>20476</HelpLink.LinkId> </ContextData> <StackTrace> 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.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at ArcherTech.Kernel.Jobs.ArcherConfigurationReport.SqlHelper.ExecuteReader[T](String connectionString, String query, Func`2 handler) at ArcherTech.Kernel.Jobs.ArcherConfigurationReport.ReportDataSources.SqlServerReportDataSource.GetReportData(SqlConnectionString connection)</StackTrace> </Exception> </TraceRecord> </DataItem> </TraceData> </ApplicationData>
|