How to Connect Analysis Services Database from Internet?
please provide me the details on How to开发者_高级运维 Connect Analysis Services Database from Internet?
i am using ASp.net and Sql server 2008.
Connect using the servername (DNS-name or IP-name) and the database name. The server needs to allow connections from the internet, and make sure there are no firewalls in between that stops the connection.
If you are looking for a way for allowing your users to connect, a good solution is to use Excel over the web using IIS, HTTPS and the msmdpump.dll. There is an article describing the process here for SQL 2005 http://technet.microsoft.com/en-us/library/cc917711.aspx
or for SQL 2008 http://bloggingabout.net/blogs/mglaser/archive/2008/08/15/configuring-http-access-to-sql-server-2008-analysis-services-on-microsoft-windows-server-2008.aspx
This explains how to connect Excel http://support.microsoft.com/kb/940167
精彩评论