SQL metadata is not shown in the UI when proper permissions are in place.
Stack trace:
Exception chain:
Logon failure: the user has not been granted the requested logon type at this computer
The specified metadata credentials are invalid. The following errors occurred during the credentials validation: Logon failure: the user has not been granted the requested logon type at this computer
Call to service method managementservice:Replay.Core.Contracts.Agents.IAgentsManagement SetAgentMetadataCredentials failed: The specified metadata credentials are invalid. The following errors occurred during the credentials validation: Logon failure: the user has not been granted the requested logon type at this computer
Replay.Core.Contracts.Agents.InvalidCredentialsException: The specified metadata credentials are invalid.
The following errors occurred during the credentials validation:
Logon failure: the user has not been granted the requested logon type at this computer
---> Replay.Core.Contracts.Sql.CannotGetSqlMetadataException: Logon failure: the user has not been granted the requested logon type at this computer
--- End of inner exception stack trace ---
Server stack trace:
at ServiceHost.InMemoryHosting.InMemoryServiceHost.InvokeServiceMethod(String managementService, String method, IEnumerable`1 parameters)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at ServiceHost.InMemoryHosting.CrossDomainCall.Call()
at ServiceHost.InMemoryHosting.InMemoryClientProxy.InvokeMethodNoReturn(String managementService, String method, IEnumerable`1 parameters)
at WCFClientBase.ClientBase.ExecuteInMemoryServiceCall(String managementService, String method, IEnumerable`1 parameters)
---> (Inner Exception #0) Replay.Core.Contracts.Sql.CannotGetSqlMetadataException: Logon failure: the user has not been granted the requested logon type at this computer
<---
Error from Agent logs:
WARN 2014-08-29T13:27:12 [16] - Replay.Common.Implementation.Sql.SqlInteractionHelper ()
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.
Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
System.ComponentModel.Win32Exception (0x80004005): Logon failure: the user has not been granted the requested logon type at this computer
at Replay.Common.Implementation.Utilities.Impersonation.Impersonator.ImpersonateValidUser(String userName, String domain, String password)
at Replay.Common.Implementation.Sql.SqlInteractionHelper.<Connect>b__1()
at System.Threading.ThreadLocal`1.CreateValue()
at System.Threading.ThreadLocal`1.get_Value()
at Replay.Common.Implementation.Sql.SqlInteractionHelper.Connect()
DEBUG 2014-08-29T13:27:12 [16] - Replay.Common.Implementation.Metadata.Sql.SqlMetadataService ()
MSSQLSERVER: Get full SQL instance metadata took: 00:00:00.0422606
If you are experiencing this product defect, please upgrade your AppAssure Core to build 5.4.3.106 to resolve the issue. It is strongly recommended to download and install the latest Update Patch as well.
For more information on upgrading your AppAssure Core to 5.4.3.106, please reference Knowledge Article 129085 - How to Upgrade the AppAssure Core.
For more information on the AppAssure Patching process, please reference Knowledge Article 126791 - Applying Patches to the 5.4.X Core.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center