So we have a server running EC 5.0, that uses a different MS-SQL server hosting the SOPHOS50 db. All this is working. We now have a license for Patch. On this MS-SQL server the SOPHOSPATCH DB was installed. I had the DBA team populate the DB with the scripts and stored procedures from the install directory.
Each time I try to use patch I get errors about stored procedures not found...etc. Where in the register or EM do I find the place that tells it to point to the SOPHOSPATCH db?
Error when trying to opwn the Patch Event viewer in EC, but these exist in the SOPHOSPATCH db on the MS-SQL server:
Sophos.UIController.Extension.UIControllerException: The communication has failed when invoking the requested operation. ---> System.ServiceModel.FaultException: PatchFrontEnd.LoadReportFilters : System.Data.SqlClient.SqlException : Could not find stored procedure 'dbo.usp_pr_PatchFilterValues'.
Server stack trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
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 Sophos.Patch.ServerCommunicator.IAdminConsole.LoadReportFilters(String configName, String userToken) at Sophos.PatchUI.ExtensionModule.DataProviders.PatchServiceInterface.<get_ReportFilters>b__0() at Sophos.UIController.Product.Logging.LogMethod(MemberInfo method, Action func) --- End of inner exception stack trace --- at Sophos.UIController.Product.Logging.LogMethod(MemberInfo method, Action func) at Sophos.PatchUI.ExtensionModule.DataProviders.PatchServiceInterface.get_ReportFilters() at Sophos.PatchUI.ExtensionModule.PatchReportViewModel..ctor() at Sophos.PatchUI.ExtensionModule.PatchHandler.GetContent(IntPtr parent, String contentId, Object[] args) at Sophos.UIController.Product.Administration.Launch(IntPtr parent, String contentId, Object[] args) at Sophos.UIController.Patch.PatchProduct.LaunchPatchSetEditor(IntPtr parent)
----- [outer exception] ----- -- error: 0x80040507 -- facility: Custom (Defined by the interface)
at __w64 long __thiscall CMainFrame::OnViewPatchEvents(unsigned short,unsigned short,struct HWND__ *,int &) at int __cdecl Run(int,class bl::CommandLine,enum bl::ConsoleType::Type) at int __stdcall wWinMain(struct HINSTANCE__ *,struct HINSTANCE__ *,wchar_t *,int)
This thread was automatically locked due to age.