Where is SQL Server Configuration Manager in Windows10?

Source: Internet
Author: User
Tags aliases documentation failover management studio sql server management sql server management studio

SQL Server Configuration Manager is a tool that manages the services associated with SQL Server, configures the network protocols that SQL Server uses, and manages network connection configuration from SQL Server client computers.SQL Server Configuration Manager is a Microsoft Management Console snap-in that can be accessed through the Start menu, or it can be added to the display interface of any other Microsoft Management console. the Microsoft Management Console (mmc.exe) uses the Sqlservermanager10.msc file in the Windows System32 folder to open SQL Server Configuration Manager.

SQL Server Configuration Manager and SQL Server Management Studio use Window Management Instrumentation (WMI) to view and change some server settings.WMI provides a unified way to connect with API calls that manage the registry operations requested by SQL Server Tools, and provides enhanced control and manipulation of the SQL Server selected by the SQL Servers Configuration Manager snap-in component. For information about WMI-related permissions configuration, see Configuring WMI in SQL Server tools to display server state.

To start, stop, pause, resume, or configure services on another computer by using SQL Server Configuration Manager, see Connect to another computer (SQL Server Configuration Manager).

Using Windows 8 to access SQL Server Configuration Manager

Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a separate program, SQL Server Configuration Manager does not appear as an application when you run Windows 8 o'clock.to open SQL Server Configuration Manager, in the search charm, under applications , type sqlservermanager12.msc (for SQL Server 2014) (for SQL Server 2012 is sqlservermanager11.msc, for SQL Server 2008 is sqlservermanager10.msc), and then press Enter.

Management Services use SQL Server Configuration Manager to start, pause, resume, or stop services, and to view or change service properties.

Use SQL Server Configuration Manager to start the database engine from the startup parameters. For more information, see Configure Server Startup options (SQL Server Configuration Manager).

change the account used by the service Use SQL Server Configuration Manager to manage SQL Server services.
Important issues

Always use SQL Server tools, such as SQL Server Database engine Configuration Manager, to change the account that is used by SQL Server or the SQL Server Agent service, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager can perform additional configuration, such as setting permissions in the Windows registry so that the new account can read SQL Server settings. If the service cannot access the SQL Server portion of the registry, the service may not start correctly.

Another advantage is that passwords changed with SQL Server Configuration Manager, SMO, or WMI can take effect immediately without restarting the service.

managing server and client network protocolsUse SQL Server Configuration Manager to configure server and client network protocols and connectivity options.After you enable the correct protocol, you typically do not need to change the server network connection. However, if you need to reconfigure the server connection so that SQL Server listens on a specific network protocol, port, or pipeline, you can use SQL Server Configuration Manager. Enable or disable the server network protocol. " > For more information about enabling protocols, see enable or disable a server network protocol. Configure Windows firewall to allow SQL Serve R access. " > For information about enabling access to protocols through a firewall, see Configure Windows Firewall to allow SQL Server access.

Use SQL Server Configuration Manager to manage server and client network protocols, including features such as enforcing protocol encryption, viewing alias properties, or enabling/disabling protocols.

Using SQL Server Configuration Manager, you can create or delete aliases, change the order in which protocols are used, or view the properties of server aliases, including:

    • server alias-the server alias of the computer to which the client is connected.

    • protocol-the network protocol used to configure the entry.

    • connection parameters-parameters associated with the connection address used for the network protocol configuration.

Although some operations, such as starting and stopping a service, should use Cluster Administrator, you can also view information about the failover cluster instance by using SQL Server Configuration Manager.

Available Network Protocols

SQL Server supports the Shared Memory, TCP/IP, and Named Pipes protocols.For information about choosing a network protocol, see Configuring client protocols.SQL Server does not support VIA, Banyan Vines Sequential Package Protocol (SPP), Multiprotocol, AppleTalk, or NWLink ipx/spx network protocols. clients previously connected using these protocols must select a different protocol to connect to SQL Server. To configure the WinSock proxy, see the ISA Server documentation.

Today debug discovers that the SQL Server that connects native is, use native IP address, also have 127.0.0.1 address, can't connect to database, consider the reason that TCP/IP protocol is not enabled in SLQ Server network configuration in SQL Server Configuration Manager, However, you can't find SQL Server Configuration Manager in the Program menu, so look at the path to SQL Server Configuration Manager on the win2008 R2 machine and discover that it is not a shortcut to an entity app, but a "command", specifically: C:\Windows\ SYSWOW64\MMC.EXE/32 C:\Windows\SysWOW64\SQLServerManager10.msc; You can save it and put it on a point call.

Where is SQL Server Configuration Manager in Windows10?

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.