Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Cannot scan a remote server with SQL Server BPA 1.0 Expand / Collapse
Posted Thursday, March 21, 2013 12:34 AM



Group: General Forum Members
Last Login: Wednesday, November 12, 2014 5:32 AM
Points: 194, Visits: 942
Hello gents

I am using Microsoft SQL Server 2008 R2 BPA 1.0 wrapped in Microsoft Baseline Configuration Analyzer 2.0 on my workstation and can perform normal scan on my local sql server instance. However, when I tried it to connect to a remote server, it kept reporting the following error:

Category: Prerequisite

Source: <servernmae>

1. User is not a member of Administrators group on remote machine, OR
2. Powershell Remoting is not Enabled on Remote Server

Impact: Analysis cannot be performed

1. Add user as a member of Administrators group, OR
2. Run Commands Enable-PSRemoting -f through PowerShell command prompt using elevated privileges, AND
3. Run Command winrm set winrm/config/winrs `@`{MaxShellsPerUser=`"10`"`} through PowerShell command prompt using elevated privileges

I've verfied all three pre-requisites (being a local admin for my own AD account, executed the ps commands with elevated privileges) listed above and also turned off Windows Firewall on this target server but still have no luck at all.

Do you have any other directions to point out for me?

Thanks in anticipation!


The target server is not clustered, just a standalone physical box; both my worksation and the server are in the same domain; my AD account has been explicitly added to local windows admin group and sysadmin role on the server and its hosted sql instance.

Post #1433601
Posted Tuesday, July 9, 2013 2:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 8, 2016 10:30 AM
Points: 3, Visits: 92
Ever get an answer on this? I'm having the same problem.

Post #1471867
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse