![sql server management studio 17 configuration manager sql server management studio 17 configuration manager](https://kb.supremainc.com/knowledge/lib/exe/fetch.php?media=en:1x_sql_auth_id_013.png)
- #Sql server management studio 17 configuration manager how to#
- #Sql server management studio 17 configuration manager windows#
Open Microsoft Management Console (mmc) by typing in mmc.exe in start menu. To open SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager12.msc (for SQL Server 2014 (12.x)) or SQLServerManager11.msc (for SQL Server 2012 (11.x)), and then press Enter. Steps to open SQL Server Configuration Manager.
#Sql server management studio 17 configuration manager windows#
To access SQL Server Configuration Manager Using Windows 8īecause 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. On the Start menu, point to All Programs, point to Microsoft SQL Server (version), point to Configuration Tools, and then click SQL Server Configuration Manager.Use SQL Server Configuration Manager for the following tasks related to client applications on this computer:įor SQL Server client applications on this computer, specify the protocol order, when connecting to instances of SQL Server.įor SQL Server client applications, create aliases for instances of SQL Server, so that clients can connect using a custom connection string.įor more information about each of these tasks, see F1 help for each task. SQL Server clients connect to SQL Server by using the SQL Server Native Client network library.
#Sql server management studio 17 configuration manager how to#
Use SQL Server Configuration Manager for the following tasks related to the SQL Server services on this computer:Įnable or disable a SQL Server network protocolįor a short tutorial about how to configure protocols and connect to the SQL Server Database Engine, see Tutorial: Getting Started with the Database Engine. Start SQL Server using trace flags (command line parameters) Use SQL Server Configuration Manager for the following tasks for services:Ĭonfigure services to start automatically or manually, disable the services, or change other service settingsĬhange the passwords for the accounts used by the SQL Server services Using the normal Windows Services dialog to configure any of the SQL Server services might cause the service to malfunction. Although many of these tasks can be accomplished using the Microsoft Windows Services dialog, is important to note that SQL Server Configuration Manager performs additional operations on the services it manages, such as applying the correct permissions when the service account is changed.
![sql server management studio 17 configuration manager sql server management studio 17 configuration manager](https://support.plesk.com/hc/article_attachments/360007350953/Screenshot.png)
SQL Server Configuration Manager manages services that are related to SQL Server. SQL Server Configuration Manager cannot configure versions of SQL Server earlier than MicrosoftSQL Server 2005 (9.x).