how to Enable these Windows Firewall rules using powershell?
I have a few servers where I see a blue question mark on the sql server service, as per the picture below.
This is the solution:
Enabling these Windows Firewall rules did the trick for me
Windows Management Instrumentation (WMI-In)
Windows Management
Instrumentation (DCOM-In)
Is there a way I could achieve this via powershell?
sql-server sql-server-2014 connectivity powershell windows-server-2012
asked Dec 28 '18 at 20:59
marcello miorellimarcello miorelli
5,6431962129
add a comment |
I have a few servers where I see a blue question mark on the sql server service, as per the picture below.
This is the solution:
Enabling these Windows Firewall rules did the trick for me
Windows Management Instrumentation (WMI-In)
Windows Management
Instrumentation (DCOM-In)
Is there a way I could achieve this via powershell?
sql-server sql-server-2014 connectivity powershell windows-server-2012
asked Dec 28 '18 at 20:59
marcello miorellimarcello miorelli
5,6431962129
add a comment |
I have a few servers where I see a blue question mark on the sql server service, as per the picture below.
This is the solution:
Enabling these Windows Firewall rules did the trick for me
Windows Management Instrumentation (WMI-In)
Windows Management
Instrumentation (DCOM-In)
Is there a way I could achieve this via powershell?
sql-server sql-server-2014 connectivity powershell windows-server-2012
asked Dec 28 '18 at 20:59
marcello miorellimarcello miorelli
5,6431962129
I have a few servers where I see a blue question mark on the sql server service, as per the picture below.
This is the solution:
Enabling these Windows Firewall rules did the trick for me
Windows Management Instrumentation (WMI-In)
Windows Management
Instrumentation (DCOM-In)
Is there a way I could achieve this via powershell?
sql-server sql-server-2014 connectivity powershell windows-server-2012
sql-server sql-server-2014 connectivity powershell windows-server-2012
asked Dec 28 '18 at 20:59
marcello miorellimarcello miorelli
5,6431962129
asked Dec 28 '18 at 20:59
marcello miorellimarcello miorelli
5,6431962129
asked Dec 28 '18 at 20:59
marcello miorellimarcello miorelli
5,6431962129
asked Dec 28 '18 at 20:59
marcello miorellimarcello miorelli
5,6431962129
asked Dec 28 '18 at 20:59
marcello miorellimarcello miorelli
5,6431962129
5,6431962129
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You would use the Enable-NetFirewallRule cmdlet:
Enable-NetFirewallRule -Name "WMI-WINMGMT-In-TCP", "WMI-RPCSS-In-TCP"
In order to find the relevant rule names (in order to enable it), you can search existing firewall rules by name by using the Get-NetFirewallRule cmdlet, for example:
Get-NetFirewallRule -Name "*WMI*"
This uses wildcards to final all the rules that contain "WMI" as an example.
answered Dec 28 '18 at 21:16
jadarnel27jadarnel27
4,2421331
Small note, you can shortcut the command by providing both names together. SoEnable-NetFirewallRule -Name 'WMI-WINMGMT-In-TCP','WMI-RPCSS-In-TCP'would have the same effect.
– Shawn Melton
Dec 31 '18 at 16:56
@ShawnMelton Thanks! I don't use PowerShell super often these days, and always forget exactly what syntax to use for passing lists like that. So I just default to multiple commands =) I've updated the answer.
– jadarnel27
Dec 31 '18 at 17:08
Oh, it works either way. Some prefer to use multiple for readability when they are just glancing....as long as it gets the job done.
– Shawn Melton
Jan 1 at 18:01
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f225944%2fhow-to-enable-these-windows-firewall-rules-using-powershell%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You would use the Enable-NetFirewallRule cmdlet:
Enable-NetFirewallRule -Name "WMI-WINMGMT-In-TCP", "WMI-RPCSS-In-TCP"
In order to find the relevant rule names (in order to enable it), you can search existing firewall rules by name by using the Get-NetFirewallRule cmdlet, for example:
Get-NetFirewallRule -Name "*WMI*"
This uses wildcards to final all the rules that contain "WMI" as an example.
answered Dec 28 '18 at 21:16
jadarnel27jadarnel27
4,2421331
Small note, you can shortcut the command by providing both names together. SoEnable-NetFirewallRule -Name 'WMI-WINMGMT-In-TCP','WMI-RPCSS-In-TCP'would have the same effect.
– Shawn Melton
Dec 31 '18 at 16:56
@ShawnMelton Thanks! I don't use PowerShell super often these days, and always forget exactly what syntax to use for passing lists like that. So I just default to multiple commands =) I've updated the answer.
– jadarnel27
Dec 31 '18 at 17:08
Oh, it works either way. Some prefer to use multiple for readability when they are just glancing....as long as it gets the job done.
– Shawn Melton
Jan 1 at 18:01
add a comment |
You would use the Enable-NetFirewallRule cmdlet:
Enable-NetFirewallRule -Name "WMI-WINMGMT-In-TCP", "WMI-RPCSS-In-TCP"
In order to find the relevant rule names (in order to enable it), you can search existing firewall rules by name by using the Get-NetFirewallRule cmdlet, for example:
Get-NetFirewallRule -Name "*WMI*"
This uses wildcards to final all the rules that contain "WMI" as an example.
answered Dec 28 '18 at 21:16
jadarnel27jadarnel27
4,2421331
Small note, you can shortcut the command by providing both names together. SoEnable-NetFirewallRule -Name 'WMI-WINMGMT-In-TCP','WMI-RPCSS-In-TCP'would have the same effect.
– Shawn Melton
Dec 31 '18 at 16:56
@ShawnMelton Thanks! I don't use PowerShell super often these days, and always forget exactly what syntax to use for passing lists like that. So I just default to multiple commands =) I've updated the answer.
– jadarnel27
Dec 31 '18 at 17:08
Oh, it works either way. Some prefer to use multiple for readability when they are just glancing....as long as it gets the job done.
– Shawn Melton
Jan 1 at 18:01
add a comment |
You would use the Enable-NetFirewallRule cmdlet:
Enable-NetFirewallRule -Name "WMI-WINMGMT-In-TCP", "WMI-RPCSS-In-TCP"
In order to find the relevant rule names (in order to enable it), you can search existing firewall rules by name by using the Get-NetFirewallRule cmdlet, for example:
Get-NetFirewallRule -Name "*WMI*"
This uses wildcards to final all the rules that contain "WMI" as an example.
answered Dec 28 '18 at 21:16
jadarnel27jadarnel27
4,2421331
You would use the Enable-NetFirewallRule cmdlet:
Enable-NetFirewallRule -Name "WMI-WINMGMT-In-TCP", "WMI-RPCSS-In-TCP"
In order to find the relevant rule names (in order to enable it), you can search existing firewall rules by name by using the Get-NetFirewallRule cmdlet, for example:
Get-NetFirewallRule -Name "*WMI*"
This uses wildcards to final all the rules that contain "WMI" as an example.
answered Dec 28 '18 at 21:16
jadarnel27jadarnel27
4,2421331
edited Dec 31 '18 at 17:07
answered Dec 28 '18 at 21:16
jadarnel27jadarnel27
4,2421331
answered Dec 28 '18 at 21:16
jadarnel27jadarnel27
4,2421331
answered Dec 28 '18 at 21:16
jadarnel27jadarnel27
4,2421331
4,2421331
Small note, you can shortcut the command by providing both names together. SoEnable-NetFirewallRule -Name 'WMI-WINMGMT-In-TCP','WMI-RPCSS-In-TCP'would have the same effect.
– Shawn Melton
Dec 31 '18 at 16:56
@ShawnMelton Thanks! I don't use PowerShell super often these days, and always forget exactly what syntax to use for passing lists like that. So I just default to multiple commands =) I've updated the answer.
– jadarnel27
Dec 31 '18 at 17:08
Oh, it works either way. Some prefer to use multiple for readability when they are just glancing....as long as it gets the job done.
– Shawn Melton
Jan 1 at 18:01
add a comment |
Small note, you can shortcut the command by providing both names together. SoEnable-NetFirewallRule -Name 'WMI-WINMGMT-In-TCP','WMI-RPCSS-In-TCP'would have the same effect.
– Shawn Melton
Dec 31 '18 at 16:56
@ShawnMelton Thanks! I don't use PowerShell super often these days, and always forget exactly what syntax to use for passing lists like that. So I just default to multiple commands =) I've updated the answer.
– jadarnel27
Dec 31 '18 at 17:08
Oh, it works either way. Some prefer to use multiple for readability when they are just glancing....as long as it gets the job done.
– Shawn Melton
Jan 1 at 18:01
Small note, you can shortcut the command by providing both names together. So
Enable-NetFirewallRule -Name 'WMI-WINMGMT-In-TCP','WMI-RPCSS-In-TCP' would have the same effect.– Shawn Melton
Dec 31 '18 at 16:56
Small note, you can shortcut the command by providing both names together. So
Enable-NetFirewallRule -Name 'WMI-WINMGMT-In-TCP','WMI-RPCSS-In-TCP' would have the same effect.– Shawn Melton
Dec 31 '18 at 16:56
@ShawnMelton Thanks! I don't use PowerShell super often these days, and always forget exactly what syntax to use for passing lists like that. So I just default to multiple commands =) I've updated the answer.
– jadarnel27
Dec 31 '18 at 17:08
@ShawnMelton Thanks! I don't use PowerShell super often these days, and always forget exactly what syntax to use for passing lists like that. So I just default to multiple commands =) I've updated the answer.
– jadarnel27
Dec 31 '18 at 17:08
Oh, it works either way. Some prefer to use multiple for readability when they are just glancing....as long as it gets the job done.
– Shawn Melton
Jan 1 at 18:01
Oh, it works either way. Some prefer to use multiple for readability when they are just glancing....as long as it gets the job done.
– Shawn Melton
Jan 1 at 18:01
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f225944%2fhow-to-enable-these-windows-firewall-rules-using-powershell%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
