search
top

How To Enable Named Pipes and TCP/IP for Microsoft SQL Server 2008 R2 SQLExpress

During a recent installation of HP Insight Manager 7.1 on Windows 2008 R2 server the prerequisites failed complaining about you must enable named pipes and TCP/IP for the existing database service Microsoft SQL Server 2008. After a default install they are usually disabled. This applies to Microsoft SQL Server 2008 Express as well.

To enable named pipes and TCP/IP for Microsoft SQL Server 2008

Click Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager.
Under SQL Server 2008 Network Configuration > Protocols for MSSQLSERVER:

Double-click the protocol name TCP/IP and set the property ENABLED to Yes.
Double-click the protocol name Named Pipes and set the property ENABLED to Yes.

sqlexpress1
Next we will need to restart mssqlserver service, type the following commands in the command prompt window.

net stop mssqlserver
net start mssqlserver

And that’s all there is to do.

Leave a Reply

Your email address will not be published. Required fields are marked *

top