Sunday, February 12, 2012

Analysis Services Deployment/Management Question

I have a local server for development that is on my local domain that I can work on very easily. However, my production server is offsight and on a different domain. Since Management Studio will only allow Windows Authentication when connecting to an Analysis Services instance, how can I manage the remote cube without having to remote desktop into the production server?

TIA

Right, you need to either TS to the machine, or establish a VPN connection to the domain. One possible, solution would be to use SQL Managment Studio against your local AS database, and instead of committing the changes, script out the XMLA. Then, if you had an http pump setup on a middle-tier, you could send the XMLA to via http using an admin user basic authentication that you create and you'd have a way to effectively do the administrative actions that you want. This isn't straightforward, but would get the job done.

Hope that helps.

No comments:

Post a Comment