Disabling Named Pipes
-
Hi
I am an IT auditor and working on my first SQL server audit. One of my audit tests is to Verify that the Named Pipes protocol is disabled, unless there is a documented justification. My contact person told me “I disabled the Named Pipes in the SQL Native Client Config (Prod Server) but could not do so in the test and dev servers; it kept changing back to “Enabled”.”
When I followed up he told me "Given that we are not running multiple instances of SQL server on the same hardware, Names Pipes does not come into play. In other words, for the SQL Server configurations, Named Pipes does not pertain, regardless of these Named Pipe settings."
Does this sound reasonable to you SQL experts?
I posted this originally in the SQL Server Admin forum but then looked and the activity in there did not look promising. Sorry for the double post.
-
rook372000 (9/28/2012)
HiI am an IT auditor and working on my first SQL server audit. One of my audit tests is to Verify that the Named Pipes protocol is disabled, unless there is a documented justification. My contact person told me “I disabled the Named Pipes in the SQL Native Client Config (Prod Server) but could not do so in the test and dev servers; it kept changing back to “Enabled”.”
When I followed up he told me "Given that we are not running multiple instances of SQL server on the same hardware, Names Pipes does not come into play. In other words, for the SQL Server configurations, Named Pipes does not pertain, regardless of these Named Pipe settings."
Does this sound reasonable to you SQL experts?
I posted this originally in the SQL Server Admin forum but then looked and the activity in there did not look promising. Sorry for the double post.
Try disabling it in the "SQL Server Network configuration".;-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply