PowerShell question

• StillaLearner

  SSCrazy

  Points: 2636

  More actions

  August 20, 2018 at 8:16 pm

  #367394

  Hi All
  trying to understand why when I issue a PowerShell connect against two servers they give me different results
  The PowerShell command I am issuing is

  New-Object ('Microsoft.SqlServer.Management.Smo.Server') 'servername'

  On one server it returns a fully rich set of values on another just minimal. The error I get on server2 is that the RPC service is unavailable but I check and it is there and running
  Both Servers are Windows 2012 R2 - however server1 is SQL 2016 and Server2 is SQL 2014

  Am I missing something on server2?

  thanks