Are there queries to determine which database protocols are enabled on an SQL Server?

  • Does anyone happen to know if there are queries available that could be used to determine which database protocols are enabled on the SQL server and then what the settings are for those protocols? (For example, determining if TCP/IP was enabled and then port it was using.)

    Thanks for your assistance.

  • If you're dealing with SQL Server 2005, then yes.

    SELECT * FROM sys.endpoints

    After that, you can view the various endpoint views. See the Books Online topic Endpoints Catalog views for the complete list.

    K. Brian Kelley
    @kbriankelley

  • Do you know if there are any queries available for SQL 7 and SQL 2000?

  • I don't think there are queries for this. I'd assume it's in the registery, so perhaps you can xp_regread the data out of there. Might need multiple queries.

  • You should be able to read this from the registry. But why would you want to determine the network protocol settings via SQL?

    Best Regards,

    Chris Büttner

Viewing 5 posts - 1 through 5 (of 5 total)

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