MS SQL Server 2012 - DBA Articles

Enable or Disable a Server Network Protocol



All network protocols are installed by SQL Server Setup, but may or may not be enabled. This topic describes how to enable or disable a server network protocol in SQL Server 2012 by using SQL Server Configuration Manager. The Database Engine must be stopped and restarted for the change to take effect. By default, Named Pipes Protocol is disabled mode that needs to enable for Named Instance.

In Windows 8 Environment, to open SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager11.msc (for SQL Server 2012) or SQLServerManager10.msc for (for SQL Server 2008), and then press Enter Key.

In SQL Server Configuration Manager, in the left pane, click SQL Server Services.



In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration. In the console pane, click Protocols for .



In the details pane, right-click the protocol you want to change, and then click Enable or Disable.



To continue, click OK. System displays warning message window. Just click OK.






In the console pane, click SQL Server Services.



In the details pane, right-click SQL Server (), and then click Restart, to stop and restart the SQL Server service.









More Reference URL: http://msdn.microsoft.com/en-IN/library/ms191294%28v=sql.110%29.aspx

* * * * *


Email Your Comment To AUTHOR