Post reply

Check Named Pipes and TCP/IP on multiple servers

  • July 24, 2008 at 8:18 pm

    #123369

    Hi,

    I have to check whether Named Pipes and TCP/IP is enabled or not on 89 SQL Servers ( all are 2005 ). I am planning to use sqlcmd. I know we can use sqlcmd to detect Database Engine connection using Named Pipes and TCP/IP. But I am stuck in using it to generate a report. Anybody has any idea how I can achieve that. ?

    Thanks in Advance,

    Amit.

  • July 24, 2008 at 10:30 pm

    #848186

    Output the SQLCMD stuff to the same file, appending the data from each. Then you can dig in and build a report.

  • July 25, 2008 at 9:27 am

    #848490

    Thank You.

    Amit.

  • July 25, 2008 at 3:30 pm

    #848713

    Amit Chaudhary (7/24/2008)

    Hi,

    I have to check whether Named Pipes and TCP/IP is enabled or not on 89 SQL Servers ( all are 2005 ). I am planning to use sqlcmd. I know we can use sqlcmd to detect Database Engine connection using Named Pipes and TCP/IP. But I am stuck in using it to generate a report. Anybody has any idea how I can achieve that. ?

    Thanks in Advance,

    Amit.

    Amit,

    Can you share your script?

    Thanks!

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply