The RPC server is unavailable | SQL with Manoj

SQL Server Configuration Manager Remote

Server / April 14, 2017

In the Open box, type mmc -a to open the Microsoft Management Console in author mode.

On the File menu, click Add/Remove Snap-in.

In the Add/Remove Snap-in window, click Add.

In the Add Standalone Snap-in window, click Computer Management and then click Add.

In the Computer Management window, click Another computer, type the name of the remote computer you wish to manage, and then click Finish.

In the Add Standalone Snap-in window, click Close.

In the Add/Remove Snap-in window, click OK.

Expand Computer Management, and Services and Applications.

Right-click SQL Server Configuration Manager, and then click New Window from here.

On the Window menu, click Console Root, to switch back to the first widow, and delete the window.

On the File menu, click Save As, and save the file in the desired folder, with an appropriate name with the .msc file extension. Close the Microsoft Management Console.

To open SQL Server Configuration Manager on the target computer, double-click the file. If desired, save a link to the file on the desktop or in the Start menu.

Source: technet.microsoft.com