locked
MAP toolkit 9.5 not finding all SQL Server instances RRS feed

  • Question

  • Hi,

    Here's my issue.

    Remote server 
    •Microsoft SQL Server 2008 R2 Enterprise Edition (64-bit)
    •Windows 2008R2 Enterprise

    MAP / Local Server
    •Microsoft SQL Server  Server 2014 Express Edition  (x64)
    •Microsoft Windows Server 2012 R2 Datacenter

    Remote server has 5 SQL Server Instances running on it:
    •INST1 - Disabled
    •INST2 - Enabled
    •DEV1 - Enabled
    •DEV2 - Enabled
    •DEV2008_1 – Enabled

    When I run the MAP toolkit 9.5.8.0 from the MAP server, the SQL inventory reports lists only 2 instances (INST1 and INST2) on the server. Why is the report missing some instances?

    MAP optons

    Senario
    •SQL Server
    •SQL Server with Database Details

    Discovery Methods
    •Use Active Directory Domain Services (AD DS)

    Other notes:
    •SQL Browser is running on remote computer
    •Account use to connect to remote computer has local admin on the remote server.


    Hopefully someone can help me otherwise I can’t use the MAP toolkit with confidence.


    Thanks

    Manish

    Thursday, January 26, 2017 11:02 AM

All replies

  • I posted earlier in the SQL Server forum and given some useful tips but no resolution.

    Was provided some suggestions regarding opening ports, restarting SQL Browser but no luck.

    Still missing instances which were created recently.

    Thanks

    Thursday, January 26, 2017 11:04 AM