question

vivekchandra09 avatar image
vivekchandra09 asked

Named Pipe, SQL Serer 2008 R2

Our third party vendor is recommending that we disable Named Pipe. " For all our clients we are currently configuring SQL server connections using TCP/IP including cognos connections for reporting. Till now turning off named pipes on other clients have not produced any errors with the connections. We believe that turning off names pipes might also resolve the intermittent communication link failures as well." Our analyst are concerned that the cognos reports might not run. Please advise.
third-party-toolscognos
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
David Wimbush avatar image
David Wimbush answered
Does the vendor (vendor of what product by the way?) give a reason? They really should and I would press them if they can't. You don't want to go changing server settings just because some vendor says so. If you're convinced, then I would see what protocol Cognos is connecting with. You can look in sys.sysprocesses to find out. If it's using Named Pipes, does it have to? If not, is anything else using Named Pipes? If not, no problem. (Although disabling a protocol will require a SQL Server service restart.)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.