07-30-2009, 04:05 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,238
|
|
KB05057 - How to enable TCP/IP and Named Pipes protocols in Microsoft SQL Server
KB05057 - How to enable TCP/IP and Named Pipes protocols in Microsoft SQL Server
Environment
- BlackBerry® Enterprise Server version 4.1 to 5.0
- Microsoft® SQL Server® 2000
- Microsoft® SQL Server® 2005 Enterprise Edition
- Microsoft® SQL Server® 2005 Express
Overview
To turn on named pipes for Microsoft SQL Server Desktop Engine (MSDE) or Microsoft SQL Server 2000, complete the following steps:
- Click Start and select Run.
- Type SVRNETCN and click OK.
- Highlight Named Pipes and select the Enable button.
- Highlight TCP/IP and click the Enable button again.
- Verify Named Pipes and TCP/IP are listed in the Enabled Protocols list.
- Click OK.
- Restart the Microsoft SQL Server service to turn on the network protocols.
To turn on named pipes for Microsoft SQL Server 2005, complete the following steps:
- Launch the Microsoft SQL Server Configuration Manager.
- Under the Microsoft SQL Server 2005 Network Configuration, select Protocols for the Microsoft SQL Server instance.
- Right-click on Named Pipes and click Enable.
- Right-click on TCP/IP and click Enable.
- Restart the Microsoft SQL Server service to turn on the network protocols.
Additional Information
The TCP/IP and Named Pipes network protocols may not be turned on by default due to security functionality in Microsoft SQL Server 2005.
__________________
http://blog.port3101.org/hdawg/
The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
|
Linear Mode
