Configuring Universal Inventory to work with a LocalDB MAP

Recently I have been working a lot with MAP (Microsoft Assessment and Planning Toolkit) on gathering information about products installed and comparing them with licenses bought. In addition to MAP, which Microsoft provides for free, they also offer incentives for Microsoft Partners and customers to upload their software inventory (also known as SAM) to the cloud to be evaluated by Microsoft and get recommendations on how to reduce costs, migrate to cloud technologies and etc. All this is done with another tool called Universal Inventory.

If you are a Microsoft Partner and you also use MAP to gather software inventory and Universal Inventory to format the data, then you might face an issue like the one I faced today.

You see, Microsoft recommends that you install MAP on top of a SQL Express server – here is the guide on how to do just that. Basically, you need to install SQL Express (2012), name the instance MAPS and make sure your collation is set to ‘SQL_Latin1_General_CP1_CI_AS’.

But, if you chose to install MAP with a LocalDB instance (which is what happens most) then you will face a problem connecting your Universal Inventory to MAP. Microsoft have a nice post on their ‘Partner Community’ site that says, and I quote:

 

A LocalDB of MAP is not the same as a full SQL Express or SQL. A LocalDB uses the user that did the MAP installation as the owner of the LocalDB. This means it is standard not reachable via the Service Account of UI (as that account has no rights to the localDB). The procedure on how to make it work is available but we highly recommend to use SQL Express instead of LocalDB since it will save you some hassles.

Error Connecting to LocalDB

Error Connecting to LocalDB

So it should work, but I could not find any documentation on how to make it work. So I have decided to investigate it by myself. I remembered that one time, I had a problem with my LocalDB and had to connect to it using SQL Server Manager tools (SSMS). By default, you wont be able to do that, unless… you follow Phill’s instructions. 

Once you create the share and expose it, you will be able to configure it on Universal Inventory tool and then collect all the data that is gathered by MAP.

Connected to LocalDB

Connected to LocalDB

Running Query

Running Query

What do you think about this post?