How can we help you today? How can we help you today?
MWnewbie
Activity overview Badges (0) Posts (0) Comments (4)

Activity overview

Latest activity by MWnewbie

@Ben_P These are elevated permissions, from a security perspective, just to be able to run and create a test case. Is there any other way to run SQL Test where the user is not an admin on the database? / comments
  1. Community
  2. SQL Test
  3. Required permission to use SQL Test on SQL Server database
@Ben_P These are elevated permissions, from a security perspective, just to be able to run and create a test case. Is there any other way to run SQL Test where the user is not an admin on the datab...
0 votes
I'll check this with the OPS guys who might have more permissions than I do. I'm not able to give these roles on a database level. / comments
  1. Community
  2. SQL Test
  3. Required permission to use SQL Test on SQL Server database
I'll check this with the OPS guys who might have more permissions than I do. I'm not able to give these roles on a database level.
0 votes
Hi @Ben_P, After the installation on the database, one user tries to run a test and gets the following permissions error message -  SQLCover.SqlCoverException: SQL Cover failed to start. ---> System.InvalidOperationException: Error creating the extended events trace, error: User does not have permission to perform this action. ---> System.Data.SqlClient.SqlException: User does not have permission to perform this action. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at SQLCover.Gateway.CommandWrapper.b__5_0() at SQLCover.Gateway.CommandWrapper.OpenConnectionAndDo[T](Func`1 func) at SQLCover.Gateway.CommandWrapper.ExecuteNonQuery() at SQLCover.Gateway.DatabaseGateway.Execute(String query) at SQLCover.Trace.TraceController.RunScript(String query, String error) --- End of inner exception stack trace --- at SQLCover.Trace.TraceController.RunScript(String query, String error) at SQLCover.Trace.AzureTraceController.Create() at SQLCover.Trace.AzureTraceController.Start() at SQLCover.CodeCoverage.Start() --- End of inner exception stack trace --- Do you have any ideas about what might be missing? Another user logs on to the database but when they go to add the database in SQLTest, they are unable to make a selection as the 'ok' button is greyed out. / comments
  1. Community
  2. SQL Test
  3. Required permission to use SQL Test on SQL Server database
Hi @Ben_P,After the installation on the database, one user tries to run a test and gets the following permissions error message - SQLCover.SqlCoverException: SQL Cover failed to start. ---> System....
0 votes
Thanks Ben_P. I'll go through the documentation and see how far I get. / comments
  1. Community
  2. SQL Test
  3. Required permission to use SQL Test on SQL Server database
Thanks Ben_P. I'll go through the documentation and see how far I get.
0 votes
Total activity
5
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1