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