Named Pipes Connection

Any use for having Named pipes turned on? Can i turn it off? Will it
be more secure after named pipes is turned off? These servers are
behind a corporate firewall and are not going to be exposed to the
outside world.Extreme security folks would have you turn off named pipes... Inside the
firewall it doesn't bother me personally..
If you do turn it off, be aware that upgrading to the next version of SQL
Server ( in the past) using the upgrade wizard REQUIRES that named pipes be
installed. ( So you might have to turn in back on when you upgrade next
time.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Shaun Farrugia" <far!!!!ugia!!!s@.dte!!!!ener!gy.com> wrote in message
news:u#ZHs7pjDHA.2536@.tk2msftngp13.phx.gbl...
> Any use for having Named pipes turned on? Can i turn it off? Will it
> be more secure after named pipes is turned off? These servers are
> behind a corporate firewall and are not going to be exposed to the
> outside world.
>|||In your environment, turning off named pipes is probably not necessary.
With named pipes, only NT authenticated users can connect to SQL Server so
you can completely control who can connect.
Rand
This posting is provided "as is" with no warranties and confers no rights.