Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Maryland
    Posts
    3

    Unanswered: Disable named pipes on W2k/SQL2k cluster?

    I have a cluster running on Windows 2000 with SQL 2000. In SQL Server Network Utility I can highlight named pipes but I cannot disable it. Does anyone know why and better yet should this not be done?

  2. #2
    Join Date
    Aug 2003
    Location
    Maryland
    Posts
    3

    For those who care an answer to my question

    You can no longer disable Named Pipes on SQL clusters as of SQL SP3. MS PSS has acknowledged this change although they have yet to document it anywhere.



    The reasons given for this change:



    1) If other protocols failed, they wanted at least one protocol to be available. For example if TCP/IP is enabled yet SQL Server fails to bind on 1433, Named Pipes should still be able to respond.

    2) Prior to SQL SP3, if you disabled Named Pipes and re-enabled it you would an encounter an issue where the local machine name would be populated rather than the virtual server name. For example: \\.\pipe\$$\local machine name\sql\query instead of \\.\pipe\$$\virtual server name\sql\query

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •