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

Quick Links
Home
About Me
System Analyze Method
Dimensional Data Model
Entity Relationship Model
Relational Database Model
Tutorials
MS SQL Server - DBA
SSIS - Video Tutorials
SSAS - Video Tutorials
SSRS - Video Tutorials
SQL Server White Papers
Programming in SQL Server
Help Us
Contact Me
R.K.Prem Nath
Madurai District
Tamil Nadu, India

[email protected]
[email protected]
Terms Of Use                                                  Protected by Copyscape Online Plagiarism Tool             Copyrights © . Data-e-Education. All Rights Reserved.