Port Requirements for Mount Point Support

Support for mount points was added in SQL Sentry version 5.5. For supported Windows OS versions prior to Windows 2008 R2 and Windows 7 the default communications ports needed for this feature should be covered by those needed for RPC (port requirements)

For Windows 2008 R2 and Windows 7 the default communications port is port 5895. This is primarily because VDS uses WinRM (Windows Remote Management) 2.0 to communicate remotely in the newer versions of Windows. See the following TechNet article for information on this change: http://technet.microsoft.com/en-us/library/ee922665(WS.10).aspx

If the watched server is Windows 2008 R2 or Windows 7, and the built-in software firewall is being used, the following command can be run from a command prompt with elevated permissions (Run As Administrator). It should open any necessary ports to allow SQL Sentry to collect mount point information:

netsh advfirewall firewall set rule group="Remote Volume Management" new enable=yes

When executing this command on a server that is already watched by SQL Sentry Performance Advisor, you should use the “Scan for Configuration Changes” option from the device context (right click) menu in the SQL Sentry console’s navigator pane. You should also close and reopen the Performance Advisor console if it was already open for that server.

Also keep in mind that this rule needs to be added on both ends of the communication pipeline as discussed in the following article: http://social.technet.microsoft.com/Forums/en/winserverfiles/thread/22ca1d25-05b5-416c-bf9b-b301a2065d31

Additional and more technical information can be found on this subject at the following locations:http://msdn.microsoft.com/en-us/library/aa384372(VS.85).aspxhttp://blogs.msdn.com/wmi/archive/2009/07/22/new-default-ports-for-ws-management-and-powershell-remoting.aspx

Have more questions? Submit a request


Please sign in to leave a comment.