please provide me the details on How to Connect Analysis Services Database from Internet?
i am using ASp.net and Sql server 2008.
+1
A:
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.
Jonas Lincoln
2010-01-07 09:48:15
but what steps i shld follow
ManishKumar1980
2010-01-08 06:40:57
You have to provide more details about your problem before we can give you a better answer. Please update your question with information about what software you're using, error messages, etc.
Jonas Lincoln
2010-01-08 07:27:09
+1
A:
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
This explains how to connect Excel http://support.microsoft.com/kb/940167
duckworth
2010-01-08 15:07:14