How do I configure SQL Server for a successful MAP inventory?
By default, SQL Server is not configured to receive remote connections and Named pipe, TCP/IP protocols are disabled. In order to successfully inventory SQL Server computers in your environment you need to enable one of the protocols. Using SQL Server Configuration Manager, enable either Named Pipe or TCP/IP protocol (with default port of 1433).