How do I go about adding SQL DBs to a Service Map when the SQL Server Instance is shared?

[Annita]

We have a lot of shared infrastructure in our company. I have updated the connection section of the MSSql DB On Windows pattern to look for specific DBs however, since many of our SQL Server Instances are shared, the Service Map will display all of the SQL DBs in that instance (even ones that don't belong to the application being mapped) Any ideas on how to get around this?

[Rahul Priyadars]

Which application uses  which Instance - in case of Share SQL Instance let say 2 application points to same instance

Now Inside the shared instance which database is for which application---> Only legacy knowledge of the app or some app config file can give this information. But when discovery/mapping will run it will simply scan

DBS existing on given Instance independent of which app .

So either in some nice naming convention of DB may help or in DB class have an attribute which points to the given app for information purpose.

Regards

RP

[jimmillet]

I have the same question - how to add connection from SQL instance to SQL database in the Service Map. Currently I am building the connection from IIS to the SQL Instance in a new connection section in "IIS Virtual Directory" pattern. I see a number 8 on the connection line bettwen II and MS SQL Instance, and it is for the 8 SQL databases that are part of this instance. I know EXACTLY which one of the 8 is part of the mapped application from the connection string that is in the XML file parsed on the IIS server that was used to create the connnection to the instance. The connection step in the pattern did not use the database, but since I know which DB, i want to use this somehow, so all 8 are not flagged as part of the map.

[J_ssica]

Hi,

I have a similar problem, did you manage to find a solution?

Regards,

JP