Can anyone please tell me how to connect to ASR using MSSQL management studio.
I use Oracle SQL Developer to connect to my OpenDB/ASR. Just had to obtain credentials from Bb (username/password), the IP address of your target DB, a port and a SID. I imagine connecting using management studio would be as straight forward. After that, they just needed to whitelist my incoming client IP(s). Easy peasy!
Consider joining and posting in the Bb Learn Data Reporting User Group . You might get additional responses there.
Note that ASR is an Oracle database, so you should follow MS instructions for connecting to Oracle - using Oracle thin client driver software.
Retrieving data ...