Sometimes you want to know which DSN is being used in your Intelligence Server. It is very simple to know that.
You just have to:
1. Open regedit. Go to Start -> Execute -> Type: regedit -> hit enter.
This window will appears to you:
2. Browse to this folder:
HKEY_LOCAL_MACHINE -> SOFTWARE -> Wow6432Node -> Microstrategy ->Data sources ->Castorserver
Click on the Location registry key and see the value of it. This is the metadata DSN used in your IntelligenceServer.
Hope it helps.
God bless you.