Author Posts

October 13, 2017 at 7:54 pm

$RegisteredServers = Get-ChildItem "SQLSERVER:\SQLRegistration\Database Engine Server Group"

foreach( $RegSrv in $RegisteredServers)
{
$RegSrv
}

The above code when run in

1. a Machine where only SQL Client is installed and Registered three servers on it (Connect to servers and Register in Sql Management Studio) and the Result is Server A, Server B, Server C which is perfect

but

2. But I go to Server A where SQL Server 64 bit is installed( Registered Server A, Server B and Server C) and ran the above code in PS,then in this case the result is only one Server A and I don't get Server B and Server C which is wrong

Can Any one help me on this and it would be a great help for me.

Rajkumar

October 14, 2017 at 1:40 pm

This is really more of a SQL Server question, and you might ask someplace like StackOverflow, but my guess is that the server isn't running the client software, and so it doesn't “see” the other servers on the network.