Whilst taking part in a Microsoft SQL RAP using the RAP as a Service Client I stumbled upon the following error whilst trying to gather data from a remote server on our domain.
RPC server is unavailable 0x800706ba failed to create logman
The 'Target' server was an MS Windows Server 2008 R2 with the data collector server residing in MS Windows 2012.
To resolve this issue I had to open a number of Firewall rules.
This is in the pre-requisites document but I hadn't noticed until I had googled it.
I also enabled the Performance Logs and Alerts TCP-In rules too for good measure.
Taken from the SQL RAP pre-requisites pdf.
Configure the server firewall to ensure all SQL Server hosts running Windows Server 2008/R2 and higher have “Remote Event Log Management” enabled: RAP as a Service Client might be unable to collect event log information from a Windows Server 2008/R2 or higher SQL Servers hosts if “Remote Event Log Management” has not been allowed. When “Remote Management” is enabled, the rules that allow Remote Event Log Management are also enabled.
To test if the tool will be able to collect event log data from a Windows Server 2008 R2 SQL Server host you can try to connect to the Windows Server 2008/R2 server using eventvwr.msc. If you are able to connect, collecting event log data is possible. If the remote connection is unsuccessful you may need to enable the Windows built-in firewall to allow “Remote Event Log Management”."
RPC server is unavailable 0x800706ba failed to create logman
The 'Target' server was an MS Windows Server 2008 R2 with the data collector server residing in MS Windows 2012.
To resolve this issue I had to open a number of Firewall rules.
This is in the pre-requisites document but I hadn't noticed until I had googled it.
I also enabled the Performance Logs and Alerts TCP-In rules too for good measure.
Taken from the SQL RAP pre-requisites pdf.
Configure the server firewall to ensure all SQL Server hosts running Windows Server 2008/R2 and higher have “Remote Event Log Management” enabled: RAP as a Service Client might be unable to collect event log information from a Windows Server 2008/R2 or higher SQL Servers hosts if “Remote Event Log Management” has not been allowed. When “Remote Management” is enabled, the rules that allow Remote Event Log Management are also enabled.
To test if the tool will be able to collect event log data from a Windows Server 2008 R2 SQL Server host you can try to connect to the Windows Server 2008/R2 server using eventvwr.msc. If you are able to connect, collecting event log data is possible. If the remote connection is unsuccessful you may need to enable the Windows built-in firewall to allow “Remote Event Log Management”."
No comments:
Post a Comment