Return
-
Title
SQL warning message on summary page of agent and unable to set SQL credentials -
Description
-
Cause
The agent is unable to communicate with the local SQL instance due to Microsoft SQL Server 2008 R2 Shared Management Objects (x64) pre-requisite is not installed or corrupted as the following warning message is seen in the AppAssure Agent logs.Failed to connect to the Sql Server using default protocolSystem.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.SqlClrProvider, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.File name: 'Microsoft.SqlServer.SqlClrProvider, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'at Microsoft.SqlServer.Management.Common.ConnectionManager.CallerHavePermissionToUseSQLCLR()at Microsoft.SqlServer.Management.Common.ConnectionManager..ctor(SqlConnectionInfo sci)at Microsoft.SqlServer.Management.Common.ServerConnection..ctor(SqlConnectionInfo sci)at Replay.Common.Implementation.Metadata.Sql.ServerConnectionHelper.ToServerConnection(ConnectionInfo connectionInfo, String serverName, NetworkProtocol protocol)at Replay.Common.Implementation.Metadata.Sql.ServerConnectionFactory.TryConnect(IServerConnectionBuilder connectionBuilder, ConnectionInfo connectionInfo, TimeSpan connectionTimeout, TimeSpan executionTimeout, List`1 connectionExceptions, String protocol, String[] enabledProtocols, ServerConnection& connection) -
Resolution
- Run a repair of AppAssure Agent installation and install any required Prerequisites.