Connect to Another Computer (SQL Server Configuration Manager)

This topic describes how to connect to another computer in SQL Server 2012. Follow the first procedure to open the Windows Computer Management Microsoft Management Console (mmc), connect to the computer, and expand the Services and Applications tree. Follow the second procedure to create a file with a link to the SQL Server Configuration Manager on a remote computer.

Note

Some actions cannot be performed by Configuration Manager when connecting remotely.

To start, stop, pause, or resume services on another computer, you can also connect to the server with SQL Server Management Studio, right-click the server or SQL Server Agent and then click the desired action.

To connect to another computer with Windows Computer Management

  1. On the Start menu, right-click My Computer, and then click Manage.

  2. In Computer Management, right-click Computer Management (Local), and then click Connect to another computer.

  3. In the Select Computer dialog box, in the Another computer text box, type the name of the computer you want to manage, and then click OK.

    Computer Management displays the services running on the remote computer. The top-level node changes to Computer Management <remotecomputer>.

  4. In the console tree, expand Services and Applications, and then expand SQL Server Configuration Manager to manage the remote computer's services.

  1. On the Start menu, click Run.

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

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

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

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

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

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

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

  9. Expand Computer Management (<computer name>), and Services and Applications.

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

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

  12. 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.

  13. 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.

Warning

When using SQL Server Configuration Manager on a remote computer, the computer name is not obvious and it is possible to mistakenly stop or configure the wrong computer. On the Service tab, check the Host Name box to confirm the computer name before modifying a service.

To access SQL Server Configuration Manager Using Windows 8

Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration Manager not does not appear as an application when running Windows 8. To open SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager11.msc (for SQL Server 2012) or SQLServerManager10.msc for (SQL Server 2008), and then press Enter.

See Also

Concepts

Configure WMI to Show Server Status in SQL Server Tools