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.
Next we will need to restart mssqlserver service, type the following commands in the command prompt window.
1 2 |
net stop mssqlserver net start mssqlserver |
And that’s all there is to do.
Leave a Reply