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.
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.)