Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, March 21, 2013 12:34 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 24, 2014 6:52 PM
Points: 194, Visits: 921
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>

Issue:
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

Resolution:
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!

P.S.

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.


Bazinga!
Post #1433601
Posted Tuesday, July 09, 2013 2:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 01, 2013 11:51 AM
Points: 2, Visits: 68
Ever get an answer on this? I'm having the same problem.


Post #1471867
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse